Product Links

Pacemaker Import Pro provides the command import:products:link command for the product link 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-link 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-link_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-link_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 links

related_skus

varchar

24-MB05,24-MB03,24-MB04

Comma ( , ) separated list of related skus

related_position

int

2,3,1

Comma ( , ) separated list of related skus position

crosssell_skus

varchar

24-WB05,24-WB02,24-WB01

Comma ( , ) separated list of crossell skus

crosssell_position

varchar

3,2,1

Comma ( , ) separated list of crossell skus position

upsell_skus

varchar

24-UB02,24-MB02,24-MB06

Comma ( , ) separated list of upsell skus

upsell_position

varchar

1,2,3

Comma ( , ) separated list of upsell skus position

  • Product links get imported also with the entire product import as default.

  • The Product must exist in the case

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