When you import a file, Commerce Cloud validates the file, first verifying that the file is formatted correctly and contains data that can be imported, then validating the first 200 items in the spreadsheet. If you receive errors or warnings prior to the actual import, you can stop the task, edit the spreadsheet to remove any errors, and then upload the file again.
After executing the validation phases and importing the spreadsheet, Commerce Cloud displays the outcome of the import in a results dialog box.
File validation
When you select a file for import, Commerce Cloud validates the file format and the formats of the first two rows of the spreadsheet. If there is an error in the file, a message appears on the Import dialog.
Errors that can occur during this phase include the following:
The file is not in CSV format.
The repository or item type in the first column of row 1 is not valid.
The file is missing the
IDcolumn or it is not the first column.Row 2 of the file contains properties that do not exist for this item type or have a misspelled property name.
The file contains properties that are not allowed.
Note: Commerce Cloud does not export these types of properties, so if the spreadsheet contains them, they were added to it manually and should be removed.
The file contains a timestamp or a date property but does not have a corresponding
TIMESTAMPorDATEformat in row 1.
Item validation
After the file is uploaded and passes file validation, Commerce Cloud validates all items and displays the outcome in the Import window. You can also download a full validation report.
The validation process determines how many imported items have changed, how many are new, and how many are unchanged.
Errors or warnings that can occur during item validation include:
The value in the spreadsheet cannot be converted to the correct type for a property, for example, a date does not include two digits for the month, or a letter or symbol appears in a numeric property.
A value for a required property is missing.
A repository ID in a property value cannot be found.
If the unknown ID is for the same type of item that is being imported, the message is a warning because the item might be created elsewhere in the spreadsheet. If it is a different item type, the message is an error.
Note: If the ID column contains a non-existent repository ID, a new item is created with that ID. See Format for adding new items.
