Import Variants & Options

To import product variants and options in Shopware 6, use the options column in your import file. This column requires values in a specific format that combines the property name and option value.

The basic format for the options column is:

propertyName:optionName

For example, to specify a green color variant, use:

Color:Green

For products with multiple properties, combine them using the pipe symbol (|):

Color:Green|Size:M

When your Shopware installation has multiple properties with the same name (such as two different “Size” properties—one for clothing sizes S/M/L and another for shoe sizes 36/37/38), you can use the property’s UUID to ensure correct referencing:

0195051215d37270967fafd07e1fd2d8:S

or

019508a9d8fe71f8a2dfe601f2452dab:36

Our app automatically recognizes and associates variants with their respective properties, whether you use property names or UUIDs.

Examples

Example 1 — UUID-based options

productName	parentSku	options
CONF001.1	CONF001	0195051215d37270967fafd07e1fd2d8:S
CONF001.2	CONF001	0195051215d37270967fafd07e1fd2d8:M

Example 2 — Name-based options

productName	parentSku	options
CONF001.1	CONF001	Size:S
CONF001.2	CONF001	Size:M

Example 3 — Multiple properties by name

productName	parentSku	options
CONF001.1	CONF001	Size:S|Color:Green
CONF001.2	CONF001	Size:M|Color:Green

Example 4 — Multiple properties by UUID

productName	parentSku	options
CONF001.1	CONF001	0195051215d37270967fafd07e1fd2d8:S|0194d1146ee27d56b079806d3bcc7997:Green
CONF001.2	CONF001	0195051215d37270967fafd07e1fd2d8:M|0194d1146ee27d56b079806d3bcc7997:Green