Rating 2 stars - 2 votes

WooCommerce Import Variable Products Tutorial

If your WooCommerce store sells variable products, you've come across the right post. Here you'll learn how to import WooCommerce variable products and bypass monotonous and time-consuming work of adding variations manually.


Imported WooCommerce Variable Product on the Front End
Imported WooCommerce Variable Product on the Front End

Store Manager for WooCommerce import tool allows creating and updating product variations in a quick way.


WooCommerce Import Variable Products: Sample File

First and foremost, you should prepare an import file. Take a look at the fields that you need to include so that products with variations could be created correctly.


  • SKU - this column stands for a product SKU and serves for identifying products in the process of import. Input an SKU for a parent product and each variation you are going to create.

  • WooCommerce Store Manager Import Variations Sample File SKU field

  • Product type - put 'variable' for the main product and 'variation' for each product variation.

  • WooCommerce Store Manager Import Variations Sample File Rows

  • Post status - to get variable product and its selections displayed at the storefront, provide 'publish' for each.
  • Stock status - insert either 'In Stock' or 'Out of stock' for each item.
  • Manage stock - enable or disable quantity tracking for your variable products.
  • Attribute name - your WooCommerce variations depend on the product characteristics called attributes. Specify attributes in this column in separate rows to create WooCommerce variations.
  • In our example, we're going to create associated items varying in color and size. These attributes are specified for the parent product within separate rows in 'Attribute name' column.

  • Attribute values - this column lists all the values of a specific attribute. Values are separated with a pipe line. The 'Color' attribute has values Black|Green. The 'Size' Attribute has 36|37|38|39|40|41|42 values. Both attributes and their values are specified for the parent product.

  • WooCommerce Store Manager Import Variations Sample File Values

  • Attribute is visible - defines whether the attribute will or not be displayed at the store front, additional data section. (0 - don’t display the attribute, 1 - display the attribute)
  • Attribute is variation - this parameter defines whether the attributes will be used for creating product variations. If this is a variable product and the attribute will be used to create variations, then = 1, if the attribute is just a product characteristic, then value = 0.
  • Attribute is taxonomy (global). If an attribute is used in taxonomy (Taxonomy=1), it is displayed in the admin, tab Products > Attributes, and can be used for creating variable products.
  • Read more about creating WooCommerce attributes with values via import.

  • Regular Price - you can set prices for WooCommerce variations providing values for them in this field.
  • Parent - to link simple products to the main one, you should create relations. Specify parent product SKU for each associated simple item in the file.

  • WooCommerce Store Manager Import Variations Sample File Parent

  • Custom Fields:Name
  • Custom Fields:Value

  • WooCommerce Store Manager Import Variations Custom Fields

  • Other fields to create variable products with variations: Description, Title, Stock, Enable Reviews, Back Orders, Sold Individually, Tax Class, Tax Status, Catalog Visibility, Featured Image, Product Image Gallery.

  • Download a WooCommerce variations import sample file to see the structure and all required fields.

WooCommerce Import Variable Products Performance

To import WooCommerce variations, use the advanced import tool with Store Manager for WooCommerce. Follow the steps in the Wizard to complete the upload successfully.

  1. Launch the Wizard by going to Store Manager menu > Products > Import products:

  2. Import Wizard Launch for WooCommerce Variables Import
    Import Wizard Launch for WooCommerce Variables Import

  3. Select the file stored locally or paste the HTTP or FTP URL to the file stored remotely. You can also import a file from Google Sheets.

  4. Specify the delimiters used in the import file. With correct delimiters, the data will be parsed correctly:

  5. File Delimiters During Import of WooCommerce Variables
    File Delimiters During Import of WooCommerce Variables

  6. Next you need to associate the data you have in the import file with the suitable database fields. Select a database field in the lft pane and then pick a matching columt from your file.

  7. WooCommerce Variables Import Mapping Step
    WooCommerce Variables Import Mapping Step

    Another important thing is to set a product identifier used to recognize products in the process of data import. For the import of new products you should use SKU as identifiers. For the update of existing products, you can use just the Product ID field.

  8. The Options step contains a number of important settings that influence the import:

  9. WooCommerce Variable Products Import Options
    WooCommerce Variable Products Import Options

    1. Multiple value delimiter.
    2. In our file, multiple attribute values are written within one cell and detached by a pipe line delimiter. So we set this character as a multiple value separator here.

    3. Identify existing variations.
    4. In order to create variations in the course of WooCommerce import, you have to identify them. Choose either ID (for existing combination update only), SKU or parent.

    5. What do we do with existing attributes.
    6. If you import products with variations that already exist at your store, you can either recreate variations for them or add new variations without removing current ones (select an appropriate option from the dropdown).

    Once the settings are configured, click 'Import'. Check the import outcome on the last wizard page. Now let's check the variations in Store Manager.


    WImported WooCommerce Variable Product in Store Manager
    Imported WooCommerce Variable Product in Store Manager

    WooCommerce variations have been created, they now display in the lower grid.

    Use Store Manager for WooCommerce to Import Variations

    Get It Now

    < div class="row">
COMMENTS
Deborah Holmes
Deborah Holmes • 10/31/2019

When using your product to create "new" products with "variations" how does WooCommerce assign the Variation ID? I have existing products with assigned variation IDs by WooCommerce, so how does your import product know where to start picking up the variation ID number?
I see how you import to create the new product but I do not see how the variation IDs are assigned to the variable products. One of our products has in excess of 800 variations.
Please advise.

WooCommerce Store ManagerMod Deborah Holmes • 11/01/2019

Hello, Deborah!
Thank you for your question.
The variations IDs are being generated same as in the Admin Panel, that is, variations and products share the same IDs pool. When variations are being created specifically during product import - then firstly, Store Manager creates main products (with corresponding incremented IDs), then it adds variations (with corresponding incremented IDs).