Product links

Pacemaker Community Edition (CE) provides the functionality to import product links as well as their positions. _related_, _upsell_, and _crosssell_ links are supported.

As Pacemaker Community Edition (CE) also supports the import of _grouped_ products, which are nothing else than the additional link type super, it is possible to import the position of the products that are linked to a grouped product.

To import this link type, only a comma (,) separated list of the linked products must be specified in the appropriate column

column related_skus for related products that’ll be rendered on the product detail page
column upsell_skus for upsell products that’ll be rendered on the product detail page
column crosssell_skus for cross-sell products that’ll be rendered on the shopping cart
column associated_skus for products that will be part of a grouped product, which will also be rendered on the product detail page

As example, the columns to import those link types may look like this

sku … related_skus upsell_skus crosssell_skus associated_skus …

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`

24-MB01

24-MB02,24-MB03

24-WG03,24-WG04

24-SB01,24-SB02

24-AS01,24-AS02

Link Positions

Besides the SKUs of the linked product itself, it is also possible to specify the related products

sku … related_position upsell_position crosssell_position associated_position …

sku	…	related_position	upsell_position	crosssell_position	associated_position	…
`24-MB01`		`1,2`	`2,1`		`1,2`

24-MB01

1,2

2,1

1,2

The position also has to be a comma (,) separated list, but it contains numbers instead of the SKUs. The numbers finally are the position the linked product will be rendered in the GUI.

Please be aware that the positions are not mandatory, and the columns can be empty. If so, the Pacemaker Community Edition (CE) creates the place itself, based on the order of the given SKUs.

If positions are changed in the Magento backend, they will be overwritten within the next import process.

Magento 2 CE < 2.1.6

Magento 2 CE supports positions for product links, as well as Magento 2 EE. By default, up to version 2.1.6, importing product positions is not possible in the CE, because of the database of the CE lacks missing rows in the catalog_product_link_attribute table.

In case that the rows are not available, the positions, defined in the CSV file’s columns are ignored.

related_position
crosssell_position
upsell_position

To enable importing positions, add the following rows the Magento 2 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');

Make sure that the values are not already available before adding them.

Product links

Link Positions

Magento 2 CE < 2.1.6

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