Empty product .CSV export file
-
Hello,
I want to export some products into a .CSV file.
But that file is empty…I go to: Products -> all products -> Export
I want to export All columns
I want to export All products
I want to Export only the category: Test, so I select that one.
I click on: Generate CSV
Open it with Microsoft Excel
And it is empty. All exports I try are 1 kB and empty.The only plugin that is active is: Woocommerce
The active theme is: Twenty Twenty-TwoI went back to WooCommerce Version 4.7.0, but this did not make a diverence.
I do not see any errors in the error logsCan you help me fix this?
-
Hello,
Can you please go to WP Dashboard > products > all products.
Select the category of your preference (let’s say Test), and let me know how many products are visible on your end?
Also, can you open the file using another program, for example, Google Spreadsheets or LibreOffice? The fact is that MS Excel tends to change the file format.
Could you 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”.? That will help us to take a closer look.
Thanks.
There are 3 products in category: Test.
There are 0 products in the .csv file opened in Google Sheets and LibreOffice.### WordPress Environment ### WordPress address (URL): https://www..nl/blogtest Site address (URL): https://www..nl/blogtest WC Version: 6.5.1 REST API Version: ? 6.5.1 WC Blocks Version: ? 7.4.3 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: 6.0 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.4.27 PHP Post Max Size: 2 GB PHP Time Limit: 3600 PHP Max Input Vars: 3000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.3.24-MariaDB-cll-lve Max Upload Size: 64 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.5.1 WC Database Prefix: wp_ Totale database grootte: 803.49MB Database gegevens grootte: 602.13MB Database index grootte: 201.36MB 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: 1.03MB + 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.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: 24.56MB + Index: 20.08MB + 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_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_apmm_custom_theme: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aws_cache: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_aws_index: Data: 9.55MB + Index: 8.03MB + Engine InnoDB wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cd_customizations: Data: 1.52MB + Index: 0.19MB + Engine InnoDB wp_cfs_contacts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cfs_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cfs_forms: Data: 0.30MB + Index: 0.00MB + Engine InnoDB wp_cfs_membership_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cfs_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_cookies: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wp_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_ee_products_sync_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_em_bookings: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_em_events: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wp_em_locations: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_em_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_em_tickets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_em_tickets_bookings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gs_woo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_hidemysiteSecure: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_languages_translations: Data: 0.20MB + Index: 0.13MB + Engine InnoDB wp_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_mo_files_domains: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_strings: Data: 7.52MB + Index: 15.09MB + Engine InnoDB wp_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_string_pages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_icl_string_positions: Data: 2.52MB + Index: 0.44MB + Engine InnoDB wp_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_string_translations: Data: 5.52MB + Index: 4.03MB + Engine InnoDB wp_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_translate: Data: 1.52MB + Index: 0.25MB + Engine InnoDB wp_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_icl_translations: Data: 2.52MB + Index: 7.06MB + Engine InnoDB wp_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_icl_translation_status: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wp_image_hover_ultimate_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_image_hover_ultimate_style: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_itsec_logs: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_litespeed_img_optm: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_maxbuttonsv3: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_maxbuttons_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_maxbuttons_collections_trans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_omega_index_changes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 10.41MB + Index: 1.00MB + Engine InnoDB wp_oxi_div_import: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pay_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pay_option_subs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pay_transactions: Data: 0.23MB + Index: 0.11MB + Engine InnoDB wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_images: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 191.64MB + Index: 83.22MB + Engine InnoDB wp_posts: Data: 94.52MB + Index: 6.83MB + Engine InnoDB wp_pps_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pps_popup: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_pps_popup_show_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_redirection_404: Data: 26.55MB + Index: 10.59MB + Engine InnoDB wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_redirection_logs: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wp_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + 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.00MB + Engine InnoDB wp_revslider_sliders_bkp: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_slides_bkp: Data: 0.52MB + Index: 0.00MB + Engine InnoDB wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_spectrom_sync: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_spectrom_sync_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_spectrom_sync_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.33MB + Index: 0.50MB + Engine InnoDB wp_terms: Data: 0.16MB + Index: 0.16MB + Engine InnoDB wp_term_relationships: Data: 2.52MB + Index: 2.52MB + Engine InnoDB wp_term_taxonomy: Data: 1.52MB + Index: 0.22MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_translations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_translations_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Data: 1.41MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB 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.05MB + 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_attributes_lookup: Data: 11.56MB + Index: 17.09MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 2.52MB + Index: 6.73MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wdp_product_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfconfig: Data: 2.34MB + Index: 0.00MB + Engine InnoDB wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilemods: Data: 13.55MB + Index: 0.00MB + Engine InnoDB wp_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfknownfilelist: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wflogins: Data: 0.48MB + Index: 0.16MB + Engine InnoDB wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfstatus: Data: 0.14MB + Index: 0.11MB + Engine InnoDB wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpml_mails: Data: 147.52MB + Index: 0.00MB + Engine InnoDB wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wtbp_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wapo_addons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wapo_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wapo_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wapo_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wccl_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_yoast_indexable: Data: 14.55MB + Index: 9.61MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 1.52MB + Index: 0.78MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wp_yoast_seo_links: Data: 3.52MB + Index: 3.03MB + Engine InnoDB wp_yoast_seo_meta: Data: 0.25MB + Index: 0.00MB + Engine InnoDB wp_ywcars_messagemeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ywcars_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_categories_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_headers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_products_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_za_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### acf-field: 1 acf-field-group: 1 ae_global_templates: 8 attachment: 5694 awl-labels: 4 br_filters_group: 1 br_minmax_limitation: 1 br_product_filter: 36 custom_css: 4 cwginstocknotifier: 3 edfm_menu: 1 elementor_library: 61 essential_grid: 18 is_search_form: 1 location: 2 mc4wp-form: 2 nav_menu_item: 274 oembed_cache: 235 page: 34 popup: 1 popup_theme: 6 product: 972 product_variation: 13160 product-feed: 1 revision: 1424 shop_order: 2 shop_order_refund: 8 static_block: 8 templatera: 8 testimonial: 3 vc_grid_item: 1 wafs: 1 wc_dynamic_pricing: 1 wc_product_table: 1 wcdp_payment: 54 wcp_ruleset: 8 wcpcsu-custom-post: 2 wcs_ruleset: 17 wp_block: 1 wpcf7_contact_form: 2 wppopups: 1 wpt_product_table: 1 yith-wcbm-badge: 3 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (2) ### WooCommerce: door Automattic – 6.5.1 Wordfence Security: door Wordfence – 7.5.10 ### Inactive Plugins (59) ### 404page - your smart custom 404 error page: door Peter Raschendorfer – 11.3.1 Advanced AJAX Product Filters for WooCommerce: door BeRocket – 1.6.2 Advanced Editor Tools (previously TinyMCE Advanced): door Automattic – 5.6.0 Advanced Woo Labels: door ILLID – 1.44 Advanced Woo Search: door ILLID – 2.54 Auto Image Attributes From Filename With Bulk Updater: door Arun Basil Lal – 3.2 Booster Plus for WooCommerce: door Pluggabl LLC – 5.5.2 Code Snippets: door Code Snippets Pro – 3.1.0 Complianz | GDPR/CCPA Cookie Consent: door Really Simple Plugins – 6.1.6.1 Conditional Payments for WooCommerce: door Lauri Karisola / WP Trio – 2.3.1 Conditional Shipping for WooCommerce: door Lauri Karisola / WP Trio – 2.3.0 Contact Form 7: door Takayuki Miyoshi – 5.5.6.1 Conversios.io - Google Analytics and Google Shopping plugin for WooCommerce: door Tatvic – 4.7.3 Delete Custom Fields: door Sam Margulies – 0.3.1 Edit Custom Fields: door Jay Sitter – 0.1.7 Electro Extensions: door MadrasThemes – 3.2.5 Elementor: door Elementor.com – 3.6.5 Envato Market: door Envato – 2.0.7 Global Shop Discount for WooCommerce: door Algoritmika Ltd – 1.5.0 Google Language Translator: door Translate AI Multilingual Solutions – 6.0.15 GTM4WP: door Thomas Geiger – 1.15.2 Kadence WooCommerce Email Designer: door Kadence WP – 1.5.1 Limit Login Attempts Reloaded: door Limit Login Attempts Reloaded – 2.25.3 Loco Translate: door Tim Whitlock – 2.6.2 Members: door MemberPress – 3.2.1 Min Max Quantity & Step Control for WooCommerce: door CodeAstrology – 2.8 OnSale Page for WooCommerce: door wpgenie – 1.1.0 PAY. Payment Methods for WooCommerce: door PAY. – 3.9.0 Product Feed Manager for WooCommerce: door RexTheme – 7.2.5 Product Feed Manager for WooCommerce PRO: door RexTheme – 6.0.3 Product GTIN (EAN, UPC, ISBN) for WooCommerce: door Emanuela Castorina – 1.1.1 Really Simple SSL: door Really Simple Plugins – 5.3.2 Redirection: door John Godley – 5.2.3 Regenerate Thumbnails: door Alex Mills (Viper007Bond) – 3.1.5 Replace Image: door Aspen Grove Studios – 1.1.7 Smart Manager - WooCommerce Inventory Management, Bulk Edit & more...: door StoreApps – 6.0.0 Smush: door WPMU DEV – 3.9.11 Template Library and Redux Framework: door Extendify – 4.3.14 TP Product Image Flipper for Woocommerce: door TP Plugins – 1.0.7 User Roles and Capabilities: door mahabub – 1.2.6 Variation Swatches for WooCommerce: door Emran Ahmed – 1.1.19 Variation Swatches for WooCommerce - Pro: door Emran Ahmed – 1.1.18 WC Hide Shipping Methods: door Rynaldo Stoltz – 1.5 WooCommerce Advanced Free Shipping: door Jeroen Sormani – 1.1.4 WooCommerce Deposits: door Webtomizer – 4.0.21 WooCommerce Sale Category: door Webikon (Juraj Kiss) – 0.2 Woo Custom Stock Status: door Softound Solutions – 1.3.0 WooMultistore: door Lykke Media AS – 4.6.0 WPC Composite Products for WooCommerce: door WPClever – 5.2.0 WP Mail Logging: door Wysija – 1.10.4 WP Rocket: door WP Media – 3.11.2 WP Rollback: door Impress.org – 1.7.1 WPS Hide Login: door WPServeur NicolasKulka wpformation – 1.9.6 YITH WooCommerce Badge Management: door YITH – 2.5.0 YITH WooCommerce Product Add-ons & Extra Options: door YITH – 2.10.0 YITH WooCommerce Wishlist: door YITH – 3.9.0 Yoast Duplicate Post: door Enrico Battocchi & Team Yoast – 4.4 Yoast SEO: door Team Yoast – 18.9 Yoast Test Helper: door Team Yoast – 1.17 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (1) ### WordPress automation by Installatron: door – ### Settings ### API Enabled: ? Force SSL: – Currency: EUR (€) Currency Position: left Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: composite (composite) creative (creative) external (external) external (external-fr) external (external-de) grouped (grouped) grouped (grouped-de) grouped (grouped-fr) simple (simple) simple (simple-fr) simple (simple-de) variable (variable-de) variable (variable-fr) variable (variable) woosg (woosg) Taxonomies: Product Visibility: creative (creative) exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) fashion (fashion-2) featured (featured) image (image) outofstock (outofstock) photography (photography) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) travel (travel) videos (videos) wordpress (wordpress) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – ### WC Pages ### Winkelbasis: #19 - /shop/ Winkelwagen: #3134 - /winkelwagen/ Afrekenen: #109875 - /betalen/ Mijn account: #3854 - /mijn-account/ Algemene voorwaarden: #2183 - /algemene-voorwaarden/ ### Theme ### Name: Twenty Twenty-Two Version: 1.2 Author URL: https://nl.www.ads-software.com/ Child Theme: ? – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt raden we het gebruik van een sub-thema aan. Zie: Hoe maak je een sub-thema WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Afgerond: 410 Oldest: 2022-04-30 07:56:41 +0200 Newest: 2022-05-30 12:42:31 +0200 In afwachting: 3 Oldest: 2022-05-30 12:43:10 +0200 Newest: 2022-05-30 13:34:12 +0200 Mislukt: 18.439 Oldest: 2020-08-24 09:19:23 +0200 Newest: 2021-08-09 09:25:47 +0200 ### Status report information ### Generated at: 2022-05-30 12:42:41 +02:00
Hi @dwnl
Thanks for sharing the System Status Report.
I am not able to replicate the issue on my test site which is running on a basic setup of the latest versions of WordPress, WooCommerce and the Storefront theme. I tried an export by following the exact steps you mentioned, and did get the desired output for my chosen category.
All exports I try are 1 kB and empty
This is likely due to browser cache. You can read more on this here: https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-csv-export-issue/d0af4ce4-9cd5-401a-957d-0017bc11ca7d
Therefore, we suggest trying on another browser or in incognito mode. You can clear your browser’s cache as explained in this guide:
Do let us know if you need further assistance.
I tried the following browsers:
Opera, firefox, microsoft edge and chrome. All return an empty file.
Clearing the cache does not fix this problem.In the category: TEST, there are 3 products, 2 variable products and 1 simple.
Export returns an empty .csv file.I tried a different category: NIEUW, there are 60 products in there.
Variable, simple etc.
Export returns an empty .csv file.Hi there,
I can see from your system status report that “Wordfence Security” is enabled on the site. It seems like this plugin might be blocking the request to generate the CSV file.
Can you try to disable that plugin as well, and give it another try?
Let me know how it goes!
Best,
Disabling does not fix it
Hello,
I recommend running a conflict test, you can follow these steps below:
- Clear the site cache, https://wordpress.com/support/clear-your-sites-cache/
- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- At this point try again to export a CSV file
If the issue is not present, it was a conflict affecting this behavior, and you can reactivate the theme and plugins gradually one by one (and check again after each reactivation) until you find the cause of the issue, You can find a more detailed explanation on how to do a conflict test here.
Let us know if this worked.
Again…
Clearing the cache is not solving it.
Changing the theme does not solve it.
Disabling all other plugins does not solve it.Hi @dwnl
It is really strange that even after disabling all plugins and switching to a basic theme, the export isn’t still working.
By any chance do you have any custom code active on your site? If so, please disable it and try again.
Let us know if that helped.
Tried that, no effect
Hi @dwnl
Thanks for confirming that.
I see that there is a caching plugin active on your site.
### Dropin Plugins (1) ###
advanced-cache.php: advanced-cache.phpCan you contact your host and have them temporarily disable the plugin above to see if that fixes the issue?
Let us know if that helped.
Thanks
If I rename that advanced-cache.php file it will add a new file with this name.
So this is part of the wordpress itself or Woocommerce. I can not turn it off.Hello,
To confirm, when exporting products, did you only select Test for
Which product category should be exported
and nothing else?Link to image: https://snipboard.io/ZX4GBE.jpg
Correct. But it does not matter which category I put in there. All files are empty
I can not cache purged instead? because it is in WordPress or woocommerce itself. There is no button to purge…
- The topic ‘Empty product .CSV export file’ is closed to new replies.