00
:
00
:
00
LIMITED TIME OFFER: Act now to lock in a 50% discount!
Risk free, backed by our 90-Day Money Back Guarantee.
Get Started

You may have seen some references on our site to annual licensing or renewals.

All plugins currently come with a lifetime license, no matter what the site says.

We’re currently running tests before we make the switch to annual pricing. Check the Discounts tab to purchase our other plugins and get a lifetime license before they’re gone.

I Understand I Have a Lifetime License

Lifetime licenses are only available for a short time!

SPECIAL OFFER 
Save 50% OFF For a Limited Time!
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee.
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How to Export WooCommerce Variable Products

To export WooCommerce variable products, go to All Export › New Export and select WooCommerce Products from the dropdown list. Customize your export file in the Drag & Drop interface, then run the export and download your exported variable products.

This documentation covers how to export WooCommerce products using WP All Export. For a broader look at exporting WooCommerce products, check out:

Step 1: Create a New Export for WooCommerce Variable Products

Go to All Export › New Export and select to export WooCommerce Products from the available list of post types.

Export Variable Products New Export

Export filters can be added using the option Add Filtering Options. To learn more, see Filter Exported WordPress Data.

Since we're exporting only variable products, we will add a filter to only export those products:

Element: Product Type
Rule: In Product Type
Value: variable

Export Variable Products Filter

Click Customize Export File to continue.

Step 2: Customize Your Variable Products Export File

You now see the Drag & Drop interface where you can build your export file by dragging export fields from the Available Data section into the column selection area.

Export Variable Products Customize Export Fields

You can also remove any field by dragging it and dropping it from the column selection area to any other interface part.

To add all available fields, simply click on Add All. You can also preview the selected data with the Preview green button.

Export Variable Products Preview

This guide focuses on exporting WooCommerce variable products. As such, we will explain the export fields associated with variable products specifically.

If you want to learn more about the other export fields available for WooCommerce products, please see Understanding WooCommerce Product Export Fields.

WooCommerce Product Data

The principal WooCommerce product fields are found in Available Data › Product Data:

  • Sku: A product code used to reference and differentiate products.
  • Price: The product's current price, which is the regular price unless the sale price is active and lower.
  • Regular Price: The regular, full price of the product.
  • Sale Price: The sale price of the product.
  • Stock Status: One of several preset values. The default WooCommerce stock statuses are instockoutofstock, and onbackorder.
  • Stock: The number of products currently in stock and available for sale.
  • External Product URL: The affiliate link for external products.
  • Total Sales: Number of times the product has been sold.
  • Attributes: This will export the attribute's name, value, whether it's used in variations, is visible, and is a taxonomy. This export element creates 5 columns per each attribute. This data is more easily exported in the Attributes section.
  • Shipping Class: If configured, it exports the name of the product's shipping class.

Variable products have different attributes, such as size or color. Those attributes will be automatically detected and added to the Attributes section at the bottom of Product Data.

Export Variable Products Attributes Section

Advanced Options

You will see an Advanced Options section with the following settings:

  • Separator: Used for CSV files. Defaults to a comma (,).
  • CSV Header Row: Has the option Include header row and column titles in export enabled by default. When disabled, the CSV file would have no header row.
  • Product Variations: these settings decide how to export the product variations, with the following options available (which are self-explanatory):
    • Export product variations and their parent products
      • Product variations use the parent product title
      • Product variations use the default variation product title
    • Only export product variations
      • Product variations use the parent product title
      • Product variations use the default variation product title
    • Only export parent products
Export Variable Products Advanced Options

Once the export is configured, click the blue Continue button at the bottom. You'll now see the Export Settings screen.

Step 3: Configure the Variable Products Export Settings

Export Variable Products Settings

Near the top of this screen, WP All Export shows a summary of what will be exported. You can also define Scheduling Options here and change other Advanced Options for the export. For example, you can set the batch processing size, control whether the export should be split into multiple output files, and even dictate the behavior for subsequent runs of the same export.

In this case, we'll leave all of these export settings as they are and click Confirm & Run Export to start the export process.

Step 4: Download Your Export File

Once the export finishes, you'll see an export complete message along with different options to download the exported file. You can download the selected file type (i.e., CSV, Excel, XML) or a Bundle compressed zip file that has the export file along with a template to use with WP All Import.

Export Variable Products Export Complete

Export WooCommerce Variable Products — Advanced Topics

Control How the Product Variations Are Exported

You can export variable products in three different ways: a) both variations and their parent products, b) only variations, or c) only parent products. Here's an example output CSV file for each:

Export product variations and their parent products:

Export Variable Products Example Variations and Parents

Only export product variations:

Export Variable Products Example Variations

Only export parent products:

Export Variable Products Example Parents

You can learn more in the Advanced Options section above.

Different File Outputs: What to Expect

You can export these WooCommerce variable products in CSV, Excel, or XML format. Here's an example output from each available format:

CSV or Excel:

Export Variable Products Example Variations and Parents

XML:

Export Variable Products Example XML

Automatically Export WooCommerce Variable Products on a Schedule

With WP All Export, you can schedule WooCommerce product export using one of these scheduling options:

  • Manual Scheduling: set up manual cron jobs via your control panel (such as cPanel or Plesk) that will run your export on a schedule. Learn more in Schedule WordPress Exports Using Cron Jobs.
  • Automatic Scheduling: this is our proprietary Automatic Scheduling Service, which has a small monthly fee. Its big advantage is that you can control scheduling via WP All Export's interface: Run WordPress Export on a Schedule.

Export WooCommerce Variable Products — Frequently Asked Questions

What is a WooCommerce Product Attribute?

A WooCommerce attribute describes a characteristic or feature of a product, such as a size or color. Attributes have terms, such as "blue", "green", etc., for a color attribute. Attribute terms can be combined to create variations. For example, the attribute term "blue" can be combined with the term "XL" to make a blue XL t-shirt variation.

What is a WooCommerce Variable Product?

A WooCommerce variable product is a product that is available in multiple variations, such as a t-shirt that comes in different colors and sizes. These variations are created using attributes. Each variation can have its own stock, price, images, etc.

How Do I Get Product Variation Data in WooCommerce?

To "get product variation data in WooCommerce" is just another way of saying that you want to export WooCommerce variable products, so all you have to do follow the steps in this tutorial.

How Do I Bulk Edit Variable Products in WooCommerce?

  1. Using WP All Export, export variable product data in either the Excel or CSV format.
  2. Use your favorite spreadsheet application to make bulk changes to the data that you exported.
  3. Import the changed data back into WooCommerce using WP All Import.
  4. Verify that the changes were correctly applied.

How Do I Import Product Variations in WooCommerce?

  1. Go to All Import › New Import in your WordPress site.
  2. Select how to import the data (i.e., upload a file, download a file from a URL, etc.).
  3. Choose WooCommmerce Products as the import target.
  4. Map incoming fields to your WooCommerce target fields with drag & drop.
  5. Use the I'm importing new variations to existing products option in the Variations tab.
  6. Perform the import.

To see the list of full import features, see Import WooCommerce Products.

How Do I Export WooCommerce Products to Excel?

  1. Make a new export via All Export > New Export.
  2. Choose WooCommerce Products from the dropdown list.
  3. Set up the export file by customizing the export columns.
  4. Change the file format in Export Type > Spreadsheet > Excel File.
  5. Run the export and proceed to download the Excel file.

To learn more, see Export WooCommerce Products.

How Do I Export my WordPress Product Feed for Google Shopping?

  1. Navigate to All Export › New Export and choose WooCommerce Products.
  2. Modify the Export Type to Feed › Google Merchant Center Product Feed.
  3. Set up the Google Merchant Center export as required.
  4. Upload the exported .TXT file to Google.

For more information, see Export WooCommerce Products to Google Shopping.

Learn how to export WooCommerce products.

Learn how to import WooCommerce products.

Describes how to import WooCommerce variable products.

Learn how to export WooCommerce products with images.

Learn how to import WooCommerce products with images.

Describes how to bulk edit WooCommerce products.

Describes how to migrate WooCommerce products from one website to another.

Learn to pass your exported variable product data through a PHP function to modify it.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Unlimited Installs. World-class Support.
Money Back Guarantee.

Packages
Standalone
Import
Pro Package
  normally $499.00  
$249.00
/year
Save $250, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
  normally $599.00  
$299.00
/year
Save $300, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
  normally $299.00  
$149.00
/year
Save $150, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
  normally $199.00  
$99.00
/year
Save $100, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
  normally $339.00  
$169.00
/year
Save $170, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
  normally $199.00  
$99.00
/year
Save $100, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross