Search our Help.

Troubleshooting Import Errors

Follow

Troubleshooting Import Errors 

The table details some of the common data import errors and the recommended action.

Error Recommended Action

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.
Was this article helpful?
0 out of 0 found this helpful