Update a specific relationship list using product numbers and check the replacement before importing the complete file.
This guide applies to related-product imports under Catalogue → Import. Product import and related products are included in Go, Plus and Pro. Your administrator must have access. The list must be linked to an import template.
Understand what the import replaces
The existing list is replaced by the valid product numbers supplied in the file. An empty cell removes the affected template-linked list. A misspelled or unknown related product number can be skipped; if no valid relationships remain, the list can therefore be removed even when the cell is not visibly empty. Retain the previous contents and check every number before importing.
Create the correct import template
Open Catalogue → Import → Templates for related products.
Select Add new template, give it a clear name such as Similar products and select visibility settings.
Create the list. Reuse the same template when updating that particular list.
Prepare the file
Put the main product number in one column and its complete intended relationship list in another. Separate related product numbers with commas. For example, for T-SHIRT-001 , the relationship cell can contain T-SHIRT-002,T-SHIRT-003,T-SHIRT-004. Each product must exist under the correct number in the same assortment.
Distinguish the file’s column delimiter from commas inside the relationship cell. If columns are also comma-separated, quote the relationship cell correctly. The preview must show the entire list in one cell. A relationship to the main product itself is not added, and repeated relationships do not create multiple copies.
Upload and map the columns
Upload the file under Catalogue → Import, starting with a limited checked selection.
Check the delimiter and encoding. Automatic is suitable when the preview is correct; adjust it if columns or characters are wrong.
Select Update information for existing products.
Map the main number column to Product number and the relationship column to Related products → the import template name.
Select the first-row headers option if applicable. Do not map names, prices or stock unless you intend to change them.
Import and check the result
Start the import, then open an affected product and check Related products: the correct template, products and visibility. Also inspect the storefront product page. Only then extend to the complete intended file. For multiple lists, use a separate column and the correct template for each. A manually created list without a template link is not the import template’s list merely because their names are similar.
Quick start
Retain existing relationships and check every product number.
Create or reuse the correct template.
Map columns and inspect empty or invalid cells.
Import a limited selection and verify the result.
Product import and related products are included in Go, Plus and Pro. You need permission to use product import and the correct template-linked relationship list. An ordinary visible manual list alone is not sufficient for template import.