CSV export missing meta fields
-
Hi! I noticed that using the latest updates I can no longer export meta fields using product export. I was wondering what could be an issue? Does that only happen for me and could related to my website? I appreciate your help
-
Hi @burgerino ,
Thanks for reaching out!
I understand that meta fields are missing when exporting products.
Does that only happen for me and could related to my website?
I was not able to replicate your issue as my test site, which uses the default Storefront theme, exports the meta fields. Please could you clarify if you are using the default CSV export or if you are using a plugin?
Additionally, the meta fields should be included in the product export if this has been selected. Please confirm that you are selecting the “Export custom meta” checkbox before generating the CSV, as seen in the screenshot below?
https://snipboard.io/gdCn1D.jpg
Should you be using the default WooCommerce export tool, and the checkbox has been selected, this issue could be caused by a theme or plugin conflict however, before moving to this step, please could you share a copy of your sites System Status, which you can find via?WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’.
Once you do this, you can paste your response here.
Thanks!
Roxanne, thank you for the prompt response.
For the export, I am using default CSV export (Products>Export). I have some plugins installed for filtering products but I am not using it to export.
I did select the checkbox but the issue persists.
Please find the report below.
Thanks### WordPress Environment ### WordPress address (URL): https://pcgigant.lt Site address (URL): https://pcgigant.lt WC Version: 6.6.1 REST API Version: ? 6.6.1 WC Blocks Version: ? 7.6.2 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: 6.0 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: lt_LT External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.1.6 PHP Post Max Size: 64 MB PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.83.1 OpenSSL/1.0.2k-fips SUHOSIN Installed: – MySQL Version: 10.3.35-MariaDB-log 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.6.1 WC Database Prefix: wp_ Total Database Size: 89.53MB Database Data Size: 71.91MB Database Index Size: 17.62MB wp_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 0.04MB + Index: 0.04MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wp_alm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_aws_cache: Data: 0.31MB + Index: 0.00MB + Engine MyISAM wp_aws_index: Data: 2.06MB + Index: 1.70MB + Engine MyISAM wp_cff_facebook_feed_locator: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cff_feeds: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_cff_feeds_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cff_feed_caches: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_cff_posts: Data: 0.12MB + Index: 0.00MB + Engine MyISAM wp_cff_sources: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_cli_cookie_scan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cli_cookie_scan_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cli_cookie_scan_cookies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cli_cookie_scan_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cli_scripts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_comments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_dpd_barcodes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_dpd_manifests: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_bans: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_itsec_dashboard_events: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_itsec_distributed_storage: Data: 2.63MB + Index: 0.00MB + Engine MyISAM wp_itsec_fingerprints: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_geolocation_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_lockouts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_logs: Data: 0.47MB + Index: 0.05MB + Engine MyISAM wp_itsec_mutexes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_opaque_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_temp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_user_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mclean_refs: Data: 0.51MB + Index: 0.23MB + Engine MyISAM wp_mclean_scan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 8.71MB + Index: 0.21MB + Engine MyISAM wp_postmeta: Data: 40.04MB + Index: 9.26MB + Engine MyISAM wp_posts: Data: 4.98MB + Index: 1.35MB + Engine MyISAM wp_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM wp_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_smush_dir_images: Data: 0.20MB + Index: 0.09MB + Engine MyISAM wp_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wp_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM wp_term_relationships: Data: 0.32MB + Index: 0.57MB + Engine MyISAM wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_usermeta: Data: 0.14MB + Index: 0.03MB + Engine MyISAM wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_product_meta_lookup: Data: 0.25MB + Index: 0.32MB + Engine MyISAM wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wd_fb_data: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_wd_fb_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wd_fb_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wd_fb_shortcode: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wd_fb_theme: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_woobe_history: Data: 0.16MB + Index: 0.10MB + Engine MyISAM wp_woobe_history_bulk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza_circles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza_polygon: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza_polylines: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpgmza_rectangles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_action_history: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_indexable: Data: 9.77MB + Index: 1.75MB + Engine MyISAM wp_yoast_indexable_hierarchy: Data: 0.64MB + Index: 1.56MB + Engine MyISAM wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wp_yoast_seo_links: Data: 0.15MB + Index: 0.05MB + Engine MyISAM wp_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM ### Post Type Counts ### attachment: 12822 cq_pinterest: 26 custom_css: 1 customize_changeset: 2 elementor_library: 2 itsec-dash-card: 6 itsec-dashboard: 1 nav_menu_item: 97 oembed_cache: 13 page: 13 post: 2 product: 3278 product_variation: 800 revision: 723 scrape: 56 wapf_product: 1 wp_global_styles: 1 wpcf7_contact_form: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (34) ### Advanced Woo Search: by ILLID – 2.56 Akismet Anti-Spam: by Automattic – 4.2.4 aThemes Blocks: by aThemes – 1.0.5 iThemes Security: by iThemes – 8.1.2 Blank Slate: by Aaron Reimann & Micah Wood – 1.2.1 Contact Form 7: by Takayuki Miyoshi – 5.6 GDPR Cookie Consent: by WebToffee – 2.1.2 Custom Facebook Feed Pro Personal: by Smash Balloon – 4.0.3 Facebook Chat Plugin - Live Chat Plugin for WordPress: by Meta – 2.4 Flying Scripts by WP Speed Matters: by Gijo Varghese – 1.2.2 Gutenslider — The last WordPress slider you will ever need.: by eedee – 5.8.2 Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5 WooCommerce Load More Products: by BeRocket – 1.1.9.4 Loco Translate: by Tim Whitlock – 2.6.2 Media Deduper: by Cornershop Creative – 1.5.5 Media File Renamer (Pro): by Jordy Meow – 5.3.8 Octolooks Scrapes: by Octolooks – 2.2.0 Product Enquiry for WooCommerce: by WisdmLabs – 3.1.6 Really Simple SSL: by Really Simple Plugins – 5.3.2 Smart Image Resize for WooCommerce: by Nabil Lemsieh – 1.7.6 Sync WooCommerce with Google Sheets: by N-Media – 6.10.2 TC Custom JavaScript: by Tiny Code – 1.2.3 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.22.12 User Role Editor: by Vladimir Garagulya – 4.62 WebP Converter for Media: by Mateusz Gbiorczyk – 4.4.0 BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 1.1.2 WooCommerce Product SKU Generator: by SkyVerge – 2.4.6 WooCommerce: by Automattic – 6.6.1 Yoast SEO: by Team Yoast – 19.1 Analytify - Google Analytics Dashboard: by Analytify – 4.2.1 WP Super Cache: by Automattic – 1.7.9 Categories to Tags Converter Importer: by wordpressdotorg – 0.5 ReCaptcha v2 for Contact Form 7: by IQComputing – 1.4.0 Related Products for WooCommerce: by WebToffee – 1.4.3 ### Inactive Plugins (2) ### Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 TaxoPress: by TaxoPress – 3.6.2 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (2) ### Health Check Troubleshooting Mode: by – 1.7.2 WordPress automation by Installatron: by – ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) 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: – ### WC Pages ### Shop base: #3221 - /prekes/ Cart: ? Page visibility should be public Checkout: ? Page visibility should be public My account: ? Page visibility should be public Terms and conditions: ? Page not set ### Theme ### Name: Gigant Version: 1.0 Author URL: Child Theme: ? Parent Theme Name: Botiga Parent Theme Version: 1.1.3 Parent Theme Author URL: https://athemes.com WooCommerce Support: ? ### Templates ### Overrides: – ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products homescreen 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 wc-pay-promotion wc-pay-welcome-page wc-pay-subscriptions-page Disabled Features: minified-js settings Daily Cron: ? Next scheduled: 2022-06-28 08:37:01 +03:00 Options: ? Notes: 60 Onboarding: completed ### Action Scheduler ### Complete: 177 Oldest: 2022-05-27 17:55:14 +0300 Newest: 2022-06-27 10:10:10 +0300 Pending: 1 Oldest: 2022-06-27 22:48:17 +0300 Newest: 2022-06-27 22:48:17 +0300 ### Status report information ### Generated at: 2022-06-27 12:38:55 +03:00
Hey @burgerino
I understand your CSV export does not contain the meta fields even after selecting the option. However, I could not reproduce the issue on my end.
This kind of problem is usually caused by a conflict with another plugin.
?
The best way to determine this is to:- 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 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.
- This reply was modified 2 years, 5 months ago by Daniel N. (woo-hc).
- The topic ‘CSV export missing meta fields’ is closed to new replies.