Excel import - Relations does not create or update new relations.
This import connects products to existing relations.
If a product has more than one relation in the Excel file it need to be separated on a new line.
Column A (ProductNo) = the product that will get the relation name.
Column C (RelatedProductNo) = the product that will be attached to the product in column A.
Example with Column A: In the example i have used the relation "Similar products"
Example with Column C: Entering the attached product, this is how the attached product appear in feed:
Important:
It is important to know the difference between the two when doing this import.
If you want to connect accessories, spare parts, similar products or something else to a product, and you have integrations active on displaying these relations, you need to know what column to use for the main product (A) and what to use for the related product (C).
Count is only used for relations that has Count enabled on the relation in basic data.
SortNo is used if you want the related products to have a specified sorting.