Are you looking for the best way to bulk export WooCommerce variable products and variations? You’re in the right place because we guide you step by step to export variable products with variations to a CSV file.
Related tutorial: how to import variable products and variations from a CSV file.
We will use the WP Sheet Editor plugin, which allows you to view and manage products and variations using an intuitive spreadsheet inside WordPress.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features
The plugin contains some important features to boost your productivity and simplify your WooCommerce store management
- Advanced search. Use any field as a search parameter to filter variable products and variations.
- Bulk editing. Bulk update hundreds of products and variations with a few clicks.
- Easy duplicates. Create hundreds of copies from a “master” product.
- Variations manager. Copy variations from one product to multiple products, create variations for every combination of attributes, etc.
- Export and import. You can quickly export and import products and variations data using CSV files.
Once you install and activate WP Sheet Editor, you can proceed to bulk export variable products’ data. We will show you two options: 1) how to export variable products without variations and 2) how to export variable products with variations.
Open the products’ spreadsheet
To open the products’ spreadsheet, you can go to WP Sheet Editor > Edit products. Optionally, you can go to Products > All products and click on Open in a spreadsheet.
You’ll see all your WooCommerce products displayed in the spreadsheet as rows, and all their fields as columns.
Option 1 – Export variable products without variations
If you want to export the variable products data without the variations, you need to first search for the variable products.
Start by opening the Search tool.
On the Search tool:
- Tick the Enable advanced filters checkbox.
- Field: Type (product_type)
- Operator: =
- Value: Variable
- Click on Run search.
As you can see, we have filtered all our variable products, and they have been displayed in the spreadsheet.
All active search filters will be displayed above the spreadsheet.
Now you can proceed to export WooCommerce variable products to a CSV file.
Start by opening the Export tool.
Once you’re on the export tool, select these values to start exporting variable products:
- Select the columns you want to export. You can export specific columns only, all active columns in the spreadsheet, or all columns.
- Select the rows you want to export. You can export all rows, all rows from a specific search, or all manually selected rows in the spreadsheet. In this case, we have filtered the variable products, so we will export all the search results.
- Select the app you’ll use to open the CSV. You can select Microsoft Excel 365, older versions of Microsoft Excel, Google Sheets, and other CSV editors.
- Optional – Add a name for this export
- Click on Start new export to download a CSV containing your variable products without variations.
As you can see below, we have exported our variable products without variations to a CSV file. This means we exported the parent products only. If you want to export both parent products and variations, you can go to the next section of this tutorial.
Option 2 – Export variable products with variations
If you want to export variable products with variations, you need to search for variable products with their variations.
Start by opening the Search tool.
Now you need to select these values to filter both the variations and their parent variable products:
- Tick the Search on variations checkbox.
- Click on Run search.
As you can see below, we have filtered both the variable parent products and their variations.
Now we can start exporting our WooCommerce variable products with variations.
Let’s open the Export tool.
Once you’re on the export tool, select these values to start exporting variable products:
- Select the columns you want to export. You can export specific columns only, all active columns in the spreadsheet, or all columns.
- Select the rows you want to export. You can export all rows, all rows from a specific search, or all manually selected rows in the spreadsheet. In this case, we have filtered the variable products, so we will export all the search results.
- Select the app you’ll use to open the CSV. You can select Microsoft Excel 365, older versions of Microsoft Excel, Google Sheets, and other CSV editors.
- Optional – Add a name for this export
- Click on Start new export to download a CSV containing your variable products without variations.
As you can see below, we have exported our variable products with variations to a CSV file.
If you pay attention to the Type column, you’ll see that the parent products have the “variable” value while variations read “variation”. The variations are next to their parent variable products.
In this tutorial, we have shown you how to export WooCommerce variable products with or without variations.
You can also use WP Sheet Editor to manage your product variations in bulk.
Here are some related tutorials:
- Bulk edit product variations
- Add product variations in bulk quickly
- Copy variations from one product to 100 products
- Bulk edit variation prices
- Delete WooCommerce variations in bulk
- Remove SKU from product variations in bulk
- Delete duplicate variations in bulk
- Set the same image to all variations
- Bulk delete out of stock variations