Title: Cannot Export Products Last modified: December 31, 2020 --- # Cannot Export Products * Resolved [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/) * I set up a new woocomerce product site. I added just 3 products. However, I cannot EXPORT to CSV. * The top rows are ID TYPE, SKU, etc. * But row 1 under ID shows a number. Row 2-5 show a bunch of text preceeded by “\ n” (should be in description field for the first record. Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13854620) * Hi there! 👋 * Without more information, we can’t offer much advice. To help us troubleshoot this issue, please provide us the following: - Send us a screenshot of the generated .CSV file - Please share a copy of your site’s System Status. You can find it via _WooCommerce > Status_. Select “Get system report” and then **“Copy for support”**.  Once you’ve done that, paste it here in your response. * Thanks in advance! 🙂 * Thread Starter [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13854688) * Thank you for the response. * [https://www.cybermidi.com/2021-01-01.png](https://www.cybermidi.com/2021-01-01.png) * (the line starting with \n should be the description) * ``` ### WordPress Environment ### WordPress address (URL): https://www.cybermidi.com/community Site address (URL): https://www.cybermidi.com/community WC Version: 4.8.0 REST API Version: ✔ 4.8.0 WC Blocks Version: ✔ 3.8.1 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.7.3 Log Directory Writable: ✔ WP Version: 5.6 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2 PHP Version: 7.4.10 PHP Post Max Size: 20 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.47.0 OpenSSL/1.0.2g SUHOSIN Installed: – MySQL Version: 5.6.47-87.0-log Max Upload Size: 20 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.5.0 WC Database Prefix: wp_ Total Database Size: 6.98MB Database Data Size: 4.77MB Database Index Size: 2.21MB wp_woocommerce_sessions: Data: 0.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + 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 ahm_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 0.08MB + Index: 0.11MB + 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.06MB + Index: 0.03MB + Engine InnoDB wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_edd_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_edd_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_coupon_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_followup_customer_carts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customer_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_followup_email_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_email_orders: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wp_followup_email_order_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_followup_order_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 1.06MB + Index: 0.06MB + Engine MyISAM wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 0.31MB + Index: 0.11MB + Engine MyISAM wp_posts: Data: 1.91MB + Index: 0.11MB + Engine MyISAM wp_psk_s2msfb_downloads: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_psk_s2msfb_files: Data: 0.10MB + Index: 0.06MB + Engine MyISAM wp_symposium_audit: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_symposium_chat2_typing: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_taxonomymeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_usermeta: Data: 0.09MB + Index: 0.07MB + Engine MyISAM wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + 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.02MB + Index: 0.06MB + 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.02MB + Index: 0.09MB + 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 ### Post Type Counts ### attachment: 59 boxes: 3 catablog-items: 484 custom_css: 3 customize_changeset: 17 dlm_download_version: 1 download: 13 edd_log: 15 edd_payment: 8 et_pb_layout: 2 et_pb_layout_stashed: 9 follow_up_email: 1 grid_products: 1 layout: 2 ms_song: 2 nav_menu_item: 22 options: 1 page: 48 post: 6 product: 8 project: 2 revision: 264 shop_coupon: 1 shop_order: 5 wps_activity: 3 wps_alerts: 3 wps_extension: 3 wps_forum_extension: 1 wps_friendship: 36 wps_gallery: 1 wps_group: 2 wps_group_members: 2 wps_rewards: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (9) ### Elegant Themes Updater: by Elegant Themes – 1.2 Social Login: by OneAll Social Login – 5.7 s2Member Pro: by WP Sharks – 201225 s2Member Framework: by WP Sharks – 201225 Tabbed Sidebar Widgets: by Nevma – 1.1.2 Stripe For WooCommerce: by Payment Plugins support@paymentplugins.com – 3.2.9 WooCommerce: by Automattic – 4.8.0 WP Symposium Pro (Extensions): by Robert Dempsey – 2020.11 WP Symposium Pro Core: by – 2020.11 ### Inactive Plugins (7) ### Akismet Anti-Spam: by Automattic – 4.1.7 ezPHP: by WebSharks Inc. (Jason Caldwell) – 160128 Follow-Up Emails: by 75nineteen Media LLC – 4.4.10 – Installed version not tested with active version of WooCommerce 4.0 Options Optimizer: by Keith P. Graham – 1.0 s2member Secure File Browser: by Potsky – 0.4.19 WP All Import: by Soflyy – 3.5.6 Yoast SEO: by Team Yoast – 15.5 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ✔ Force SSL: – Currency: USD ($) 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 ### Shop base: #1551 - /catalog/ Cart: #928 - /cart/ Checkout: #1198 - /checkout/ My account: #930 - /my-cybermidi/ Terms and conditions: #253 - /privacy-policy/ ### Theme ### Name: Divi Version: 3.24 Author URL: http://www.elegantthemes.com Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: – ### Action Scheduler ### Complete: 184 Oldest: 2020-12-26 17:09:04 +0000 Newest: 2021-01-01 20:20:53 +0000 Pending: 2 Oldest: 2021-01-01 23:32:44 +0000 Newest: 2021-01-02 20:20:53 +0000 ``` - This reply was modified 5 years, 5 months ago by [pwizard](https://wordpress.org/support/users/pwizard/). * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13861780) * Thank you for sharing the report and the screenshot with us 🙂 * This kind of problem is usually caused by either a conflict with your theme or with another plugin.   The best way to determine this is to: - Temporarily switch your theme to [Storefront](https://www.woocommerce.com/storefront/) - Disable all plugins except for WooCommerce - Repeat the action that is causing the problem * If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. [You can find a more detailed explanation on how to do a conflict test here.](https://docs.woocommerce.com/document/how-to-test-for-conflicts/) * **Before you start** 1. First, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site. 2. Second, I would suggest installing a plugin called Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it allows you to disable plugins without affecting your current site visitors. * Thread Starter [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13863510) * Hi. I am not concerned about visitors yet as it is not live (until I can upload 2000 products). That is why it is crucial to get the export/import working. * I dont have “storefront) but I switched to basic wordpress themes (tried a bunch, 2011, 2019, 2020, etc. I disabled all plugins except woocomerce. Same thing happens. * It’s the SHORT DESCRIPTION field. whenever it is filled, the issue occurs. * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13864446) * Upon checking the _System status_ that you shared with us, I can see that your WooCommerce database is not updated to the latest version (4.8.0). It is currently at version 4.5.0. * This seems to be what is causing the issue. To update it to the latest version please go to **Dashboard > Status > Tools > Update Database**, and update it from there. * Afterward, clear the cache and export the products one more time to see if the issue got solved. 🙂 * Before doing that, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site. * Thread Starter [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13869214) * I updated the db. Sorry, no luck, same issue. * Here is the actual CSV. Maybe this can give you a clue into what it happening. * [https://www.cybermidi.com/wc-product-export-5-1-2021-1609882044127.csv](https://www.cybermidi.com/wc-product-export-5-1-2021-1609882044127.csv) * I get a feeling this is pipe related. In my spreadsheet, I can see a pipe | in the top line (like an address bar) but it is invisible in the spreadsheet, and causing breaking, moving it to the next line. * But using the pipe character in the spreadsheet doesn’t help. * Thanks again. - This reply was modified 5 years, 5 months ago by [pwizard](https://wordpress.org/support/users/pwizard/). * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13869699) * Thank you for providing the .CSV file. Let’s get started. 👍 * I would like to let you know that the “/n” is an escape sequence which, creates a new line for the forthcoming text. This will be added every time you add a new line (by pressing the keystroke enter of your keyboard) inside the short or long description in a WooCommerce Product. * I’ve downloaded and checked the .CSV, and I can tell that your exporting functionality is working okay. * Upon checking your first screenshot, I can see that for some reason, the software you are using to opening the .CSV file isn’t rendering correctly. Could you please open it with another software like Google Docs Spreadsheet, Microsoft Excel, or another one to see if it loads okay? * However, I want to mention that if you are planning to import that generated export file, it will give you an error because you are adding HTML code into the short description field of your products. * For security reasons, it is not allowed on the WooCommerce exporting functionality to import some HTML tags. But, a workaround for this in order to allow the majority of the HTML tags is to add the following line to your _wp-config.php_ file: ` define( 'ALLOW_UNFILTERED_UPLOADS', true )`; * If you would like to learn more about this, please feel free to visit the following link: * [https://docs.woocommerce.com/document/product-csv-importer-exporter/](https://docs.woocommerce.com/document/product-csv-importer-exporter/) * I hope this helps 🙂 * Thread Starter [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13873902) * Gabriel * Thank you again. Yes, it opened in Google Sheets fine. I had tried TWO csv programs, both had the same errors. Strange. * So two more questions. * 1. Would it be ok to add that line to the config JUST for uploading a csv, and then it would no longer be needed so I can remove it? * 2. Since it doesn’t like html code in the short description, would putting it in the LONG description be ok? * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13879877) * Hi [@pwizard](https://wordpress.org/support/users/pwizard/) 👋 * > 1. Would it be ok to add that line to the config JUST for uploading a csv, > and then it would no longer be needed so I can remove it? * Yep, you should be able to do that. 🙂 * > 2. Since it doesn’t like html code in the short description, would putting > it in the LONG description be ok? * Unfortunately, it isn’t allowed for long descriptions either * Cheers! * Thread Starter [pwizard](https://wordpress.org/support/users/pwizard/) * (@pwizard) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13886801) * Works perfect. Thanks for all your help! * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13891625) * We are happy to help 😃 * Great! If you have any further questions, you can start a new thread. * Cheers! Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Cannot Export Products’ 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/) * 11 replies * 2 participants * Last reply from: [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/cannot-export-products/#post-13891625) * Status: resolved