Import template for product variants
Key features
- Create or change product variants via import
- Connect products into a variant group by a shared group key
- Set collapsed state and a main product for a group
- Translate variant values into other languages with the
Languagecolumn
Quick guide
- Go to the Import Tool in the menu and click New.
- In the Template Type dropdown, select Variant.
- Click Download File Template.
This requires that you have existing variant types configured. Use the template to create or change variants, then upload your file to apply the changes.

A description of the columns follows. There is also a short description in Merchant Center under View template description.
| Column | Description |
|---|---|
| ProductId | Id of the product. |
| GroupKey | Unique identifier for the group. Can be text or numbers. Products with the same key are connected to the same variant group. A product can only be part of one group; if a product already exists in a group and you specify a different key, it is removed from the first group. Located under group settings in the variants tab in Merchant Center on existing groups. |
| Dimensions | The variation dimension names. A comma-separated list of the dimensions for the variant group (example: color,material). Only matches existing dimensions in a variant group; cannot add new dimensions to an existing group. All dimensions in the group must be specified. |
| Values | The variant dimension values. A comma-separated list of the dimension values for this variant, in the same order as the dimensions (example: red,wood). |
| Collapsed | Value: True / False. True sets the variation group as collapsed if applied to any product in the group. False removes the collapsed state, so all products in the group show in product lists. Requires a value in GroupKey. |
| MainProduct | Value: True. Sets the product as the main product if the group is collapsed. Overrides an existing main product. Requires a value in GroupKey. |
| Remove | Value: Remove. If set, the product is removed as a variation. Requires a value in GroupKey. |
| Language | Optional. A two-letter language code, for example sv, en or fi. Leave it empty, or use your default language, and the row works as described above. In any other language, the row saves translations of the values. See Translate variant values. |
Translate variant values
A row with a Language other than your default language saves translations of the product's variant values. It doesn't change the default values or the group settings.
On a translation row:
- ProductId, GroupKey, Dimensions and Values are required.
- The product must already be in the variant group with that GroupKey.
- Dimensions must list all of the product's dimensions in the group, and no others.
- Values holds the translations, in the same order as Dimensions.
- An empty entry in Values leaves the translation of that dimension unchanged. For example,
Röd,updates the first dimension and leaves the second as it is. - MainProduct, Collapsed and Remove must be empty.
The import tool saves rows in file order. To create a variant and its translations in one file, put the row in your default language first, then one row per language:
| ProductId | GroupKey | Dimensions | Values | Language |
|---|---|---|---|---|
| 1001 | shirt1 | Color,Size | Red,Small | |
| 1001 | shirt1 | Color,Size | Röd,Liten | sv |
| 1001 | shirt1 | Color,Size | Punainen,Pieni | fi |
A value translation belongs to one product. If several products share the value "Red", add a translation row for each product.
Content in LocalizedValues through the Management API.To translate dimension names, such as "Color" to "Färg", use the import template for variant dimension translations.