Skip to main content

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.