Export Product Variations in WooCommerce

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Variable products in WooCommerce are a product type that allows you to set different variation on a product. Each of the variations of a variable product has different SKU, can have different stock, prices, etc.

When you need to export the products variations from your WooCommerce store. Your store may have all type of products and selectively pick and export only the variable products may seem like a difficult task. The Product Import Export Plugin for WooCommerce will help you export all the variable products in your WooCommerce store quickly and easily.

The Product Import Export Plugin for WooCommerce allows you to Export all different products into a CSV file. It also gives you the power to export only one product type into a CSV file. This can help you keep separate CSV files for different product types.

Let’s understand importing a variable product into a CSV file, using the Product Import Export Plugin for WooCommerce.

Suppose, you have a variable product T-shirt with two attributes size and color. So, when exporting, you need to have the parent product and all its variations in the CSV. The CSV file will also have additional metadata than a simple product has. The variations will have their unique SKUs and they will be connected to the parent product using the parent_SKU.

The following are the steps to export a variable product.

Navigate to WooCommerce > Product Im-Ex section from your WooCommerce store dashboard. Under the Product tab, move to Export Product in CSV Format section by clicking on the Export tab, as shown below:Product export page

To export only the variable products of your WooCommerce store, From the Product Types field, enter the Variable product.

If you wish to skip a certain number of products, enter an offset value from which you wish to start the export. You can specify a limit to export a finite number of products. You can also specify specific product categories to be exported. Configure other settings and select desired columns to be exported and click Export Products to start exporting products. The CSV file is automatically downloaded on your computer.

The following is the resulting CSV that will be downloaded to your computer.

Sample CSV for variable products

Read all about importing and exporting the products from the plugin documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

 

Leave a Reply

Your email address will not be published. Required fields are marked *