Title: Product CSV export contain errors Last modified: July 17, 2022 --- # Product CSV export contain errors * Resolved [elaxxl](https://wordpress.org/support/users/elaxxl/) * (@elaxxl) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/) * Hi there, * For some reason when we make an export (CSV) of all products, some lines are filled with meta or description or things that dont belong to the product, because this happens we can not import the fil again since none of the columns know where they belong. * This happens on both sites: [https://cafetariaderooy.nl/bestellen/](https://cafetariaderooy.nl/bestellen/), [https://spuitbuswinkel.nl/](https://spuitbuswinkel.nl/) we have checked so far. * We can add the CSV exports somewhere if you want, so you can see what happens. * To be more clear: this has never happened before, we have made no changes to our Excel or Office package and have been using Woocommerce for over 7 years without this (or similair) issue. * Thank you in advance. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fproduct-csv-export-contain-errors%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 7 replies - 1 through 7 (of 7 total) * [Juan G. (woo-hc)](https://wordpress.org/support/users/judagutor/) * (@judagutor) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15832382) * Hi [@elaxxl](https://wordpress.org/support/users/elaxxl/)! * Thank you for reaching out. * > For some reason when we make an export (CSV) of all products, some lines are > filled with meta or description or things that dont belong to the product, * How are you exporting the CSV file? Are you using the WooCommerce core **Product CSV Importer and Exporter** functionality found under `Products → All products`? * > We can add the CSV exports somewhere if you want, so you can see what happens. * Yes, please. We want to take a closer look at the CSV file to understand the issue better. * Kindly share the file with us: you can use Google Drive, Dropbox, [https://www.file.io/](https://www.file.io/), or [https://ufile.io/](https://ufile.io/) services. * > To be more clear: this has never happened before, we have made no changes to > our Excel or Office package * If possible, we recommend avoiding using Microsoft Excel due to formatting and character encoding issues. * Check more about this here: [https://woocommerce.com/document/product-csv-importer-exporter/#create-your-csv](https://woocommerce.com/document/product-csv-importer-exporter/#create-your-csv) * We will be awaiting your response. * Thread Starter [elaxxl](https://wordpress.org/support/users/elaxxl/) * (@elaxxl) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15832523) * Hi there, * yes we use the mentioned standard prodcedure in Woocommerce > products > all products > export. * See: [https://file.io/Vd0QJIHXZtdm](https://file.io/Vd0QJIHXZtdm) for the files. * Sadly its not possible to avoid excel/Office nor did we had this issue ever in the past 7 years and we always use Excel. * Thank you. * [Juan G. (woo-hc)](https://wordpress.org/support/users/judagutor/) * (@judagutor) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15832797) * Thank you for sending the CSV files. * One of the files has the usual columns the CSV file should have; however, the other has various columns that seem to relate to meta information. * ![](//i.ibb.co/2F5Nnsq/nafjnafd.png)”) * Kindly notice that some plugins on your site could be creating these columns. * To take a further look into your site setup, kindly share with us your **System Status**; you can find it via `WooCommerce > Status`. Select ‘Get system report’ and then ‘Copy for support’. Once you do this, you can paste your response here. * Thanks! * Thread Starter [elaxxl](https://wordpress.org/support/users/elaxxl/) * (@elaxxl) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15834426) * hi there, * thank you for mentioning that but as far as we can see that is not the issue, to clarify the other CSV (from [https://spuitbuswinkel.nl/](https://spuitbuswinkel.nl/)) also has the “issue” we think is causing the import error, because when we export it it also includes text on lines/columns it should not it seems (see file at: [https://file.io/yJAjHT314UBp](https://file.io/yJAjHT314UBp) ). * Normally no matter what description, short description, meta, etc. you include each product and/or variation stays on 1 row/line.. in both these cases there is information about the product or something on some rows instead of within the row belonging to the product itself. * Nevertheless also added the system status: * ``` ### WordPress Environment ### WordPress address (URL): https://cafetariaderooy.nl Site address (URL): https://cafetariaderooy.nl WC Version: 5.6.2 REST API Version: ✔ 5.6.2 WC Blocks Version: ✔ 5.5.1 Action Scheduler Version: ✔ 3.2.1 WC Admin Version: ✔ 2.5.2 Log Directory Writable: ✔ WP Version: ❌ 5.7.6 - Er is een nieuwere versie van WordPress beschikbaar (6.0.1) WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ✔ Language: nl_NL External object cache: – ### Server Environment ### Server Info: Apache/2 PHP Version: 7.3.33 PHP Post Max Size: 2 GB PHP Time Limit: 120 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.27-MariaDB-cll-lve Max Upload Size: 2 GB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.6.1 WC Database Prefix: wp_ Totale databasegrootte: 26.47MB Database datagrootte: 18.93MB Database index grootte: 7.54MB wp_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.52MB + Index: 0.48MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 1.02MB + Index: 0.61MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_asre_sales_report: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.45MB + Index: 0.45MB + Engine InnoDB wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB wp_gla_merchant_issues: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_masterslider_options: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_masterslider_sliders: Data: 0.11MB + Index: 0.03MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 4.30MB + Index: 0.11MB + Engine InnoDB wp_postmeta: Data: 3.42MB + Index: 2.66MB + Engine InnoDB wp_posts: Data: 2.38MB + Index: 0.23MB + Engine InnoDB wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.17MB + Index: 0.22MB + Engine InnoDB wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpgmza: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpgmza_circles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpgmza_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpgmza_rectangles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 1.38MB + Index: 0.28MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### attachment: 323 mailpoet_page: 1 menu: 41 nav_menu_item: 9 page: 15 post: 1 product: 87 product_variation: 497 revision: 80 shop_order: 479 tribe_events: 4 tribe_venue: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (14) ### Adminimize: door Frank Bültge – 1.11.7 Decorator - WooCommerce E-mail Aanpasser: door WebToffee – 1.2.0 FoodBook: door ThemeLooks – 4.0.1 WPBakery Page Builder: door Michael M - WPBakery.com – 6.7.0 Mollie-betalingen voor WooCommerce: door Mollie – 7.0.4 Real-Time Find and Replace Pro: door Marios Alexandrou – 4.0.3 Really Simple SSL: door Really Simple Plugins – 5.3.1 Slider Revolution: door ThemePunch – 6.5.5 Ronneby Theme Core: door DFD – 1.3.5 Onder constructie: door WebFactory Ltd – 3.92 Sales Report Email for WooCommerce: door zorem – 2.7.5 Woo Instant Notifications: door Irdroid – 1.4 WooCommerce: door Automattic – 5.6.2 Yoast SEO: door Team Yoast – 18.4.1 ### Inactive Plugins (0) ### ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – ### WC Pages ### Winkelbasis: #6091 - /foodbook/ Winkelmand: #5001 - /winkelwagen/ Afrekenen: #5002 - /afrekenen/ Mijn account: #5003 - /mijn-account/ Algemene voorwaarden: ❌ Pagina niet ingesteld ### Theme ### Name: DFD Ronneby Version: 3.3.5 Author URL: http://dfd.name/ Child Theme: ❌ – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt raden we het gebruik van een child thema aan. Zie: Hoe maak je een child thema WooCommerce Support: ✔ ### Templates ### Overrides: dfd-ronneby/woocommerce/archive-product.php dfd-ronneby/woocommerce/cart/cart-empty.php dfd-ronneby/woocommerce/cart/cart.php dfd-ronneby/woocommerce/cart/mini-cart.php dfd-ronneby/woocommerce/content-product.php dfd-ronneby/woocommerce/content-widget-product.php dfd-ronneby/woocommerce/loop/add-to-cart.php dfd-ronneby/woocommerce/loop/loop-end.php dfd-ronneby/woocommerce/loop/loop-start.php dfd-ronneby/woocommerce/loop/pagination.php dfd-ronneby/woocommerce/order/order-details.php dfd-ronneby/woocommerce/single-product/rating.php dfd-ronneby/woocommerce/single-product/related.php dfd-ronneby/woocommerce/single-product/review.php dfd-ronneby/woocommerce/single-product.php dfd-ronneby/woocommerce/content-product_cat.php ### Action Scheduler ### Afgerond: 141 Oldest: 2022-06-17 14:18:22 +0000 Newest: 2022-07-17 17:43:47 +0000 In afwachting: 1 Oldest: 2022-07-18 10:47:01 +0000 Newest: 2022-07-18 10:47:01 +0000 ### Status report information ### Generated at: 2022-07-18 11:47:05 +01:00 ``` * Thanx again! * [Igor H](https://wordpress.org/support/users/ihereira/) * (@ihereira) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15834679) * Hello, * I was checking all your responses, I tried to check the files but they were deleted 🙁 * I was checking the system status report, it appears the site is not using the latest versions of WordPress, and WooCommerce, we recommend to update them first: * — [https://woocommerce.com/document/how-to-update-woocommerce/](https://woocommerce.com/document/how-to-update-woocommerce/) — [How to Safely Update WordPress](https://www.wpbeginner.com/beginners-guide/ultimate-guide-to-upgrade-wordpress-for-beginners-infograph/)— Update your database under **WooCommerce > status > tools > update database**. * These actions will ensure you will work with the latest versions. * Before making any change be sure to [back up your site](https://wordpress.com/support/restore/). * If that does not help, please provide us with the CSV file (you can allow them a timeframe of 7 days to be deleted) so that we can check again. * Thank you! * Thread Starter [elaxxl](https://wordpress.org/support/users/elaxxl/) * (@elaxxl) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15851854) * Thank you, but we have solved it ourselves. * [Margaret S. woo-hc](https://wordpress.org/support/users/margaretwporg/) * (@margaretwporg) * [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15851930) * Hi [@elaxxl](https://wordpress.org/support/users/elaxxl/) * > we have solved it ourselves * Glad to hear that! 🙂 * It would be great if you could share the solution here so other users having the same problem may be able to fix it by reading this post. * Thanks Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Product CSV export contain errors’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) ## Tags * [csv](https://wordpress.org/support/topic-tag/csv/) * [Excel](https://wordpress.org/support/topic-tag/excel/) * [export](https://wordpress.org/support/topic-tag/export/) * [files](https://wordpress.org/support/topic-tag/files/) * [Import](https://wordpress.org/support/topic-tag/import/) * [products](https://wordpress.org/support/topic-tag/products/) * 7 replies * 4 participants * Last reply from: [Margaret S. woo-hc](https://wordpress.org/support/users/margaretwporg/) * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/product-csv-export-contain-errors/#post-15851930) * Status: resolved