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".
Next you need to choose the correct Import type. When importing categories, products, variants, variant groups or global lists the 'General Excel Import' type is used.
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.
You will need to choose the correct Entity type; Categories, Products, Variants, Variant groups or Global list values.
In this guide we are importing products, 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 attribute in the PIM.
This is not always possible or what you want, in which case you can manually select the correct attribute 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 product in the system, that product will be updated with the data from the excel spreadsheet.
If the key does not exist, a new product with the data from the excel spreadsheet will be created.
If you know you will be using this mapping often, you can save it by clicking 'Save mapping' and giving it a name. This way you can always load your mapping again when using a similar excel spreadsheet.
Having chosen one or more keys you can click "Next" in the right-bottom corner.
As mentioned in the last section, if a key does not already exist in the PIM, a new product will be created. If the excel spreadsheet contains new products you will be prompted to choose a Product structure to use for the new products.
In this guide we are importing clothing, so the 'Clothing' product structure is chosen.
Click the "Next"-button in the right-bottom corner to continue.
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 products will show their current value.
Attributes that will be changed are colored green to easily distinguish between attributes that will remain the same and attributes that will change.
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.
