Support » Plugin: WooCommerce » Export Returns Empty CSV File

  • Resolved jagallegoowl

    (@jagallegoowl)


    Hi Everybody

    I hope that everything it’s ok, Could You help me, I’m trying to create an export CSV file using the WooCommerce native importer/exporter, but the file is empty, I don’t know what is the problem, where I could see a log ? or what I need to do to solve that.

    Regards.

    Tks so much

Viewing 9 replies - 1 through 9 (of 9 total)
  • I’m this problem, too.

    Woocommerce Programmer

    (@woocommerceprogrammer)

    is the problem, where I could see a log ?

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

    Plugin Support Ena P (a11n)

    (@drwpcom)

    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.

    Thread Starter jagallegoowl

    (@jagallegoowl)

    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

    Thread Starter jagallegoowl

    (@jagallegoowl)

    
    ### 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: http://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
    
    
    Plugin Support Ena P (a11n)

    (@drwpcom)

    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?

    Thread Starter jagallegoowl

    (@jagallegoowl)

    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 1 year, 6 months ago by jagallegoowl.
    Thread Starter jagallegoowl

    (@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.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Export Returns Empty CSV File’ is closed to new replies.