To check if any errors were reported during the import please check Import Logs. If something went wrong there will be a message which you need to 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."
Select '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 in a value that should be numeric (Stock Level, Price etc) you have alphabetic 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 file to see some potential issues or contact technical support providing a file for them 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 come up more than once in your file and remove all the duplicate values 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 once 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 big, it exhausts the system and it is not able to accomplish the task within the set time frame. This cause the import to timeout. Please try to divide file in smaller parts and import it again.
File Splitter can be used to 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, not more than 2000 is allowed in extended properties.