Export Returns Empty CSV File

I’m this problem, too.

is the problem, where I could see a log ?

What does your server (apache?) error logs show?

Hi @antenanet and @jagallegoowl. I’m able to export my products on my test site by going to Products > Export Products and had no issues:

Could you please confirm how you’re trying to do the export and what version of WooCommerce are you running? Please also share your system report with me. You can find it by going to WooCommerce > Status > Get system report and then click Copy for support to be able to paste it in your reply.

Hello @woocommerceprogrammer and @drwpcom Thanks for your response, I try to export products too but my file is empty, I don’t know why, This is my configuration about my site

Versión de WooCommerce: 4.3.0
Paquete de la REST API de WooCommerce: ?1.0.10
Paquete WooCommerce Blocks: ?2.7.1?
Paquete del programador de acciones: ?3.1.6?
Paquete de WooCommerce Admin: ?1.3.0?
Versión de WordPress: 5.4.2
WordPress multisitio: –
Límite de memoria de WordPress: 768 MB
Modo de depuración de WordPress: –
Cron de WordPress:
Idioma: es_ES
Caché externa de objetos: –
Información del servidor: Apache
Versión de PHP: 7.3.18
PHP post max size: 128 MB
PHP time limit: 120
PHP max input vars: 3000

### WordPress Environment ###

WordPress address (URL): 
Site address (URL): 
WC Version: 4.3.0
REST API Version: ? 1.0.10
WC Blocks Version: ? 2.7.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.3.0
Log Directory Writable: ?
WP Version: 5.4.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: es_ES
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.18
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1g-fips

SUHOSIN Installed: –
MySQL Version: 5.7.25-28-log
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.3.0
WC Database Prefix: qlm_
Tama?o total de la base de datos: 304.26MB
Tama?o de los datos de la base de datos: 279.51MB
Tama?o del índice de la base de datos: 24.75MB
qlm_woocommerce_sessions: Datos: 1.02MB + índice: 0.02MB + Motor InnoDB
qlm_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
qlm_woocommerce_order_items: Datos: 0.09MB + índice: 0.05MB + Motor InnoDB
qlm_woocommerce_order_itemmeta: Datos: 2.52MB + índice: 0.61MB + Motor InnoDB
qlm_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
qlm_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_actionscheduler_actions: Datos: 1.52MB + índice: 0.83MB + Motor InnoDB
qlm_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_actionscheduler_logs: Datos: 0.33MB + índice: 0.23MB + Motor InnoDB
qlm_commentmeta: Datos: 0.11MB + índice: 0.13MB + Motor InnoDB
qlm_comments: Datos: 1.52MB + índice: 0.61MB + Motor InnoDB
qlm_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_options: Datos: 8.06MB + índice: 1.30MB + Motor InnoDB
qlm_postmeta: Datos: 255.39MB + índice: 15.88MB + Motor InnoDB
qlm_posts: Datos: 5.42MB + índice: 2.66MB + Motor InnoDB
qlm_revslider_css: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_css_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_layer_animations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_layer_animations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_navigations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_navigations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_sliders: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_sliders_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_slides: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_static_slides: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_revslider_static_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_sm_sync: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_stock_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_termmeta: Datos: 0.13MB + índice: 0.14MB + Motor InnoDB
qlm_terms: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB
qlm_term_relationships: Datos: 0.44MB + índice: 0.25MB + Motor InnoDB
qlm_term_taxonomy: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB
qlm_usermeta: Datos: 0.25MB + índice: 0.20MB + Motor InnoDB
qlm_users: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
qlm_wc_admin_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_wc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_wc_order_product_lookup: Datos: 0.06MB + índice: 0.06MB + Motor InnoDB
qlm_wc_order_stats: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
qlm_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
qlm_wc_product_meta_lookup: Datos: 1.52MB + índice: 0.92MB + Motor InnoDB
qlm_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
qlm_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
qlm_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB

### Post Type Counts ###

attachment: 10245
customize_changeset: 16
footer: 4
nasa_block: 9
nasa_pin_pb: 12
nav_menu_item: 70
page: 66
portfolio: 11
post: 13
product: 1177
product_variation: 3537
revision: 201
shop_coupon: 3
shop_order: 755
woo_discount: 3
woo_discount_cart: 1
wpcf7_contact_form: 7

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (19) ###

Contact Form 7: por Takayuki Miyoshi – 5.2
Join.chat: por Creame – 4.0.6
Departamentos y Ciudades de Colombia para Woocommerce: por Saul Morales Pacheco – 1.1.27 – Versión instalada no está probada con la versión activa de WooCommerce 4.3.0
Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 3.2.5
Flexible Shipping: por WP Desk – 3.9.21
Join.chat +: por Creame – 1.1.0
WPBakery Page Builder: por Michael M - WPBakery.com – 6.2.0
Loco Translate: por Tim Whitlock – 2.4.0
Nasa Core: por NasaTheme – 3.5.1
Slider Revolution: por ThemePunch – 6.2.12
SG Optimizer: por SiteGround – 5.5.8
WooCommerce Dynamic Pricing & Discounts: por RightPress – 2.3.9
Checkout Field Editor for WooCommerce: por ThemeHigh – 1.4.3
Mercado Pago payments for WooCommerce: por Mercado Pago – 4.2.1 – Versión instalada no está probada con la versión activa de WooCommerce 4.3.0
WooCommerce: por Automattic – 4.3.0
SEOPress PRO: por SEOPress – 3.8.8
SEOPress: por SEOPress – 3.8.8
WP-Stateless: por Usability Dynamics
Inc. – 2.3.2

YITH WooCommerce Compare: por YITH – 2.3.22 – Versión instalada no está probada con la versión activa de WooCommerce 4.3.0

### Inactive Plugins (0) ###

### Settings ###

API Enabled: ?
Force SSL: –
Currency: COP ($)
Currency Position: left
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 0
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
yith_bundle (yith_bundle)

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 ###

Base de la tienda: #292 - /shop-ajax/
Carrito: ? La página no contiene el shortcode.
Finalizar compra: ? La página no contiene el shortcode.
Mi cuenta: ? La página no contiene el shortcode.
Términos y condiciones: ? Página sin definir

### Theme ###

Name: Elessi Child Theme
Version: 1.0
Author URL: https://www.nasatheme.com
Child Theme: ?
Parent Theme Name: Elessi Theme
Parent Theme Version: 3.5.1
Parent Theme Author URL: https://nasatheme.com
WooCommerce Support: ?

### Templates ###

Overrides: elessi-theme/woocommerce/archive-product.php
elessi-theme/woocommerce/cart/cart-item-data.php
elessi-theme/woocommerce/cart/cart-totals.php
elessi-theme/woocommerce/cart/cart.php
elessi-theme/woocommerce/cart/cross-sells.php
elessi-theme/woocommerce/cart/mini-cart.php
elessi-theme/woocommerce/checkout/form-checkout.php
elessi-theme/woocommerce/checkout/form-coupon.php
elessi-theme/woocommerce/checkout/thankyou.php
elessi-theme/woocommerce/content-product.php
elessi-theme/woocommerce/content-single-product.php
elessi-theme/woocommerce/content-widget-product.php
elessi-theme/woocommerce/global/breadcrumb.php
elessi-theme/woocommerce/global/form-login.php
elessi-theme/woocommerce/global/quantity-input.php
elessi-theme/woocommerce/loop/loop-end.php
elessi-theme/woocommerce/loop/loop-start.php
elessi-theme/woocommerce/loop/orderby.php
elessi-theme/woocommerce/loop/pagination.php
elessi-theme/woocommerce/myaccount/form-login.php
elessi-theme/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
elessi-theme/woocommerce/single-product/product-image.php
elessi-theme/woocommerce/single-product/product-thumbnails.php
elessi-theme/woocommerce/single-product/related.php
elessi-theme/woocommerce/single-product/review.php
elessi-theme/woocommerce/single-product/tabs/additional-information.php
elessi-theme/woocommerce/single-product/tabs/description.php
elessi-theme/woocommerce/single-product/tabs/tabs.php
elessi-theme/woocommerce/single-product/up-sells.php
La  version 3.6.0 de elessi-theme/woocommerce/single-product-reviews.php está obsoleta. La versión del núcleo es la 4.3.0
elessi-theme/woocommerce/single-product.php

Outdated Templates: ?
					
					
						Aprende cómo actualizar

### Action Scheduler ###

Completo: 4.201
Oldest: 2020-06-15 13:28:05 +0000
Newest: 2020-07-10 12:49:10 +0000

Pendiente: 1
Oldest: 2020-07-10 23:08:10 +0000
Newest: 2020-07-10 23:08:10 +0000

Hi @jagallegoowl @antenanet, are you trying to export all products or just some categories? Could you please share a copy of the file with me? You could upload the file to your media library and share the link with me or use a cloud saving option of your choice. Also, I suggest trying conflict testing and see if the export works with only WooCommerce active and using a default theme?

Hi @drwpcom thanks so much for your response, I trying to export all products and my file is empty, this is the link to my file here and I trying to do too the conflict testing and I will tell you. regards.

• This reply was modified 4 years, 8 months ago by jagallegoowl.

Hi @drwpcom tks for your help, We had a conflict with wp-stateless plugin, so I was investigate what was the problem and I found that one variable (WP_STATELESS_MEDIA_CACHE_BUSTING) was causing this error. Best Regards and Tks.

That’s ok, is fine.
The problem now:problem with primary key value, which is ignored on import
I need the primary key of the products to be identical to that of my physical store.
I deleted all records from the wp_posts table, when running the woocommerce importer a sequential value is generated, ignoring the id provided in the csv spreadsheet. I used Google spreadsheet to generate the csv.
I have 4501 items.