Export product

Hi @ralak

Thanks for reaching out!

This is quite strange that exporting products to CSV, there are no data displayed in it. On my personal site, this is what I’m seeing on my end when I exported products to CSV:

Just to confirm that you are using the built-in Product CSV Importer and Exporter when exporting products?

If so, I’d like to understand your site properly, please share your System Status Report that you can find via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

Otherwise, if this was added thru a third-party plugin or a custom code, it would be best to reach out to the developers for further assistance here.

Thanks!

Hi, I try to paste the status here but not except the text

and there is no error log

### WordPress Environment ###

WordPress address (URL): https://darren.lilacdev.com
Site address (URL): https://darren.lilacdev.com
WC Version: 7.1.1
REST API Version: ?</img> 7.1.1
WC Blocks Version: ?</img> 8.7.6
Action Scheduler Version: ?</img> 3.4.0
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 1 GB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 8.0.31
Max Upload Size: 1 GB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img> Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

### Database ###

WC Database Version: 7.2.2
WC Database Prefix: 3jKxnxpay_
Total Database Size: 58.98MB
Database Data Size: 56.59MB
Database Index Size: 2.39MB
3jKxnxpay_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3jKxnxpay_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3jKxnxpay_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_actionscheduler_actions: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
3jKxnxpay_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_actionscheduler_logs: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
3jKxnxpay_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
3jKxnxpay_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_options: Data: 3.34MB + Index: 0.08MB + Engine InnoDB
3jKxnxpay_postmeta: Data: 1.52MB + Index: 0.41MB + Engine InnoDB
3jKxnxpay_posts: Data: 50.45MB + Index: 0.47MB + Engine InnoDB
3jKxnxpay_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
3jKxnxpay_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3jKxnxpay_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
3jKxnxpay_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
3jKxnxpay_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3jKxnxpay_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3jKxnxpay_zoo_cw_global_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3jKxnxpay_zoo_cw_product_attribute_swatch_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 138
custom_css: 2
customize_changeset: 86
et_body_layout: 3
et_footer_layout: 2
et_header_layout: 6
et_pb_layout: 6
et_template: 24
et_theme_builder: 4
nav_menu_item: 43
page: 29
polylang_mo: 2
post: 4
product: 18
product_variation: 63
pt_view: 1
revision: 1830
shop_order: 3
sp_wcslider: 3
spt_shortcodes: 3
spt_testimonial: 5
wcpcsu-custom-post: 4
wp_global_styles: 1
wpcf7_contact_form: 2

### Security ###

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

### Active Plugins (22) ###

Polylang: by WP SYNTEX – 3.3
Carousel Upsells and Related Product for Woocommerce: by Dan Zakirov – 0.4.6
Divi Contact Form 7: by DiviPeople – 1.3.2
Classic Widgets: by WordPress Contributors – 0.3
Contact Form 7: by Takayuki Miyoshi – 5.7.1
Clever WooCommerce Ajax Product Filters: by David – 1.0.0
Duplicate Page: by mndpsingh287 – 4.5
Login/Signup Popup: by XootiX – 2.3
Divi Lightbox for Images: by Fernando Tellado – 1.0.3
Loco Translate: by Tim Whitlock – 2.6.3
Max Mega Menu: by megamenu.com – 3.0
Menu Image: by Freshlight Lab – 3.0.8
WS - WooCommerce Swatches Pro Plugin: by AA-Team – 1.0
Product Import Export for WooCommerce: by WebToffee – 2.2.6
Side Cart WooCommerce: by XootiX – 2.1
SVG Support: by Benbodhi – 2.5.5
Real Testimonials: by ShapedPlugin – 2.6.0
Category Slider for WooCommerce: by ShapedPlugin – 1.4.12
Hyyan WooCommerce Polylang Integration: by Hyyan Abo Fakher – 1.5.0
Product Carousel Slider & Grid Ultimate for WooCommerce: by wpWax – 1.9.0
WooCommerce: by Automattic – 7.1.1 (update to version 7.2.2 is available)
YITH WooCommerce Wishlist: by YITH – 3.16.0

### Inactive Plugins (7) ###

Akismet Anti-Spam: by Automattic – 5.0.1
Category Thumbnail List: by Jonk @ Follow me Darling – 2.03
Clever Swatches: by cleversoft.co – 2.2.3
Content Views: by Content Views – 2.5.0.1
Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.16
WooCommerce Auto Category Thumbnails: by Shellbot – 1.2.1
WP Category Thumbnail: by NetTantra – 1.0.7

### Dropin Plugins (1) ###

maintenance.php: maintenance.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: –
Enforce Approved Product Download Directories: ?</img>

### WC Pages ###

Shop base: #7 - /shop/
Cart: ?</img> Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: ?</img> Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #10 - /my-account/
Terms and conditions: #3 - /privacy-policy/

### Theme ###

Name: Darren Theme
Version: 1.0.0
Author URL: https://example.com
Child Theme: ?</img>
Parent Theme Name: Divi
Parent Theme Version: 4.19.3
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?</img>

### Templates ###

Overrides: /home/lilacdev/public_html/darren.lilacdev.com/wp-content/plugins/easy-login-woocommerce//templates//xoo-el-wc-form-login.php version 4.1.0 is out of date. The core version is 7.1.0
/home/lilacdev/public_html/darren.lilacdev.com/wp-content/plugins/easy-login-woocommerce//templates//xoo-el-wc-form-login.php version 4.1.0 is out of date. The core version is 7.0.1

Outdated Templates: ?</img>
					
					
						Learn how to update

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ?</img> Next scheduled: 2022-12-24 11:45:33 +00:00
Options: ?</img>
Notes: 56
Onboarding: skipped

### Action Scheduler ###

Complete: 276
Oldest: 2022-11-23 13:36:27 +0000
Newest: 2022-12-24 06:30:27 +0000

Pending: 1
Oldest: 2022-12-25 03:05:57 +0000
Newest: 2022-12-25 03:05:57 +0000


### WooCommerce Polylang Integration ###

Language Locale: en_US
Polylang Language Locale: en_GB
Polylang Available Languages: en_GB (WooCommerce translation file found OK at /home/lilacdev/public_html/darren.lilacdev.com/wp-content/languages/plugins/woocommerce-en_GB.mo) ar (WooCommerce translation file found OK at /home/lilacdev/public_html/darren.lilacdev.com/wp-content/languages/plugins/woocommerce-ar.mo)

### Status report information ###

Generated at: 2022-12-24 06:33:00 +00:00

Hello @ralak,

Thank you for sharing the report!

First, please update WooComemrce to the latest version.

Also, are you using the plugin below to export products?

Product Import Export for WooCommerce: by WebToffee – 2.2.6

If so, please disable it and rely on the native WooCommere export function.

Let us know how it goes!

Hi, I used another plugin for export when the default woocomerce functionality is not working.

I deactivate the plugin and update woocomerce but got the same result empty CSV file with column names only

Hi @ralak

I understand that when using the built-in Product CSV Importer and Exporter, you are receiving a blank CSV when exporting products, is that correct?

Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

If this did not resolve the issue, please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

Let us know how it goes!

Hi, I install the latest version of WordPress with WooCommerce on my local machine and try to export the products and have the same result empty CSV file with column names only

Hello @ralak,

Hi, I install the latest version of WordPress with WooCommerce on my local machine and try to export the products and have the same result empty CSV file with column names only

May I ask what settings are you selecting when exporting?

It should look like this:

Link to image: https://d.pr/i/R21Jj5

Also, have you tried another CSV reader like Google Sheets or something else?

Look forward to hearing back from you.

The same result empty CSV with columns name only

Hi @ralak

Thanks for your confirmation that the issue still exists even after trying Saif’s suggestions above.

Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

Let us know how it goes!

Hi, I only used the WooCommerce Storefront theme and not install any plugin except WooCommerce and always got CSV file with 544 byte has only columns name

Hi @ralak

I understand that you are still receiving a blank CSV file when running on the default Storefront theme and only WooCommerce plugin is enabled.

Can you please try to update WooCommerce to the latest version, try again to export the products, and see if this works?

Let us know how it goes!