File PrefixPRODUCT-VARIANTS
Current VersionV2

Product variants express the variations a given product can be available in.

Every product has to have at least one or more variant defined
AttributeFormatLengthRequiredDescriptionExample
product_refAlphanumeric1-255YesUnique product reference descriptor103495
skuAlphanumeric1-255YesSKU of product variantB01N53LF
barcodeAlphanumeric1-255NoBarcode (UPC, EAN, ISBN, etc.)03600291452
option_1_nameAlphanumeric1-255No1st variationColor
option_1_valueAlphanumeric1-255NoValue for that skuGreen
option_2_nameAlphanumeric1-255No2nd variationSize
option_2_valueAlphanumeric1-255NoValue for that sku42.5
option_3_nameAlphanumeric1-255No3nd variationMaterial
option_3_valueAlphanumeric1-255NoValue for that skuGold
language_codeISO 639-1 Must belong to our supported languages2ConditionallyLanguage used in options and values. Must be present if options and values are specifieden
store_refsAlphanumeric ; separated list.1-255NoProduct only exists for these stores. If omitted, available to all storesB32;C85
publishedBoolean [TRUE|FALSE]YesDetermine if the variant should be shown or searchable in the collection view. If not published it will be hidden but can still be attached to a saleTRUE
sku is unique and case insensitive (e.g. B01N53LF is considered the same as b01n53Lf)

​
Notes

option_x_name can be used to split product in the collection view via a company wide configuration. For example, Color could be selected, so that each color variant of a given product would show as a top level image in the collection view.

If a product does not have multiple variants, for example a shoe cleaning kit, a variant should be created with no options.

​
Example

Here are some example of common options for variants for different product types:

Option 1Option 2Option 3
ApparelColorSize
ShoesColorSizeWidth
JewelryMaterialSize

​
Localization

To localize option names and values, multiple rows can be sent for a given product_ref and sku combination with a different language_code.

Example:

product_ref,sku,barcode,option_1_name,option_1_value,option_2_name,option_2_value,option_3_name,option_3_value,language_code,store_ids,published
103495,B01N53LF,03600291452,Color,Green,Size,11,,,en,B32;C85,TRUE
103495,B01N53LF,03600291452,Couleur,Vert,Taille,42.5,,,fr,B32;C85,TRUE

​
Editing and deleting options

Imported options (option_1_value, option_2_value and option_3_value) replace the current options. For example:

  1. A variant as an option named color with the value green
  2. A file for this variant is imported with option_1_name: color and option_1_value: red
  3. Now this variant as the option named color with the value red (option green as been removed from this variant)

Imported options (option_1_name, option_2_name and option_3_name) with blank corresponding values will delete current options. For example:

  1. A variant as an option named color with the value green
  2. A file for this variant is imported with option_1_name: color and option_1_value: ""
  3. Now this variant don’t have color options anymore