This article only covers how to arrange configurable products and variations in an imported CSV file. Your file may include more columns such as Quantity, Price, etc.
The Product type column isn’t required, but is convenient, because it helps to see the type of the product:
P—a simple product.
C—a configurable product.
V—a variation of the configurable product.
The imported CSV file must always have the entry of the configurable product when you create the variations of that product.
The relative order of entries in the file is important: the entry of a configurable product goes first, and the entries of its variations must come right after it, in the following lines. For example, sequence СVVPCVVVPP is correct, and sequence CVVPVVCPV isn’t.
As usual, the values in the Product code column serve to distinguish new products and variations from existing ones during import. So, if a product or a variation with the specified code is found in the store, the import will overwrite it.
- The configurable product doesn’t exist yet and will be created during import.
- The configurable product already exists but doesn’t have options and any variations yet.
Each variation you’d like to create must have a value specified in the Variation options column. This column contains the information about the option variants that comprise this variation. There are several rules to remember:
- Only variations should have variation options specified.
- The Variation options field must include only the options and variants that the configurable product has.
- Two different variations of a single configurable product can’t have the same variation options.