Import Templates

Import template for related products

To create relations between products, ensure you have existing relation types configured.
  • Go to the Import Tool in the menu and click New.
  • In the ** Template Typedropdown, select ** RelatedProducts.
  • Click ** Download File Template** to get the import template.

Use the template to add relations and upload your file to apply the changes.

Below follows a description of existing columns. (There's also a short description in Merchant Center under View template description)

ColumnDescription
ProductIdId of the product.
ProductNameName of the product. Name is used to find first matching product Id if Id is not specified (use ID for performance)
TypeName of the relation type. Must match the name of an existing relation type.
Related1Product Id of the product to relate
Related2Product Id of the product to relate
Related3Product Id of the product to relate
Related4Product Id of the product to relate
Related5Product Id of the product to relate
Related6Product Id of the product to relate
RelatedCSVAdditional relations. Comma separated values, Id's of related products. No quantity limit. Can also be used solely, instead of related colums Related1-6 above,
RemoveIf value "Remove" is added and: Without IDs in any of the related columns: All related products for the specified relation type will be removed from the product. With IDs in any of the related columns: Only the specified product(s) in those columns will be removed from the relation.