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:
<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>
<IMPORT-DIRECTORY>:

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

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:
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

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.

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",",,"