To see if any errors were reported during the import process, please check the Import Logs. If something went wrong there will be a message which you can double-click to view.
Here are some examples of the error messages and their explanations:
"There are some errors related to the file format. Please go to view log and download the imported file to see the errors."
Click 'Download' to check the errors - they will be in the last column of the import. Usually, it is indicated for each SKU what is not right in this particular row. For example, the error will be received if there is an incorrect value in a specific field - a column that expects a numeric value (Stock Level, Price etc) would have alphabetic characters or other symbols ($, £, GBP, etc)
"Building internal table. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column."
The error message most likely means that some values in the columns are not in the right format. Please check the article on CSV files to see some potential issues, or contact technical support and provide them with the file to review.
"Executing Preimport queries. Violation of PRIMARY KEY constraint 'PK_StockItems'. Cannot insert duplicate key in object 'dbo.StockItems'. The duplicate key value is (1f01d55e-9196-4d48-af25-3e8d08fc93ae). The statement has been terminated."
The error message means that you are trying to import duplicate values. Please check your file to find SKU that comes up more than once in your file and remove all duplicate lines from it.
"Executing PostImport queries. Violation of UNIQUE KEY constraint 'UQ__Variatio__FXXXXXXXXXXX'. Cannot insert duplicate key in
object 'dbo.VariationItem'. The duplicate key value is (XXX VARIATION SKU NAME XXXXX).
The statement has been terminated."
This error can be returned in 2 cases:
- there is a repeating Variation Group name in the file. Variation group name has to be unique as well as Variation SKU.
- a SKU you are trying to import as a Variation Parent already exists in your Inventory as a Single Stock Item. The system cannot change the status of a normal stock item to a variation parent. You will have to delete this SKU from your Inventory and then try re-importing the file again.
"Building internal table. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated."
The error usually indicates that the file is too large, it exhausts the system and it is not able to accomplish the task within the set time frame. This causes the import to time out. Please try to divide the file into smaller parts and import it again.
Software like File Splitter can help you divide your file into smaller parts.
"Executing Pre import queries. String or binary data would be truncated. The statement has been terminated."
The error usually indicates that the limit of allowed characters in the cell is exceeded. Please make sure that the number of characters in not exceeding allowed amount for the values. For example, no more than 2000 characters are allowed in the value of extended properties.