Title: Mismapped Data Fields
Last modified: April 18, 2023

---

# Mismapped Data Fields

 *  Resolved [pwitzleb](https://wordpress.org/support/users/pwitzleb/)
 * (@pwitzleb)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/mismapped-data-fields/)
 * Hello…I’ve confirmed that the export plug-in update (2.3.3) does not result in
   a fatal WordPress error any longer. However, in doing an CSV export, the field
   headers are no longer correct for the corresponding data elements. For example…
   the field customer_email contains the First Name. Billing Company contains the
   email address. Billing_City is now the state. Can you revalidate that the export
   is correctly mapping the data headers? Thank you!

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16675500)
 * Hi [@pwitzleb](https://wordpress.org/support/users/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?
 *  [Argentum](https://wordpress.org/support/users/argentum/)
 * (@argentum)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16680445)
 * 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 nameCompany name contains email addressetc
   etc
 *  [Argentum](https://wordpress.org/support/users/argentum/)
 * (@argentum)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16680471)
 * 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}  thrownI have disabled the plugin and moved on.
 *  Thread Starter [pwitzleb](https://wordpress.org/support/users/pwitzleb/)
 * (@pwitzleb)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16692875)
 * Here is our WP Site info. Even with the updated plug-in, the data column headers
   remain mismatched…
 *     ```wp-block-code
       wp-core
   
       version: 6.2site_language: en_USuser_language: en_UStimezone: America/New_Yorkpermalink: /posts/%category%/%postname%/https_status: truemultisite: falseuser_registration: 0blog_public: 1default_comment_status: openenvironment_type: productionuser_count: 23dotorg_communication: true
   
       wp-paths-sizes
   
       wordpress_path: /nas/content/live/aftddevwordpress_size: 1.05 GB (1127298520 bytes)uploads_path: /nas/content/live/aftddev/wp-content/uploadsuploads_size: 8.71 GB (9349776593 bytes)themes_path: /nas/content/live/aftddev/wp-content/themesthemes_size: 3.75 MB (3930033 bytes)plugins_path: /nas/content/live/aftddev/wp-content/pluginsplugins_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.13author: The Beaver Builder Teamauthor_website: http://www.wpbeaverbuilder.com/?utm_medium=bb-pro&utm_source=bb-theme&utm_campaign=themes-admin-pageparent_theme: nonetheme_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-styletheme_path: /nas/content/live/aftddev/wp-content/themes/bb-themeauto_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 CosperWP Engine Cache Plugin: version: 1.1.2, author: WP EngineWP Engine Seamless Login Plugin: version: 1.6.0, author: WP EngineWP Engine Security Auditor: version: 1.0.10, author: wpengineWP Engine System: version: 5.0.1, author: WP Engine
   
       wp-plugins-active (41)
   
       Advanced Editor Tools: version: 5.9.0, author: Automattic, Auto-updates disabledAkismet Anti-Spam: version: 5.1, author: Automattic, Auto-updates disabledBeaver Builder Plugin (Pro Version): version: 2.6.3.3, author: The Beaver Builder Team, Auto-updates disabledBeaver Themer: version: 1.4.5.1, author: The Beaver Builder Team, Auto-updates disabledClassy.org: version: 0.1.0, author: Classy, Auto-updates disabledCloudflare: version: 4.11.0, author: Cloudflare, Inc., Auto-updates disabledCode Snippets: version: 3.3.0, author: Code Snippets Pro, Auto-updates disabledDisable Gutenberg: version: 2.9, author: Jeff Starr, Auto-updates disabledEnable Media Replace: version: 4.1.1, author: ShortPixel (latest version: 4.1.2), Auto-updates disabledGDPR Cookie Consent: version: 2.4.0, author: WebToffee, Auto-updates disabledImagify: version: 2.1.1, author: Imagify – Optimize Images & Convert WebP, Auto-updates disabledImport Export WordPress Users and WooCommerce Customers: version: 2.3.9, author: WebToffee, Auto-updates disabledLive Cart by WP Engine: version: 1.0.1, author: WP Engine, Auto-updates disabledMax Mega Menu: version: 3.1.1, author: megamenu.com (latest version: 3.2.1), Auto-updates disabledMax Mega Menu - Pro Addon: version: 2.2.7, author: megamenu.com (latest version: 2.2.8), Auto-updates disabledOrder Export & Order Import for WooCommerce: version: 2.3.3, author: WebToffee, Auto-updates disabledPDF Invoices & Packing Slips for WooCommerce: version: 3.5.2, author: WP Overnight, Auto-updates disabledPowerPack for Beaver Builder: version: 2.30.0, author: IdeaBox Creations, Auto-updates disabledRank Math SEO: version: 1.0.112, author: Rank Math, Auto-updates disabledRank Math SEO PRO: version: 3.0.34, author: Rank Math, Auto-updates disabledRegenerate Thumbnails: version: 3.1.5, author: Alex Mills (Viper007Bond), Auto-updates disabledShareThis Share Buttons: version: 2.1.7, author: ShareThis, Auto-updates disabledShortcoder: version: 6.2, author: Aakash Chakravarthy, Auto-updates disabledSlider Revolution: version: 6.6.12, author: ThemePunch, Auto-updates disabledSticky Menu (or Anything!) on Scroll: version: 2.32, author: WebFactory Ltd, Auto-updates disabledThe Events Calendar: version: 6.0.12, author: The Events Calendar, Auto-updates disabledTranslatePress - Multilingual: version: 2.5.1, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Cristophor Hurduban, Auto-updates disabledTranslatePress - Personal: version: 1.1.7, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Auto-updates disabledUpdraftPlus - Backup/Restore: version: 1.23.3, author: UpdraftPlus.Com, DavidAnderson, Auto-updates disabledWeb Accessibility by accessiBe: version: 1.15, author: accessiBe, Auto-updates disabledWooCommerce: version: 7.6.0, author: Automattic (latest version: 7.6.1), Auto-updates disabledWooCommerce Extended Coupon Features FREE: version: 3.3.3, author: Soft79, Auto-updates disabledWooCommerce PayPal Pro (Classic and PayFlow Editions) Gateway: version: 4.4.12, author: WooCommerce, Auto-updates disabledWooPack for Beaver Builder: version: 1.5.2, author: Team IdeaBox - Beaver Addons, Auto-updates disabledWordPress Importer: version: 0.8, author: wordpressdotorg, Auto-updates disabledWP-FormAssembly: version: 2.0.8, author: FormAssembly / Drew Buschhorn, Auto-updates disabledWP Add Custom CSS: version: 1.1.6, author: Daniele De Santis, Auto-updates disabledWP All Export: version: 1.3.9, author: Soflyy, Auto-updates disabledWP Cloud Plugin Share-one-Drive (OneDrive & SharePoint): version: 2.7.2, author: WP Cloud Plugins, Auto-updates disabledWPCode Lite: version: 2.0.10, author: WPCode, Auto-updates disabledWP 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_Imagickimagick_module_version: 1691imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https://imagemagick.orgimagick_version: 3.7.0file_uploads: File uploads is turned offpost_max_size: 256Mupload_max_filesize: 256Mmax_effective_size: 256 MBmax_file_uploads: 20imagick_limits:imagick::RESOURCETYPE_AREA: 137 MBimagick::RESOURCETYPE_DISK: 1073741824imagick::RESOURCETYPE_FILE: 786432imagick::RESOURCETYPE_MAP: 512 MBimagick::RESOURCETYPE_MEMORY: 256 MBimagick::RESOURCETYPE_THREAD: 1imagick::RESOURCETYPE_TIME: 9.22337203685E+18imagemagick_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, YUVgd_version: 2.3.0gd_formats: GIF, JPEG, PNG, WebP, BMP, XPMghostscript_version: not available
   
       wp-server
   
       server_architecture: Linux 5.15.89+ x86_64httpd_software: nginxphp_version: 8.0.28 64bitphp_sapi: fpm-fcgimax_input_variables: 10000time_limit: 43300memory_limit: 1Gmax_input_time: -1upload_max_filesize: 256Mphp_post_max_size: 256Mcurl_version: 7.81.0 OpenSSL/3.0.2suhosin: falseimagick_availability: truepretty_permalinks: truehtaccess_extra_rules: false
   
       wp-database
   
       extension: mysqliserver_version: 5.7.41-44-logclient_version: mysqlnd 8.0.28max_allowed_packet: 16777216max_connections: 500
   
       wp-constants
   
       WP_HOME: undefinedWP_SITEURL: undefinedWP_CONTENT_DIR: /nas/content/live/aftddev/wp-contentWP_PLUGIN_DIR: /nas/content/live/aftddev/wp-content/pluginsWP_MEMORY_LIMIT: 1GWP_MAX_MEMORY_LIMIT: 512MWP_DEBUG: trueWP_DEBUG_DISPLAY: falseWP_DEBUG_LOG: falseSCRIPT_DEBUG: falseWP_CACHE: trueCONCATENATE_SCRIPTS: undefinedCOMPRESS_SCRIPTS: undefinedCOMPRESS_CSS: undefinedWP_ENVIRONMENT_TYPE: UndefinedDB_CHARSET: utf8DB_COLLATE: undefined
   
       wp-filesystem
   
       wordpress: writablewp-content: writableuploads: writableplugins: writablethemes: writablemu-plugins: writable
       ```
   
 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [3 years ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16722542)
 * Hi [@pwitzleb](https://wordpress.org/support/users/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.
 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [3 years ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16722551)
 * Hi [@argentum](https://wordpress.org/support/users/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.
 *  Thread Starter [pwitzleb](https://wordpress.org/support/users/pwitzleb/)
 * (@pwitzleb)
 * [3 years ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16724040)
 * 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
 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [3 years ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16737589)
 * Hi [@pwitzleb](https://wordpress.org/support/users/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.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Mismapped Data Fields’ is closed to new replies.

 * ![](https://ps.w.org/order-import-export-for-woocommerce/assets/icon-256x256.
   gif?rev=3133964)
 * [Order Export & Order Import for WooCommerce](https://wordpress.org/plugins/order-import-export-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/order-import-export-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/reviews/)

 * 8 replies
 * 3 participants
 * Last reply from: [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/mismapped-data-fields/#post-16737589)
 * Status: resolved