Import product information

You can create new and update existing products via import if you have the System Admin, PIM Write, or PIM Admin role. You can use Excel or CSV files.

Upload file      Map data      Review      Import summary      Save mapping

General

Import supports attributes, media, relations, categories, variants, and bundles. 

• Click the Import and export icon in the main navigation bar to get an overview of already executed import and export jobs. 

Upload file

• Click the Import button in the upper right corner. 

• Browse to find your CSV or XLSX file, or drag and drop it.

• You can import with some options: 
  • Context - select which context/language to import data. Learn how to configure context and languages. 
  • Mapping - select a saved mapping to map columns automatically, or create a new mapping. 

• • Header rows - add a value to the rows, which will be the column headers in the mapping tool.
    • Auto-detect – let the import service auto-detect what row to use
    • Headerless
    • 1st row as header
    • Custom – choose to identify how many rows to skip when importing data.
  • Allow creating new attribute definitions - when the option is selected, new attribute definitions are allowed to be created during import. 
  • Allow creating attribute definition values - when the option is selected, new values are allowed to be automatically added to lists of options for attribute definitions supporting multiple values (single select, multi-select, and dictionary)
  • Allow creating new categories - when the option is selected, new categories are allowed to be imported. 
• Before you can start mapping the data, you will be asked to confirm that you understand the potential risk of importing product information.

Map data

The uploaded file is processed. The column auto-mapped if the column header matches an existing attribute name or standard product field (e.g. Number, Name. and Description column).

• You can select an existing save mapping and change the context from here.

• An error message will be displayed if the import detects missing information.

Data Mapping Types

The supported data fields from the import file are described here.

• Name - Mapped the columns to the product name.
• Number - Mapped the columns to the product number.
  • The product number exists in PIM, it will update the product from the import file's data.
  • The product number does not exist in PIM, it will create a new product from the import file's data.

• Description - Mapped the columns to the product description.
• Category - Map the columns to catalogs and categories.

• • The checkbox to Column contains multiple category levels. 
  • The category level separator is divided by an angled bracket (>) to split the value if there are multiple category levels. Each category (full path) is separated by a semicolon (;),
  • Select the Unique identifier to import the category by Name or Number.
  • Click Apply button.

• Bundle - Mapped the columns with a new or existing product number.
• Variant - Mapped the columns with a new or existing product number.

• Assets - Mapped the original file name of the image from the Assets.
• Relation - Mapped the column with a new or existing product number to one-way and two-way relations.

• • The product separator is divided by a semicolon (;). The checkbox to Column contains multiple products to split the value if there are various products.
  • Checkbox to Create new, then enter a relation name to create a new relation.

Review

This page reviews the overall import data from the selected file to ensure that the data is correct before clicking on the Start import button.

Import summary

When the import is finished, this page shows a summary of what has been imported. 

• If there were some issues detected during the import process, relevant records can be viewed by clicking Download CSV or Download XLSX depending on the format of the import file.

Find out how to export product information here.

Back to top