Mismapped Data Fields

Hi @pwitzleb,

Thanks for reaching out to us.

We have tested this on our test environments and were unable to replicate the issue. The data were exported to the corresponding columns. Can you please share the WordPress Site Health Info?(Tools>Site Health, select “info” and then “Copy site info to clipboard”)?of your site?

I can confirm both errors, critical error and mismatched fields. I imported 4 orders. When opening the first imported order, at the bottom:
“There has been a critical error on this website. Please check your site admin email inbox for instructions.”

And the fields are mismatched. I checked the import mapping prior to import.
Last name contains Company name
Company name contains email address
etc etc

En error of type e_error 1767 in file: /xxx/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-order.php. Felorsak: Uncaught TypeError: Unsupported operand types: null + string in /xxx/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-order.php:1767
Stack trace:
#0 [internal function]: WC_Abstract_Order->{closure}()
#1 /xxx/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-order.php(1768): array_reduce()
#2 /xxx/staging/wp-content/plugins/woocommerce/includes/admin/meta-boxes/views/html-order-items.php(173): WC_Abstract_Order->get_total_fees()
#3 /xxx/wp-content/plugins/woocommerce/includes/admin/meta-boxes/class-wc-meta-box-order-items.php(40): include(‘/home/xxx/…’)
#4 /xxx/wp-admin/includes/template.php(1445): WC_Meta_Box_Order_Items::output()
#5 /xxx/wp-admin/edit-form-advanced.php(688): do_meta_boxes()
#6 /xxx/wp-admin/post.php(206): require(‘/home/xxx/…’)
#7 {main}
? thrown

I have disabled the plugin and moved on.

Here is our WP Site info. Even with the updated plug-in, the data column headers remain mismatched…

wp-core

version: 6.2
site_language: en_US
user_language: en_US
timezone: America/New_York
permalink: /posts/%category%/%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 23
dotorg_communication: true

wp-paths-sizes

wordpress_path: /nas/content/live/aftddev
wordpress_size: 1.05 GB (1127298520 bytes)
uploads_path: /nas/content/live/aftddev/wp-content/uploads
uploads_size: 8.71 GB (9349776593 bytes)
themes_path: /nas/content/live/aftddev/wp-content/themes
themes_size: 3.75 MB (3930033 bytes)
plugins_path: /nas/content/live/aftddev/wp-content/plugins
plugins_size: 269.70 MB (282803069 bytes)
database_size: 1.60 GB (1714372608 bytes)
total_size: 11.62 GB (12478180823 bytes)

wp-dropins (1)

advanced-cache.php: true

wp-active-theme

name: Beaver Builder Theme (bb-theme)
version: 1.7.13
author: The Beaver Builder Team
author_website: https://www.wpbeaverbuilder.com/?utm_medium=bb-pro&utm_source=bb-theme&utm_campaign=themes-admin-page
parent_theme: none
theme_features: core-block-patterns, woocommerce, widgets-block-editor, post-thumbnails, fl-theme-builder-headers, fl-theme-builder-footers, fl-theme-builder-parts, menus, automatic-feed-links, title-tag, align-wide, wp-block-styles, html5, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, widgets, editor-style
theme_path: /nas/content/live/aftddev/wp-content/themes/bb-theme
auto_update: Disabled

wp-themes-inactive (1)

Beaver Builder Child Theme: version: 1.0, author: The Beaver Builder Team, Auto-updates disabled

wp-mu-plugins (5)

Force Strong Passwords - WPE Edition: version: 1.8.0, author: Jason Cosper
WP Engine Cache Plugin: version: 1.1.2, author: WP Engine
WP Engine Seamless Login Plugin: version: 1.6.0, author: WP Engine
WP Engine Security Auditor: version: 1.0.10, author: wpengine
WP Engine System: version: 5.0.1, author: WP Engine

wp-plugins-active (41)

Advanced Editor Tools: version: 5.9.0, author: Automattic, Auto-updates disabled
Akismet Anti-Spam: version: 5.1, author: Automattic, Auto-updates disabled
Beaver Builder Plugin (Pro Version): version: 2.6.3.3, author: The Beaver Builder Team, Auto-updates disabled
Beaver Themer: version: 1.4.5.1, author: The Beaver Builder Team, Auto-updates disabled
Classy.org: version: 0.1.0, author: Classy, Auto-updates disabled
Cloudflare: version: 4.11.0, author: Cloudflare, Inc., Auto-updates disabled
Code Snippets: version: 3.3.0, author: Code Snippets Pro, Auto-updates disabled
Disable Gutenberg: version: 2.9, author: Jeff Starr, Auto-updates disabled
Enable Media Replace: version: 4.1.1, author: ShortPixel (latest version: 4.1.2), Auto-updates disabled
GDPR Cookie Consent: version: 2.4.0, author: WebToffee, Auto-updates disabled
Imagify: version: 2.1.1, author: Imagify – Optimize Images & Convert WebP, Auto-updates disabled
Import Export WordPress Users and WooCommerce Customers: version: 2.3.9, author: WebToffee, Auto-updates disabled
Live Cart by WP Engine: version: 1.0.1, author: WP Engine, Auto-updates disabled
Max Mega Menu: version: 3.1.1, author: megamenu.com (latest version: 3.2.1), Auto-updates disabled
Max Mega Menu - Pro Addon: version: 2.2.7, author: megamenu.com (latest version: 2.2.8), Auto-updates disabled
Order Export & Order Import for WooCommerce: version: 2.3.3, author: WebToffee, Auto-updates disabled
PDF Invoices & Packing Slips for WooCommerce: version: 3.5.2, author: WP Overnight, Auto-updates disabled
PowerPack for Beaver Builder: version: 2.30.0, author: IdeaBox Creations, Auto-updates disabled
Rank Math SEO: version: 1.0.112, author: Rank Math, Auto-updates disabled
Rank Math SEO PRO: version: 3.0.34, author: Rank Math, Auto-updates disabled
Regenerate Thumbnails: version: 3.1.5, author: Alex Mills (Viper007Bond), Auto-updates disabled
ShareThis Share Buttons: version: 2.1.7, author: ShareThis, Auto-updates disabled
Shortcoder: version: 6.2, author: Aakash Chakravarthy, Auto-updates disabled
Slider Revolution: version: 6.6.12, author: ThemePunch, Auto-updates disabled
Sticky Menu (or Anything!) on Scroll: version: 2.32, author: WebFactory Ltd, Auto-updates disabled
The Events Calendar: version: 6.0.12, author: The Events Calendar, Auto-updates disabled
TranslatePress - Multilingual: version: 2.5.1, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Cristophor Hurduban, Auto-updates disabled
TranslatePress - Personal: version: 1.1.7, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Auto-updates disabled
UpdraftPlus - Backup/Restore: version: 1.23.3, author: UpdraftPlus.Com, DavidAnderson, Auto-updates disabled
Web Accessibility by accessiBe: version: 1.15, author: accessiBe, Auto-updates disabled
WooCommerce: version: 7.6.0, author: Automattic (latest version: 7.6.1), Auto-updates disabled
WooCommerce Extended Coupon Features FREE: version: 3.3.3, author: Soft79, Auto-updates disabled
WooCommerce PayPal Pro (Classic and PayFlow Editions) Gateway: version: 4.4.12, author: WooCommerce, Auto-updates disabled
WooPack for Beaver Builder: version: 1.5.2, author: Team IdeaBox - Beaver Addons, Auto-updates disabled
WordPress Importer: version: 0.8, author: wordpressdotorg, Auto-updates disabled
WP-FormAssembly: version: 2.0.8, author: FormAssembly / Drew Buschhorn, Auto-updates disabled
WP Add Custom CSS: version: 1.1.6, author: Daniele De Santis, Auto-updates disabled
WP All Export: version: 1.3.9, author: Soflyy, Auto-updates disabled
WP Cloud Plugin Share-one-Drive (OneDrive & SharePoint): version: 2.7.2, author: WP Cloud Plugins, Auto-updates disabled
WPCode Lite: version: 2.0.10, author: WPCode, Auto-updates disabled
WP Desk Helper: version: 1.7.0, author: WP Desk, Auto-updates disabled

code-snippets (1)

snippet-3: name: GTAG JS snipet, scope: global, modified: 2022-06-09 04:17:45, tags: [javascript]

wp-media

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1691
imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https://imagemagick.org
imagick_version: 3.7.0
file_uploads: File uploads is turned off
post_max_size: 256M
upload_max_filesize: 256M
max_effective_size: 256 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 137 MB
imagick::RESOURCETYPE_DISK: 1073741824
imagick::RESOURCETYPE_FILE: 786432
imagick::RESOURCETYPE_MAP: 512 MB
imagick::RESOURCETYPE_MEMORY: 256 MB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 9.22337203685E+18
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DJVU, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
gd_version: 2.3.0
gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM
ghostscript_version: not available

wp-server

server_architecture: Linux 5.15.89+ x86_64
httpd_software: nginx
php_version: 8.0.28 64bit
php_sapi: fpm-fcgi
max_input_variables: 10000
time_limit: 43300
memory_limit: 1G
max_input_time: -1
upload_max_filesize: 256M
php_post_max_size: 256M
curl_version: 7.81.0 OpenSSL/3.0.2
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: false

wp-database

extension: mysqli
server_version: 5.7.41-44-log
client_version: mysqlnd 8.0.28
max_allowed_packet: 16777216
max_connections: 500

wp-constants

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /nas/content/live/aftddev/wp-content
WP_PLUGIN_DIR: /nas/content/live/aftddev/wp-content/plugins
WP_MEMORY_LIMIT: 1G
WP_MAX_MEMORY_LIMIT: 512M
WP_DEBUG: true
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

wp-filesystem

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

Hi @pwitzleb,

Could you please share a new sample data export file that is not opened in your system? Also, please try using a different spreadsheet viewer like LibreOffice and check.

Hi @argentum,

Could you please share your import CSV file with which you are facing the issue? You may please remove the user sensitive data from the CSV file before importing.

If you send me an email address…I will send you an attachment of a sample extract with the mapping errors . The field mismatch begins with customer_email…which is populated with the Customer’s first name and NOT email address..and cascades thru the rest of the fields afterwards. Billing first name contains last name. billing company contains the user’s email address, etc.

customer_email billing_first_name billing_last_name billing_company billing_email billing_phone billing_address_1 billing_address_2 billing_postcode billing_city

Hi @pwitzleb,

We have released a new version for the plugin in which the issue is fixed. Please try updating the plugin to the latest version 2.3.4 and check if the issue is resolved or not.