search

woocommerce / woocommerce

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine.
https://woocommerce.com
9.32k stars 10.74k forks source link

all products are getting exported when selecting product variations in woocommerce default exporter #26159

Closed onebyezero closed 4 years ago

onebyezero commented 4 years ago

Describe the bug When exporting products using Woocommerce in-built exporter and selecting product variations for export. The CSV exported contains all products including simple and variable products.

To Reproduce Steps to reproduce the behavior:

  1. Go to Products > All Products
  2. Click on Export
  3. Select "Product Variations" in what product types should be exported field.
  4. check CSV exported

Screenshots image

image

If applicable, add screenshots to help explain your problem.

Expected behavior The exporter should have exported only product variations in CSV.

Isolating the problem (mark completed items with an [x]):

WordPress Environment

``` ` ### WordPress Environment ### WordPress address (URL): https://lowydev.wpengine.com Site address (URL): https://lowydev.wpengine.com WC Version: 4.0.1 REST API Version: ✔ 1.0.7 WC Blocks Version: ✔ 2.5.14 Action Scheduler Version: ✔ 3.1.4 WC Admin Version: ✔ 1.0.3 Log Directory Writable: ✔ WP Version: 5.4 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.4 PHP Post Max Size: 200 MB PHP Time Limit: 600 PHP Max Input Vars: 10000 cURL Version: 7.58.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.7.28-31-log Max Upload Size: 200 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.0.1 WC Database Prefix: wp_ Total Database Size: 127.20MB Database Data Size: 80.99MB Database Index Size: 46.21MB 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: 0.02MB + 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: 1.52MB + Index: 0.41MB + 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.28MB + Index: 0.23MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + 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.14MB + Index: 0.03MB + Engine InnoDB wp_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_section_storage: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 9.27MB + Index: 0.22MB + 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.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 54.56MB + Index: 37.44MB + Engine InnoDB wp_posts: Data: 5.52MB + Index: 3.84MB + Engine InnoDB wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wp_revslider_css_bkp: Data: 0.02MB + 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.36MB + Index: 0.00MB + Engine InnoDB wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_slides: Data: 0.38MB + Index: 0.00MB + Engine InnoDB wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_static_slides: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_termmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB wp_terms: Data: 0.09MB + Index: 0.09MB + Engine InnoDB wp_term_relationships: Data: 3.52MB + Index: 1.47MB + Engine InnoDB wp_term_taxonomy: Data: 0.14MB + Index: 0.17MB + Engine InnoDB wp_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tm_taskmeta: Data: 1.52MB + Index: 0.11MB + Engine InnoDB wp_tm_tasks: Data: 0.19MB + Index: 0.05MB + Engine InnoDB wp_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + 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.02MB + 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_meta_lookup: Data: 1.52MB + Index: 0.81MB + 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_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.11MB + Index: 0.05MB + Engine InnoDB wp_yoast_seo_meta: Data: 0.33MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### acf-field: 3 acf-field-group: 3 attachment: 9814 custom_css: 1 customize_changeset: 7 footer: 1 megamenu: 2 nav_menu_item: 68 page: 53 post: 93 product: 5851 product_enquiry: 1 product_variation: 10 revision: 19 templatera: 6 vc_grid_item: 4 vc_settings_preset: 6 wbcr-snippets: 5 wcpf_item: 24 wcpf_project: 5 wpbfwpb_template: 2 wpcf7_contact_form: 5 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (39) ### Redux Framework: by Team Redux – 3.6.18 AddToAny Share Buttons: by AddToAny – 1.7.40 Advanced Custom Fields: by Elliot Condon – 5.8.9 AJAX Search for WooCommerce: by Damian Góra – 1.6.3 – Not tested with the active version of WooCommerce All-in-One WP Migration Unlimited Extension: by ServMask – 2.37 All-in-One WP Migration: by ServMask – 7.19 Antive Toolkit: by Fami Themes – 1.2.3 Classic Editor: by WordPress Contributors – 1.5 Contact Form 7: by Takayuki Miyoshi – 5.1.7 DZS Tooltip: by Digital Zoom Studio – 1.02 Fami Sales Popup: by Fami Themes – 2.0.0 Intercom: by Intercom – 2.6.4 WPBakery Page Builder: by Michael M - WPBakery.com – 6.1 WooCommerce Load More Products: by BeRocket – 1.1.7 – Not tested with the active version of WooCommerce Max Mega Menu - Pro Addon: by megamenu.com – 2.0.1 Max Mega Menu - StoreFront Integration: by megamenu.com – 1.0.3 Max Mega Menu: by megamenu.com – 2.7.6 Meta Box: by MetaBox.io – 5.2.8 Monitization: by Igor Glavatskiy – 1.0 PDF Embedder: by Lever Technology LLC – 4.6 Permalink Manager Pro: by Maciej Bis – 2.2.8.3 – Not tested with the active version of WooCommerce WooCommerce Product Filter: by Mihajlovic Nenad – 6.6.5 – Not tested with the active version of WooCommerce Product CSV Import Export (BASIC): by WebToffee – 1.7.7 – Not tested with the active version of WooCommerce Reading Time WP: by Jason Yingling – 2.0.9 Slider Revolution: by ThemePunch – 6.2.2 Visual Composer - Sortable Grid & Taxonomy filter: by InfiWebs – 3.1.0 Sticky Menu (or Anything!) on Scroll: by WebFactory Ltd – 2.2 Templatera: by WPBakery – 1.1.12 TI WooCommerce Wishlist Plugin: by TemplateInvaders – 1.17.0 – Not tested with the active version of WooCommerce Mobile Detect: by Pothi Kalimuthu – 1.1.3 WC Builder Pro - WooCommerce Page Builder for WPBakery: by CodeCarnival – 1.0.4 – Not tested with the active version of WooCommerce Preview E-mails for WooCommerce: by Digamber Pradhan – 1.6.4 – Not tested with the active version of WooCommerce WooCommerce Admin: by WooCommerce – 1.0.3 – Not tested with the active version of WooCommerce Product Filters for WooCommerce: by Nexter – 1.1.16 – Not tested with the active version of WooCommerce WooCommerce: by Automattic – 4.0.1 Yoast SEO: by Team Yoast – 13.4.1 WP-SCSS: by Connect Think – 1.2.5 WP Engine Automated Migration: by WPEngine – 3.9 YITH WooCommerce Wishlist: by YITH – 3.0.9 – Not tested with the active version of WooCommerce ### Inactive Plugins (18) ### Akismet Anti-Spam: by Automattic – 4.1.4 Epic News Elements: by Jegtheme – 2.2.4 Glider for WPBakery: by Merkulove – 1.0.0 Media Cleaner: by Jordy Meow – 5.6.2 Media Cleaner Pro: by Jordy Meow – 5.6.1 Premmerce Permalink Manager for WooCommerce: by premmerce – 2.1.14 – Not tested with the active version of WooCommerce Product Sort and Display for WooCommerce: by a3rev Software – 2.0.1 – Not tested with the active version of WooCommerce Rebuild Permalinks: by Gerry Tucker – 1.6 RSS Importer: by wordpressdotorg David Lynch – 0.3 SKU Shortlink For WooCommerce: by Varun Sridharan – 1.3.5 – Not tested with the active version of WooCommerce Smart Slider 3: by Nextend – 3.3.28 Ultimate Blocks: by Ultimate Blocks – 2.3.0 Variation Swatches for WooCommerce: by Emran Ahmed – 1.0.79 – Not tested with the active version of WooCommerce WooCommerce Attribute Images: by weLaunch – 1.1.7 – Not tested with the active version of WooCommerce WooCommerce Product Enquiry: by MingoCommerce – 2.3.1 – Not tested with the active version of WooCommerce WooCommerce Single Variations: by weLaunch – 1.1.2 – Not tested with the active version of WooCommerce WordPress Importer: by wordpressdotorg – 0.7 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.0.19 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (4) ### Force Strong Passwords - WPE Edition: by Jason Cosper – 1.6.4 WP Engine Seamless Login Plugin: by WP Engine – 1.5.3 WP Engine Security Auditor: by wpengine – 1.0.8 WP Engine System: by WP Engine – 4.0.0 ### 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: ✔ ### WC Pages ### Shop base: #5952 - /shop Cart: #628 - /cart/ Checkout: #629 - /checkout/ My account: #630 - /my-account/ Terms and conditions: #631 - /terms-and-conditions/ ### Theme ### Name: Twenty Twenty Version: 1.1 – 1.2 is available Author URL: https://wordpress.org/ Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: – ### TI WooCommerce Wishlist Templates ### Overrides: – ### Action Scheduler ### Complete: 1,012 Oldest: 2020-03-10 19:04:10 +0000 Newest: 2020-04-10 17:38:55 +0000 Pending: 3 Oldest: 2020-04-10 18:38:55 +0000 Newest: 2020-09-27 02:42:18 +0000 ` ```
onebyezero commented 4 years ago

The issue was a conflict with the external export plugin "Product CSV Import Export (BASIC)", I disabled it and it worked.