How do I import variable products?

Products with one are more options are called variable products. Variable products are a product type that lets you offer a set of variations on a product, with control over prices, stock, image and more for each variation. They can be used for a product like a shirt, where you can offer a large, medium and small and in different colors.

There is a sample variable product

Adding variable products with variations

The first row is the parent product and should have the type variable.

You must also give this product a unique to your shop, custom SKU. Example: SHOP-can134

We recommend adding a 3-4 letter abbreviation of your shop name to the beginning or end of all SKUs to insure they are unique to your products.

The second (and subsequent) rows are the individual options and should have the type variation.

You must also give this product a unique to your shop, custom SKU, which we recommend has the format PARENTSKU_VARIANT. Example: SHOP-can134_med

Data for the Variable Product

The following information is included with the parent variable product. Required items are marked with a *:

  • *SKU
  • *Name
  • *Published – set this to -1 (for draft)
  • Short Description
  • Long Description
  • Tags
  • Images
  • Upsells & Cross-sells
  • Minimums, Maximums, Case Size, and Allow Combination
  • Attributes (all options)

When adding attributes for the parent product, be sure to include the attributes that will be used to create the variations.

For example, if your product varies by size use the attribute “Size” with values of “small, medium, large”.

You can also include attributes like theme or style that are not used to create variations but are used to help your products be found in search.

Data for the Variations

The following information is included with each of the variations of the parent variable product. All columns listed below are required to create a variation

  • SKU – unique to the variant and different from the parent
  • Name (recommended “Product Name – Variation”
  • Published – set this to 1 (variations must be 1 even if the parent is -1)
  • Regular Price
  • Meta: sugg_retail_price
  • Parent – this is the SKU of the parent product
  • Attributes

For attributes, you only need to include the attribute that is used to create the variant. If you want to set a specific

If your variations have different prices/weights/quantities/etc depending on the options selected, you will need to specify the value of each attribute used to create the variation.

For example, your candle prices vary by size. Create one parent variable row with the attribute name “Size” and attribute values “small, medium, and large”. Next, create three variation rows, one for each size. For the small variation, the attribute name would be “Size” and value would be “small”.

After you import, the small variation will display the size in your listing editor as “small”. Your buyers will see a dropdown of size options for “Small”, “Medium”, and “Large” on your listing and each will have a different price.

If your variations have the same price/weight/quantity/etc, do not specify the value of the attribute used to create the variation in the variation row. Simply leave the “Attribute Value(s)” column blank.

For example, your card prices do not vary by envelope color. Create one parent variable row with a custom attribute “Envelope Color” and values of “Red, Blue, White”. Next, create one variation row, set the attribute name for the variation to “Envelope Color” and leave the value column blank.

After you import, the variation will display the envelope color in your listing editor as “any envelope color”. Your buyers will see a dropdown of envelope color options for “Red”, “Blue”, and “White”. They will all have the same price.

Was this article helpful?

Didn't find the answer to your question?

Scroll to Top