To export a product variation in WooCommerce, simply create a new export in All Export › New Export, choose WooCommerce Products from the dropdown list, add the filter to match your specific variation, and then run the export.
You can also export a product variation using the default WordPress exporter, but it doesn't provide as much functionality and control as WP All Export does, especially for product variation and attribute data.
How to Export a Product Variation in WooCommerce
Here are the steps needed to export a product variation in WooCommerce:
- Install the Pro versions of WP All Export and the WooCommerce Export Add-On.
- Navigate to All Export › New Export and choose WooCommerce Products from the dropdown list.
- Input a filter to target the specific product variation that you want to export.
- Set up the product and variation export columns.
- Run the export and download the export file.
You don't always need to define a filter for product variation exports. To export all product variations, follow the same steps from above but do the following:
- While setting up the export columns, click on Advanced Options.
- Under Product Variations, choose Only export product variations.
This will export all product variation data and exclude all parent products from the export.
To alter a product variation during the export, use custom PHP code: How to Pass Exported WordPress Data Through PHP Functions. There's also an option to create dynamic product variation columns during the export.
If needed, you can send the exported product variation to a third-party service using Zapier. Alternatively, you can use custom code and WP All Export's API (see Action Reference).
To modify a product variation outside of WooCommerce, export it, edit it in a spreadsheet and then re-import it. For more information, see How to Bulk Edit WooCommerce Products.
Note, product variation data is exported to a CSV file format by default. If you prefer working with XML or Excel, just change the export file type in the Drag & Drop screen. Product variation data is often easier to visualize in the indented XML format.
How to Export a Product Variation in WooCommerce — Related Documents
How to Export WooCommerce Variable Products
The official documentation for exporting WooCommerce variable products, complete with a walkthrough plus coverage of advanced topics like scheduling, formatting, and file type options.
How to Export Variable Products in WooCommerce?
A very similar article to the one you're reading, with a slightly different take on some subtopics.
How to Export WooCommerce Products?
A more general guide to exporting WooCommerce products.
Export WooCommerce Products to the Google Merchant Center
Expand your sales reach by posting your WooCommerce products to the Google Merchant Center. This can be achieved by exporting your products to a Google Merchant Center Export Feed, which can later be synced and used to fetch your products to your GMC account.
How to Import WooCommerce Product Variation Data?
This official guide explains how to import WooCommerce product variation data. The steps are very simple. Just upload your import file, set up the import process, and then run the import! Once done, you'll see your new product variation data in your WooCommerce store.
How to Import a Variable Product in WooCommerce?
A much quicker walkthrough of the steps required to import WooCommerce product variation data.
How to Bulk Upload Variable Products in WooCommerce?
A quick walkthrough on the steps required to bulk upload product variation data.
How to Modify Existing WooCommerce Product Data?
Import specific data to existing WooCommerce products using an Existing Items import process, mapping the exact data that you want to modify, and telling WP All Import to only update those specific fields. Learn more about this here: Manual Record Matching.
How to Bulk Edit WooCommerce Product Variation Data?
Bulk editing is a process that lets you modify large amounts of data. Just export your product variation data, perform the desired bulk-edit changes, then re-import everything back to your site. This documentation explains the process in detail.
How to Sync WooCommerce Product's Pricing?
You can sync WooCommerce product prices with an import file using WP All Import and an Existing Items import process. After setting up the price fields, you need to match them with the product that will be updated using something unique, such as SKU. To learn more, see Updating Product Prices.
Migrate WooCommerce Products to a Different Site
Migrate WooCommerce products to a different site using WP All Export and WP All Import. First, export all desired products and download the exported bundle file. Use that bundle file to import into the new site and complete the migration of your WooCommerce products.
