Product Variants

Pacemaker Import Pro provides the command import:products:variant command for the product variant import.

The individual parts of the file name must match the pattern as followed:

Example: product-import-variant_20190608-114344_01.csv

<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>

<IMPORT-DIRECTORY>:

is by default the location of your working directory <ROOT-DIRECTORY>/var/pacemaker/import/

The var/pacemaker/import directory is not created after the installation by default
- see described instruction how to create the import directory

PREFIX:

The <PREFIX> of the import filename represents the product-import-variant area.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the import filename between <PREFIX> and <FILENAME> is a underscore ( _ ).

FILENAME:

The filename is a autogenerated combination of date and time.

As a result, the filename look like product-import-variant_20190608-114344_01.csv.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the structured filename between <FILENAME> and <COUNTER> is underscore ( _ ).

COUNTER:

is a incremental number with two digits starting with 01.

SUFFIX (filename extension):

The Pacemaker Import Pro uses the <SUFFIX> .csv as default for the import files.

.OK file:

In addition, the appropriate .ok file is needed (see cli import commands).

Bunch import:

The Bunch import requires the same predefined filename structure as described.

Your CSV file var/pacemaker/import/product-import-variant_20190608-114344_01.csv is now ready for import.

Columns

Pacemaker Import Community offers the possibility to import variant products, including their options like variant_price_type etc.

The CSV file with the attributes for Magento 2 CE/EE consists of the following columns

Column Name Type Example Description

Column Name	Type	Example	Description
sku	`varchar`	`WS11`	Product SKU to import the links
product_type	`varchar`	`configurable`	Magento Product Types
attribute_set_code	`varchar`	`Top`	Magento Attribute set code
configurable_variations	`varchar`	`sku=WS11-XS-Green,size=XS\|sku=WS11-XS-Orange,size=XS\|sku=WS11-XS-Yellow,size=XS`	Pipe ( `\|` ) separated list of configurable variations
configurable_variation_labels	`varchar`	``	configurable variation labels

sku

varchar

WS11

Product SKU to import the links

product_type

varchar

configurable

Magento Product Types

attribute_set_code

varchar

Top

Magento Attribute set code

configurable_variations

varchar

sku=WS11-XS-Green,size=XS|sku=WS11-XS-Orange,size=XS|sku=WS11-XS-Yellow,size=XS

Pipe ( | ) separated list of configurable variations

configurable_variation_labels

varchar

configurable variation labels

Product variant get imported also with the entire product import as default.
The Product must exist in the case

Example: product-import-variant_20161021-161909_01.csv

sku,product_type,attribute_set_code,configurable_variations,configurable_variation_labels
WS11,"configurable","Top","sku=WS11-XS-Green,size=XS|sku=WS11-XS-Orange,size=XS|sku=WS11-XS-Yellow,size=XS|sku=WS11-S-Green,size=S|sku=WS11-S-Orange,size=S|sku=WS11-S-Yellow,size=S|sku=WS11-M-Green,size=M|sku=WS11-M-Orange,size=M|sku=WS11-M-Yellow,size=M|sku=WS11-L-Green,size=L|sku=WS11-L-Orange,size=L|sku=WS11-L-Yellow,size=L|sku=WS11-XL-Green,size=XL|sku=WS11-XL-Orange,size=XL|sku=WS11-XL-Yellow,size=XL",

Product Variants

Columns

WIR HÄTTEN IHNEN DIESE MELDUNG AUCH GERNE ERSPART ...