Work With Imports

Manage Product Relations with the Import Tool

Create, update, or remove product relations in bulk using the RelatedProducts import template.

Key features

  • Create, update, or remove product relations in bulk
  • Relate products by the Related columns or a comma-separated list
  • Remove all relations of a type, or specific related products

Quick guide

  1. Go to Import Tool > New, choose RelatedProducts, and download the template.
  2. Fill in the product, relation type, and related product Ids.
  3. Upload the file via the import tool to apply the changes.

1. Access the template

  1. Go to Import Tool in the menu and click New.
  2. Choose RelatedProducts from the template type dropdown.
  3. Download the template file to your computer.

2. Complete the template

ColumnDescription
ProductIdThe Id of the main product.
ProductNameInclude the name if you prefer matching by name (Id matching is faster).
TypeThe name of the existing relation type (must match exactly).
Related1 to Related6Up to six product Ids to link.
RelatedCSVFor more than six related Ids, use comma-separated values in this field only.
RemoveAdd the value Remove to remove all or specific relations (see below).

3. Upload and apply

Save your updated file and upload it via the import tool to apply the changes. The relationships are created or updated as specified.

How to remove product relations

You can remove product relations in two ways using the Remove column.

Remove all relations of a specific type:

  1. Fill in the ProductId (or ProductName).
  2. Add the Type of relation to remove.
  3. Set the Remove column to Remove.
  4. Leave the related product columns (Related1 to Related6 or RelatedCSV) empty.

All relations of that type are removed from the product.

Remove specific related products:

  1. Fill in the ProductId (or ProductName).
  2. Add the Type of relation.
  3. Add the Id(s) of the specific related products to remove in Related1 to Related6.
  4. Set the Remove column to Remove.

Only the listed related products are removed from that relation type.

Import products

Create or update products in batches with the product import template, choosing an import mode.

Update inventory stock

Update the inventory balance on products in a batch with the product import.