Product import allows you to add related products to your store via an import file. The feature uses so-called product relationship lists, where you specify related products on a specific product.
In this guide, we'll walk you through how to create an import template for relationship lists and how to import related products to your products.
Step 1 – Create a template for product relation lists
Before you can import related products, you need to create a product relation list template.
Go to Catalogue → Import
Open the tab Templates for related products
Click Add new template
Enter:
1. Name of the relation list (for example "Similar products")
2. Visibility settingsClick Create list
The template is used to tell the system which relation list the import should update.
Step 2 – Prepare your import file
Related products are specified in the import file using product numbers separated by commas.
Important to keep in mind:
The product number for the main product must be on the same row
The related products are specified using product numbers separated by commas
Example:
In this example, the products with product numbers T-SHIRT-002, T-SHIRT-003 and T-SHIRT-004 will be added as related products to T-SHIRT-001.
Step 3 – Upload your import file
You can now import related products.
Go to Catalogue → Import
Upload your import file
Make sure that "Automatic" is selected for both "Fields separated by" and "Character encoding", and that "Update information" is selected under "If the product already exists in the catalog".
Step 4 – Map the columns in the import
For the system to know what information is contained in each column, you need to map the columns to the correct properties.
Since the import file has clear column headers, this is easy to do.
For example, you need to specify:
the column containing the product number for the main product
the column containing related products – here you select the name of the template you created earlier, for example "Similar products"
In this example, the first row of each column in the import file contains headers. We do not want to import these, so we check "First row contains column headers".
Here we have selected the column content for each column in our import file: Product number, Product name (sv) and Related products → Similar products.
Step 5 – Start the import
Once the columns are mapped, click Start import.
The system will now create or update the product relation list depending on whether this list already exists on the product or not.
Result after the import
When the import is complete, you can check the result by:
Opening a product
Going to Related products
Here you will see that the relation list has been created and is linked to the template used for the import.
In this example, we import only one list of related products, but it is possible to import multiple product relation lists for the same product. In that case, simply add another column for related products (for example "Matching accessories") and make sure to create a corresponding import template before uploading the import file.
It is only possible to import related products to relation lists that are linked to an import template. Lists that were created manually cannot be updated via import.
Here we can see that the product relation list "Similar products" has been created after the import.
The list can be edited manually afterwards by clicking the name or the "edit" icon on the previous page.
Important to know about importing related products
When importing product relation lists, the following applies:
The products in the existing list will be replaced by those specified in the import file.
If the column for related products is left empty for a product in the import file, the entire product relation list will be removed from the product (if there is already a relation list linked to this import template).