Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Pricing

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
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How Do I Bulk Upload Variable Products in WooCommerce?

To bulk upload variable products in WooCommerce, you can use the default product importer or our WP All Import plugin. The main advantages of using our plugin are its high levels of flexibility and control, which let you handle any variable product upload, no matter how complex.

Preparing to Bulk Upload WooCommerce Variable Products

If you use WP All Import, you don't have to worry about how your import file is organized or the data format used in incoming fields because our plugin lets you map any incoming data element to any WooCommerce product field. You can even modify the import data on the fly.

However, if you plan to overwrite existing information, then importing variable products becomes much riskier. As such, you should always back up your WooCommerce store before continuing.

Steps to Bulk Upload Variable Products in WooCommerce

  1. Go to All Import > New Import and choose how you want to import your data. You have the option to upload a file, use an existing file already on your server, or download a file from a URL or FTP/SFTP site.
  2. Select your import file.
  3. Choose New Items, then your import type. In this case, your import type is WooCommerce Products.
  4. Map the incoming data elements to your WooCommerce product fields using our Drag & Drop interface. This is the heart of the import process. When importing variable products, you must pay special attention to the product Attributes and product Variations tabs. See below for a more detailed description of these tabs.
  5. Configure the Import Settings to specify how the import should handle new, modified, or missing products should it be run again using a different version of the import file.
  6. Run the import and check the results to make sure the variable products have been imported correctly.

Understanding the Attributes Tab

Attributes add extra data to your product definitions. These can be used to search, describe, and filter your products. They can also be used to create product variations. For example, if a t-shirt has two attributes — Color and Size — these can be used to generate variations defined by the combination of those two attributes.

You map incoming data elements to the fields in the Attributes tab as follows:

WooCommerce Bulk Upload Variable Products Attributes Tab

You typically type the names of the attributes in the Name fields, while you map incoming data elements to the Values fields.

For more information on the Attributes tab, see How to Import Variable Products into WooCommerce — Attributes Tab.

Understanding the Variations Tab

The Variations tab lets you define the specific combination of attributes and attribute values that are used to create product variations.

There are many ways to structure this data in the import file. In this example, each variation has its own unique identifier (id) and is linked to its parent product via the parent product identifier (parentproductid):

WooCommerce Bulk Upload Variable Products Variations Tab

Note, however, that there are many other ways of defining this data. For a complete description of the most common ways of doing this, see How to Import Variable Variable Products into WooCommerce — Variations Tab.

Visual Steps to Bulk Upload Variable Products

Bulk Upload Variable Products — Frequently Asked Questions

How to Add New Variations to Existing Variable Products?

  1. Navigate to All Import › New Import.
  2. Select New Items as the import type.
  3. Upload the import file with the new variations.
  4. When configuring the import, select the I'm importing new variations to existing products option in the Variations tab.
  5. Run the import and check that all new variations are present as expected.

The I'm importing new variations to existing products option is available only in a New Items import. To match new variations with an existing variable parent product, use the product's title or any custom field. You can also use the Create new product if no existing product is found option to handle those situations.

What is the Correct Way to Handle Variable Products?

Variable products are stored in a specific manner. To avoid issues or damaging your products, you should have a master import that you can re-run and allows handling all products from a single master file. You should also use the New Items import type, as it's the only import type that can add/remove variations for variable products.

What Add-Ons Do I Need to Import WooCommerce Variable Products?

To import WooCommerce variable products, you need to have the WooCommerce Import Add-On active on your site, along with WP All Import.

Describes how to export WooCommerce products.

Describes how to import WooCommerce variable products.

 

The best import export plugin for WordPress & WooCommerce.

Complete, granular control of your data with an easy to use drag & drop interface.
  • 90 Day Money Back Guarantee
  • Unlimited Installs
  • Lifetime Licence
  • Fast, World-Class Support
Get Started
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$399
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$199
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Import
Pro Package
$199
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
Export
Pro Package
$199
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
cross