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


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. 

Importexport

Upload file

  • Click the Import button in the upper right corner. 

Import

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

File limitation: Maximum 100 000 records (products), 500 columns (attributes, relations, categories, assets, etc.), 500MB (file size). 

  • 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. 

Tip! Save time while doing regular imports by using saved mappings.

    • 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.

Import_View_Before-You-Go-Map-Data

Note: Importing product information can change many products. Please be careful to review the mapping manually before moving on. Auto-mapping feature will suggest mapping the data but has some limitations. 



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.

Import_Map-Data_Select-Save-Mapping-and-Context

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

Import_Map-Data_Error-Message

Data Mapping Types

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

Import_Map-Data_All-types

  • 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.

Note: Import a new category required to be checked Allow creating new categories on an upload file page before mapping data in the import file.

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

Note: Allow you to map with the Single product type. Once imported successfully, the product type will change to Variant and automatically be added to the Variant Group.

  • 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.

Import_Data-Map-Types_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.

Note:  Import of a two-way relation will have separate columns for each direction.



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_Reviews-Data

Tip! You can go back to edit mapping data by clicking on Change mapping or Discard to cancel the import.


Import summary

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

Import_Import-Summary_Import-Completed

  • 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.

Import_Import-Summary_Import-With-Issue_Incompleted

 

Find out how to export product information here.

Back to top