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:
The CSV appears to be corrupt near record 'XXX' field 'XXX at position 'XXX'.
This error normally appears before you have run the import and while you are attempting to upload the CSV file in the import configuration. Please check your file is a correctly saved CSV file that is already saved as a CSV not converted from Google Sheets or Excel. Also, check that you are using Unicode (UTF-8) character set and that your file does not contain any foreign characters. More details and examples are available here.
Executing Import queries. Duplicated rows have been found in your file, when updating XXX.
This error refers to your file containing duplicate entries in a column that does not allow it (e.g. two of the same SKU, Variation Group Name is identical for two different Variation Parents, etc) or the SKU/Linking/etc you are attempting to add with the import already exist in your system (e.g. Stock Item Linking for the given Channel SKU, Source and SubSource already exists to a different Linnworks SKU). Double-check all values and entries, remove duplicate and retry the import.
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.
OR
- 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.
- This can also indicate that a previous import has been done incorrectly, so a SKU has already been added as a Variation parent SKU when it should not be. Please see here for details on how to identify and eliminate such SKUs.
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 the allowed amount for the values. For example, no more than 2000 characters are allowed in the value of extended properties.