How to import products
Learn how to import products from beginning to end
Last updated
Learn how to import products from beginning to end
Last updated
A prerequisite to importing any entities is having an excel spreadsheet with the data organized in named columns. For this tutorial we have a made a simple spreadsheet containing information about clothing.
To start importing you choose the excel spreadsheet with the data you want to import, in this tutorial the spreadsheet is called "ClothingForImport.xlsx".
While it is possible to include media assets when importing, this will not be covered in this guide. For this reason we leave 'Include media' unticked and 'Select media folder' empty.
Having chosen the correct file and import type you can click the "Upload"-button to start the import.
Having clicked the "Upload"-button you are presented with a new page. This is where you will map your excel columns to data fields on entities.
Having chosen one or more keys you can click "Next" in the right-bottom corner.
Click the "Next"-button in the right-bottom corner to continue.
Having reviewed the changes you can choose to approve the changes you are satisfied with. Only approved records will be commited.
When you have approved the records you want to keep, click the "Commit Import"-button in the bottom-right corner to finalize the import.
Next you need to choose the correct Import type. When importing , , variant groups or the 'General Excel Import' type is used.
You will need to choose the correct Entity type; , , Variant groups or values.
In this guide we are importing , so we choose 'Products' in the 'Entity type' dropdown, but the process for all entities are almost entirely similar from here.
Next is mapping the actual data. The import function will try to automap the data from the file by matching the name of the excel column to the name of an in the PIM.
This is not always possible or what you want, in which case you can manually select the correct to map to in the 'Select field' dropdown in the 'Map to' column.
Having finished the mapping, you need to choose one or more keys. These key(s) will act as keys to match existing entities in the system. If the key(s) match a in the system, that will be updated with the data from the excel spreadsheet.
If the key does not exist, a new with the data from the excel spreadsheet will be created.
As mentioned in the last section, if a key does not already exist in the PIM, a new will be created. If the excel spreadsheet contains new you will be prompted to choose a to use for the new .
In this guide we are importing clothing, so the 'Clothing' is chosen.
At this point you are shown a 'Review changes'-page. This page will show you the amount of new and updated items. New items will be denoted by having a blue 'New'-tag in the key column whereas existing will show their current value.
that will be changed are colored green to easily distinguish between that will remain the same and that will change.