WooCommerce Import Variable Products Tutorial

If your WooCommerce store sells variable products, you came across the right post. Here we are going to discuss how to bypass monotonous, time-consuming one by one variation configuring and fulfill WooCommerce import variable products.

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

Store Manager for WooCommerce delivers approachable import tool, that allows to create or update product variations in quick way. This tutorial provides you detailed instructions on how Store Manager arranges import, what points should be considered and, of course, illustrates WooCommerce import variable products through screenshots.

WooCommerce Import Variable Products: Sample File

First and foremost, you should get ready with the file, WooCommerce variations will be imported from. What file structure pattern is required? Let’s have a look at sample file, we use for WooCommerce import of variable products.

What fields should the file contain and how should they be arranged for variations to be created and linked to necessary parent product?

  1. SKU (or ID for update only) - this column stands for product SKU. You have to identify products in the process of WooCommerce import variable products. Input SKU for parent product and each variation you are going to create.
  2. Product type - differentiate main item and associated ones specifying 'variable' or 'variation' correspondingly for each record in the file.
  3. Post status - to get variable product and its selections displayed at the storefront, provide 'publish' status for each.
  4. Stock status - insert either 'In Stock' or 'Out of stock' for each item.
  5. Manage stock - enable or disable quantity tracking for your variable product.
  6. Attribute name - your WooCommerce variations depend on some product characteristics called attributes. In separate rows of this file column you should specify attributes used to create WooCommerce variations.
  7. We need to create associated items varying in color and size. These attributes are specified actually for parent product within separate rows in 'Attribute name' column.
  8. Attribute values - this column lists all the values of specific attribute that will be used for WooCommerce import variable product carrying out.

  9. Size/Color - these two columns contain all the combinations of attribute values that will represent selections for customers at the storefront. Each combination=separate row in WooCommerce import variable product file = product variation.
  10. Regular Price - you can set price for WooCommerce variations providing values for them in this field of your import file.
  11. Stock - indicate how many items of each associated product in stock you have.
  12. Parent - to link simple products to main one, you should create relations. Specify parent product SKU for each associated simple item in the file.

WooCommerce Import Variable Products Performance

WooCommerce variation upload is fulfilled by means of product Import Wizard and embraces several steps, enumerated further.

  1. Launch the Wizard (either from toolbar or from product context menu).

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

  3. Specify what file will be used for WooCommerce import variable products selecting the one stored locally, providing HTTP or FTP URL to it in the Import Wizard.

  4. Set up your import file delimiters, since these are necessary for data parsing and fortunate import accomplishing.

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

  6. WooCommerce import variable products expects you to associate data you have in the file with suitable database fields. This correspondence is required for product import.

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

  8. Options step of the Import Wizard expects you to determine settings that influence WooCommerce import variable products procedure.

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

    1. Multiple value delimiter should be specified.
    2. You have multiple attributes and values within one cell in the import file. They are detached by certain delimiter. Set this character as multiple value separator here.

    3. Identify existing variations by this column -
    4. in order to create variations in the process 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, but these already exist at your store, you can either recreate variations for them or add new variations without removing current ones selecting appropriate option from the dropdown.

    Once the settings are configured click 'Import' button to start variable product creation. Check import outcomes on the last wizard page. Afterwards see whether variations display 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 product lower grid as we have configured in the import file.

    Use Store Manager for WooCommerce to Import Variations

    Get It Now

    < div class="row">
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).