Product Category

Pacemaker Import Pro provides the command import:products:category command for the product URL rewrite import.

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

Example: product-import-category"_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-category" 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-category"_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-category"_20190608-114344_01.csv is now ready for import.

Columns

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`	`24-MB01`	Product SKU to import the product category relation The SKU should exist, there is no product import. only the relation is imported.
categories	`varchar`	`Default Category/Gear,Default Category/Gear/Bags`	Comma ( `,` ) separated list of categories for product relation to get created The category should exist, if not please import the category first using category import or product import.
categories_position	`varchar`	`base`	Comma ( `,` ) separated list of position for category to get created

sku

varchar

24-MB01

Product SKU to import the product category relation

The SKU should exist, there is no product import. only the relation is imported.

categories

varchar

Default Category/Gear,Default Category/Gear/Bags

Comma ( , ) separated list of categories for product relation to get created

The category should exist, if not please import the category first using category import or product import.

categories_position

varchar

base

Comma ( , ) separated list of position for category to get created

The category relation is also supported in a product import, BUT only in the case of a new category relation and new category, i.e. if the category already exists and the relation does not, no relation is created.
This command is responsible for only creating the relation between products and categories.

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

sku,related_skus,related_position,crosssell_skus,crosssell_position,upsell_skus,upsell_position
24-MB01,"24-MB05,24-MB03,24-MB04","2,3,1","24-WB05,24-WB02,24-WB01","3,2,1","24-UB02,24-MB02,24-MB06",",,"

Product Category

Columns

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