Last updated

Product relations import and export

Use the product relation export/import flow when you want to update many relations at once, for example when activating, deactivating, or changing relation types in bulk.

Export product relations

Product relation excel format

  1. Open the product list and filter to the products you want to work with.
  2. Select Tools.
  3. Choose "Export relations" to get a timestamped Excel file downloaded, in a pre-defined format. Use the export as your base file before importing changes.

Import product relations

Product relation excel format

To import relation changes:

  1. Go to Integrations > Import.
  2. Select import type Product relations.
  3. Upload your edited Excel file.
  4. Review column mapping in the preview.
  5. Confirm and run the import.

Required and optional columns

See Product relation import columns for details.

Important behavior

  • To remove a relation, set IsActive to false for that relation row.
  • Deleting a row from the Excel file does not remove the relation in Norce.
  • CultureCode is shown in exported files, but the import language is selected in the import UI.
  • Import one language at a time. Do not expect multiple languages in one import run.
  • If you are not updating text fields (Name, Description, and related fields), set them to Ignore in mapping to avoid unintended overwrites.

When to use text fields

The culture-specific text fields are optional and mainly for advanced use cases where relation list text in API responses needs to be overridden. In most imports, these fields are not needed.