By the end of this tutorial, you\u2019ll know how to export only the exact variable products and variation data you need while saving hours of manual work.<\/p>\n\n\n\n
What are WooCommerce product attributes?<\/h2>\n\n\n\n
Product attributes are a fantastic tool for giving customers more information about your products. Attributes can help them quickly find the right options and compare them with each other.<\/p>\n\n\n\n
For example, suppose that you are selling clothes in your online store. Each cloth has some attributes like Color, Size, Brand, etc.<\/p>\n\n\n\n
What are WooCommerce product variations?<\/h2>\n\n\n\n
Variations are made by combining two or more attributes and they can be used to create variable products in WooCommerce. Each variable product could have multiple variations with different prices, or images displayed in a single product page to the customers. <\/p>\n\n\n\n
When customers visit a variable product in WooCommerce stores, they can review variations with their respective options before adding any of them to the cart.<\/p>\n\n\n\n
For example, suppose that you add a T-Shirt as a variable product. So, you may create three different variations like below:<\/p>\n\n\n\n
- \n
- Grey- Medium: $49.99<\/li>\n\n\n\n
- Red- Medium: $55<\/li>\n\n\n\n
- Green-Large: $60<\/li>\n<\/ul>\n\n\n\n
So, when customers visit the T-Shirt page, they can compare the prices of all three variations and add the preferred one to their carts.<\/p>\n\n\n\n
![\"Add](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-01-add-variable-product-to-cart.png\")
<\/a>Product variations<\/figcaption><\/figure>\n\n\n\n How to set up a variable product in WooCommerce?<\/h3>\n\n\n\n
You can add variable products in WooCommerce by following the three steps:<\/p>\n\n\n\n
Step 1: Add attributes to WooCommerce <\/h4>\n\n\n\n
As we mentioned above, you need to use attributes for creating product variations. So, the first step is to add a Product Attribute by navigating to the below address:<\/p>\n\n\n\n
WordPress Dashboard > WooCommerce > Products > Attributes (1)<\/strong><\/p>\n\n\n\n
![\"Add](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-03-add-attribute-woocommerce.png\")
<\/a>Add product attributes<\/figcaption><\/figure>\n\n\n\n 2. Then, give your attribute a Name<\/strong> (Visible for customers in the product page) and, optionally, a Slug<\/strong> (Used internally by WooCommerce).<\/p>\n\n\n\n
3. Press the \u201cAdd Attribute<\/strong>\u201d button to add the attribute to the main attributes page.<\/p>\n\n\n\n
To finalize the process, you need to add attribute terms by pressing Configure terms<\/strong> on the attribute list:<\/p>\n\n\n\n
![\"Configure](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-05-configure-attribute-term.png\")
<\/a>configure tems of attributes<\/figcaption><\/figure>\n\n\n\n Here, you can add as many terms as you need under the selected attribute.<\/p>\n\n\n\n
![\"add](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-07-add-attribute-terms.jpg\")
<\/a>Add terms<\/figcaption><\/figure>\n\n\n\n For example, if you have added Color<\/strong> as an Attribute<\/strong>, it is possible to insert Red, Green, Grey, etc<\/strong>. As its term to WooCommerce.
<\/p>\n\n\n\nStep 2: Create Variations on the WooCommerce product page <\/h3>\n\n\n\n
Once you have added the proper attributes with their terms, it is time to use them for creating variations. <\/p>\n\n\n\n
To do this task, first, you need to create a new product or visit a product page. Then, try to:<\/p>\n\n\n\n
- \n
- Select the Variable product<\/strong> type in the Product Data<\/strong> section. <\/li>\n<\/ul>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-09-set-product-as-variable.jpg\")
<\/a>Choose product type<\/figcaption><\/figure>\n\n\n\n - \n
- Go to the Attributes<\/strong> section, add an attribute like \u201cColor<\/strong>\u201d then choose its terms such as \u201cRed<\/strong>, Grey<\/strong>\u201d etc. <\/li>\n\n\n\n
- Mark the \u201cUsed for variations<\/strong>\u201d checkbox.<\/li>\n<\/ul>\n\n\n\n
![\"add](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-011-add-attribute-to-.png\")
<\/a>Add product attributes<\/figcaption><\/figure>\n\n\n\n - \n
- Click on the Save attributes <\/strong>button.<\/li>\n<\/ul>\n\n\n\n
Step 3: Add and Edit product variation data<\/h4>\n\n\n\n
![\"Generate](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-013-generate-product-variations.jpg\")
<\/a>Generate variations<\/figcaption><\/figure>\n\n\n\n The last step is generating Variations<\/strong> by opening the Variations<\/strong> tab and pressing the Generate Variations<\/strong> button:
<\/p>\n\n\n\nNow, you can see a list of all variations and you are able to edit their features one by one:<\/p>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-015-set-product-variations.jpg\")
<\/a>List of product variations<\/figcaption><\/figure>\n\n\n\n As illustrated below, you can add SKU<\/strong>, Regular Price<\/strong>, Image<\/strong>, Stock<\/strong> Status<\/strong>, etc. For each variation.
<\/p>\n\n\n\n![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-017-set-product-variation-price.jpg\")
<\/a>Variations settings<\/figcaption><\/figure>\n\n\n\n Finally, you need to press Save Changes<\/strong> and Update<\/strong> the product page to show the Variable product in your store.<\/p>\n\n\n\n
How to export variable products in WooCommerce?<\/h2>\n\n\n\n
To export variable products in WooCommerce, You can use either WordPress or WooCommerce default exporters. However, they are not flexible enough to export the exact products or variations that you may need. To solve this problem, you can get help from the WooCommerce products bulk editing plugin which is a great tool for bulk editing, exporting, and importing products in WooCommerce.<\/p>\n\n\n\n
Continue reading to learn about three different methods for WooCommerce export variable products with and without plugin.<\/p>\n\n\n\n
<\/div>\n\n\n\nMethod 1: Export products with variations using the default WooCommerce exporter<\/h3>\n\n\n\n
The first method for WooCommerce export variable products is the default WooCommerce exporter which allows you to export custom data in a CSV file.<\/p>\n\n\n\n
To use this exporter, try to:<\/p>\n\n\n\n
- \n
- Go to the All Products<\/strong> page.<\/li>\n\n\n\n
- Press the Export<\/strong> button on top of the table.<\/li>\n<\/ul>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-019-export-woocommerce-products.png\")
<\/a>Export products<\/figcaption><\/figure>\n\n\n\n – Choose which products you want to export based on the following fields:<\/p>\n\n\n\n
- \n
- Which columns should be exported<\/strong>: Select the product fields you want to export like tag, attribute, price, etc.<\/li>\n\n\n\n
- Which product type<\/strong>: Choose Variable product<\/strong> to export variable products in WooCommerce. You can choose other products type like Simple products<\/strong>.<\/li>\n\n\n\n
- Which Category<\/strong>: You can select one or more categories to export the related products. <\/li>\n\n\n\n
- Export custom meta<\/strong>: Mark this option if you want to export meta fields as well.<\/li>\n<\/ul>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-021-export-product-to-csv-details.png\")
<\/a>Choose what to be exported<\/figcaption><\/figure>\n\n\n\n - \n
- Press Generate CSV<\/strong> to let WooCommerce export variable products in a CSV<\/strong> file and save to your system<\/li>\n<\/ul>\n\n\n\n
![\"Exported](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-023-exported-product-result.png\")
<\/a>Generated csv<\/figcaption><\/figure>\n\n\n\n The default exporter also allows you to export WooCommerce product variations. To make this happen, you need to choose Product variations<\/strong> in the Which Product Type<\/strong> field:<\/p>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-024-export-product-variations-in-woocommerce-default.png\")
<\/a>Select product type to be exported<\/figcaption><\/figure>\n\n\n\n By choosing the product variations option, the item to select categories is missing, but you get a more detailed CSV as illustrated below:<\/p>\n\n\n\n
![\"Exported](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-025-exported-product-variations-in-woocommerce.png\")
<\/a>Exported only variations<\/figcaption><\/figure>\n\n\n\n <\/div>\n\n\n\nMethod 2: WooCommerce export variable products using WordPress Exporter<\/h3>\n\n\n\n
WordPress has a simple exporter allows store managers to export either Products or variations as an XML file.<\/p>\n\n\n\n
To use the exporter, you can simply go to Tools > Export.<\/strong><\/p>\n\n\n\n
![\"WordPress](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-027-wordpress-default-exporter.png\")
<\/a>Open wordpress exporter<\/figcaption><\/figure>\n\n\n\n In this form, you can choose what to export:<\/p>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-028-export-product-variations-from-wordpress-exporter.png\")
<\/a>choose variations<\/figcaption><\/figure>\n\n\n\n For example, if you select Variations<\/strong> and press Download Export<\/strong> File, you will receive an XML file including all data related to the variations in your store:<\/p>\n\n\n\n
![\"Exported](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-030-exported-variation-xml-file.png\")
<\/a>generated xml<\/figcaption><\/figure>\n\n\n\n It is also possible to select Products<\/strong> from the list and export the XML file which contains the data related to all products in your store including variable products:<\/p>\n\n\n\n
![\"Exported](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-032-exported-variable-product-xml-file.png\")
<\/a>exported Products as xml <\/figcaption><\/figure>\n\n\n\n Although working with a default exporter is extremely easy and fast, you have no option for filtering the products or choosing the custom fields for WooCommerce export variable products.<\/p>\n\n\n\n
That\u2019s why we recommend you use the WooCommerce bulk edit products plugin which can be used as a powerful WooCommerce product exporter.<\/p>\n\n\n\n
Let\u2019s figure out how this plugin can empower you to export variable products WooCommerce nice and smooth.<\/p>\n\n\n\n
<\/div>\n\n\n\nMethod 3: WooCommerce export variable products by WooCommerce products bulk edit plugin<\/h3>\n\n\n\n
The WooCommerce products bulk edit plugin<\/a> makes mass changes on WooCommerce product details incredibly intuitive. You\u2019re in control of your WooCommerce products with the power of practical tools provided in this plugin such as a comprehensive filter form, flexible bulk edit form, and editable product table.<\/p>\n\n\n\n
With no more tedious clicking through countless pages, the plugin allows you to make changes to multiple products at the same time. Moreover, all changes are visible in a product table with customizable columns. <\/p>\n\n\n\n
To fulfill the purpose of WooCommerce export variable products, you can take advantage of an easy to use export form enabling you to choose exactly what to export.<\/p>\n\n\n\n
Here, we will lead you through a step-by-step guide to export variable products WooCommerce with this plugin.<\/p>\n\n\n\n
Step 1: Install WooCommerce bulk editing product plugin<\/h4>\n\n\n\n
The installation process is not complicated, you can set up the plugin just like other WordPress extensions through a FTP server. We also provide an installation guide for beginners, here<\/strong>:<\/p>\n\n\n\n
Read more:<\/strong> How to install the PBULKiT \u2013 Bulk Edit WooCommerce Products plugin?<\/a><\/p><\/blockquote><\/figure>\n\n\n\n
Once the plugin is activated, you will see the IT Bulk editing<\/strong> menu in the WordPress Dashboard. To have access to the main page, open the tab and click on Woo Products<\/strong>.<\/p>\n\n\n\n
![\"Select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-woo-products-submenu.png\")
<\/a>Open PBULKiT plugin<\/figcaption><\/figure>\n\n\n\n In the main page, a list of all WooCommerce products along with a comprehensive toolbar is ready to be used.<\/p>\n\n\n\n
![\"WooCpmmerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-034-woo-bulk-edit-main-page.png\")
<\/a>PBULKiT plugin main page<\/figcaption><\/figure>\n\n\n\n To export variable products WooCommerce, you need to use the following tools:<\/p>\n\n\n\n
- \n
- Filter Form<\/li>\n\n\n\n
- Import\/ Export form<\/li>\n\n\n\n
- Column Manager<\/li>\n<\/ol>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/image.png\")
<\/a>Tools to export<\/figcaption><\/figure>\n\n\n\n Let\u2019s review how these tools make WooCommerce export variable products easier for you.<\/p>\n\n\n\n
\n\n\nPBULKiT – Bulk Edit WooCommerce Products<\/p>\n\n\n\n
The easy way to export variable products in WooCommerce<\/p>\n\n\n\n
\nBuy Plugin<\/a><\/div>\n\n\n\nFree Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n\n![\"PBULKiT](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nStep 2: Filter WooCommerce variable products<\/h4>\n\n\n\n
With the advanced and versatile filter form that supports all WooCommerce fields and meta fields, you can easily search and filter WooCommerce products based on: categories, attributes, tags, taxonomies, regular\/sale price, product type, etc.<\/p>\n\n\n\n
With its powerful and user-friendly interface, this smart tool provides a seamless filtering experience to help you find the desired products efficiently.<\/p>\n\n\n\n
Once you open the filter form, you can find all WooCommerce fields divided into seven tabs to help you quickly locate your preferred fields and set your limitations by using the unique operators designed for each one individually.<\/p>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-036-woo-bulk-edit-filter-form.png\")
<\/a>PBULKiT filter form<\/figcaption><\/figure>\n\n\n\n As you aim to export variable products in WooCommerce, simply go to the Type<\/strong> tab and set the Product type<\/strong> field to Variable products<\/strong>.<\/p>\n\n\n\n
You can also set other filters if needed, then press the Apply<\/strong> to table button, to see the filtered products in the table.<\/p>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-038-woo-bulk-filter-by-product-type.png\")
<\/a>Filter variable products<\/figcaption><\/figure>\n\n\n\n Step 3: Export variable products WooCommerce<\/h4>\n\n\n\n
When you have successfully filtered the variable product, press the Import\/Export<\/strong> tool on the Toolbar to open the related form.<\/p>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-039-woo-bulk-edit-export-form.png\")
<\/a>Export all variable products all fields<\/figcaption><\/figure>\n\n\n\n Here, by set available options, you can export variable products according to one of the below conditions:<\/p>\n\n\n\n
All products in the table \/ All fields<\/strong>: This means all of the variable products you have filtered in the previous step with all their data will be exported to the CSV file.<\/p>\n\n\n\n
Only selected products \/ All fields<\/strong>: This option is available when you have already marked some products in the table. So, it is useful if you want to export all data of some specific products.<\/p>\n\n\n\n
All Products in the table \/ only visible fields<\/strong>: This option has the best result when you just want to export some specific fields of all variable products. To add your preferred fields to the table, you need to use the Column Manager form \u2013 don\u2019t worry we will explain how to use it later.<\/p>\n\n\n\n
Only selected products \/ Only visible fields<\/strong>: This is the most customized item that you can choose. The exported products are those you have marked in the table with the fields that you have already set to be displayed in the table from the column manager form. So, if you need to expert some specific fields of selected variable products, this option is your choice.<\/p>\n\n\n\n
Let\u2019s make an example to better understand how to work with the tools.<\/p>\n\n\n\n
Example 1: Export tags, regular\/sale prices, and attributes of some variable products<\/h4>\n\n\n\n
To export some fields of multiple variable products, first, we need to open the column profiles form and add those columns to the table.<\/p>\n\n\n\n
So, after opening the Column Profile<\/strong> form from the toolbar, we marked the proper fields to make them visible in the table as illustrated below: <\/p>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-040-woo-bulk-edit-column-manager.png\")
<\/a>Choose columns to display<\/figcaption><\/figure>\n\n\n\n As soon as pressing the Apply to table<\/strong> button, those fields are displayed in the table.<\/p>\n\n\n\n
![\"WooCommerce](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-042-woo-bulk-edit-added-column-result.png\")
<\/a>Display selected columns in table<\/figcaption><\/figure>\n\n\n\n Now, we are ready to mark some of the variable products in the table and then open the Import\/Export<\/strong> form.<\/p>\n\n\n\n
To reach our goal, we tried to select Only selected products \/ Only visible<\/strong> fields<\/strong> and finally click on the Export now<\/strong> button.<\/p>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-044-export-visible-fields-of-selected-products.png\")
<\/a>Export selected products and only visible fields<\/figcaption><\/figure>\n\n\n\n Once the CSV<\/strong> file was downloaded and saved to our system, we opened it with Excel<\/strong> and the result was exactly as we expected: <\/p>\n\n\n\n
![\"woo](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/07\/111-045-woo-bulk-edit-export-product-result.png\")
<\/a>Generated csv file<\/figcaption><\/figure>\n\n\n\n \n\n\nPBULKiT – Bulk Edit WooCommerce Products<\/p>\n\n\n\n
The easy way to export variable products in WooCommerce<\/p>\n\n\n\n
- Which product type<\/strong>: Choose Variable product<\/strong> to export variable products in WooCommerce. You can choose other products type like Simple products<\/strong>.<\/li>\n\n\n\n
- Press the Export<\/strong> button on top of the table.<\/li>\n<\/ul>\n\n\n\n
- Go to the All Products<\/strong> page.<\/li>\n\n\n\n
- Mark the \u201cUsed for variations<\/strong>\u201d checkbox.<\/li>\n<\/ul>\n\n\n\n
- Go to the Attributes<\/strong> section, add an attribute like \u201cColor<\/strong>\u201d then choose its terms such as \u201cRed<\/strong>, Grey<\/strong>\u201d etc. <\/li>\n\n\n\n
- Select the Variable product<\/strong> type in the Product Data<\/strong> section. <\/li>\n<\/ul>\n\n\n\n