Product CSV import

Navigation to Product CSV import

Importing product by CSV-file into PIM are for two main reasons:

  • Creating new products in PIM not existing in the ERP-system

  • Enriching existing products in PIM with data fields not mapped to the ERP-system.

Please note, the product ID is a unique identifier - this means you cannot change existing product ID's - either manually nor through import. You can create new ones (manually or by CSV-import) and you can delete existing product ID's (manually). But not change the product ID itself.

Creating an Import file

Easiest way to ensure the file-format is correct (UFT-8) and that a mapping happens automatically upon import, is to export a product with the exact same fields that you wish to import. Remember the product ID be included in the import file.

Altering data on existing product ID's

If the purpose for the import is to alter fields on existing Product ID's, it is recommended to export the existing product ID's with relevant fields - save as CSV UTF-8 - change the data and import. However, any CSV UFT-8-file with any headlines can be used. Mapping just needs to be done upon import.

Export relevant products from PIM, to have correct column headlines, or create your own file - in both cases the format must be CSV UTF-8 and Product ID/sku must be part of the file:

Do the changes necessary (marked in yellow) and save file as CSV UTF-8:

Import CSV UTF-8 file for changes/addition to fields not mapped to ERP-system

Go to Import/export - Product CSV Import - Upload file. Drag and drop your import file in the marked area. Choose type of delimiter if different that semicolon (mostly relevant if you have created your own file). Click Upload.

Import product CSV file - step 1
Import product CSV file - step 2

Unclick fields in column "Include" of not changed in file. Ensure mapping is correct/do mapping. Set delimiter for fields with more than one value (e.g. multiple tags or multiple related items) and mark if any fields empty should action a deletion of current PIM data. Last mark if creations of products are allowed only - or updates only. This helps to ensure that a misspelled product ID/sku doesn't result in a creation of a new product. Click "Import" when ready.

Import product CSV file - step 3

Ensure the below import details - number of products changes, and sample data - matches the expectations before clicking "Confirm import". If not click "Close" and check the file and import-markings again.

Import product CSV file - step 4

Last updated