Product links

Pacemaker Community Edition offers the possibility to import product links and their positions.

The following listed link types are supported:

_related_
_upsell_
_crosssell_

Since Pacemaker Community Edition also supports the import of products with the additional link type _grouped_, it is possible to import the position of products linked to a grouped product.

Import this link type; a comma ( , ) separated list of linked products is specified in the corresponding column:

Column related_skus for:
- Related products displayed on the product details page
column upsell_skus for:
- upsell products displayed on the product detail page
column crosssell_skus for:
- cross-sell products displayed in the shopping cart
column associated_skus for:
- Products that are part of a grouped product are displayed on the product detail page

Table 1. The columns for importing these link types could look like this:
sku	…	related_skus	upsell_skus	crosssell_skus	associated_skus	…
24-MB01		24-MB02,24-MB03	24-WG03,24-WG04	24-SB01,24-SB02	24-AS01,24-AS02

Link Positions

To SKUs of the linked product itself, the position of the related products can also get specified

sku	…	related_skus	upsell_skus	crosssell_skus	associated_skus	…
24-MB01		1,2	2,1		1,2

sku

…

related_skus

upsell_skus

crosssell_skus

associated_skus

…

24-MB01

1,2

2,1

1,2

The position specification must be a comma ( , ) separated list and requires numbers instead of SKUs
The numbers correspond to the position of the linked product, which is then displayed accordingly in the GUI

The positions of the columns are not mandatory; the columns can be empty as well
Is the column empty, Pacemaker Community Edition creates the position itself, based on the specified SKUs order
If the positioning gets changed in the Magento backend, it will be overwritten on the following import operation

Backward compatibility to Magento 2 Community Edition (CE) < 2.1.6

Magento 2 Community Edition (CE) and Magento 2 Enterprise Edition (EE) supports positioning for product links.

By default, until version 2.1.6 the import of product positions in the Magento 2 Community Edition (CE) is not possible, because the database of the Magento 2 Community Edition (CE) is missing rows in the catalog_product_link_attribute table.

If the rows are not present, the import will ignore the items defined in the CSV file columns:

related_position
crosssell_position
upsell_position

To enable importing positions, add the following rows the Magento 2 Community Edition (CE) database:

INSERT INTO
    `catalog_product_link_attribute` (
    `link_type_id`,
    `product_link_attribute_code`,
    `data_type`
)
VALUES
(1,'position','int'),
(4,'position','int'),
(5,'position','int');

The values must not be present before these fields get added

Product links

Link Positions

Backward compatibility to Magento 2 Community Edition (CE) < 2.1.6

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