Common import errors often arise from file structure issues, such as improperly defined headers or duplicate rows in the data file. The following table details the common data import errors that can occur and the recommended action to resolve them.
Error or symptom | Recommended action |
Import is taking a long time | We recommend a limit of 1000 rows per imported file. If more than 1000 rows are populated in the import template, break the file into subsets of 1000 rows each, uploading them one at a time. |
Duplicate “[Product,Customer,Supplier]” codes | Update the duplicate values and ensure that they are unique. |
Random Characters in Cell A1 | Delete all random characters in Cell A1 prior to the asterisks (*). |
Duplicate sales order transaction numbers | Update the duplicate values and ensure that they are unique. |
Mandatory fields missing | Mandatory fields displayed with a * must have a value. |
Date value formatting | Ensure the dates are formatted as dd/mm/yyyy. |
The default template column headers are changed or deleted | The template columns cannot be changed or deleted. Compare to the templates provided within Unleashed |
Data formatting (i.e; Excel converts long numbers to scientific category) | Ensure you change your data formatting to text format only. |
Product group name cannot contain commas | Remove any commas from your product group name. |
File format checklist
File structure issues: Ensure your file adheres to Unleashed’s required format, including correctly defined headers and data organization.
CSV header row problems: Check that the first row in your CSV contains only headers with no extra top rows or labels.
Excel file duplicate rows: Remove rows with repeating records to prevent skipping during import.