We will guide you through the main errors that may occur when registering Sales Orders using the Import sales order function, along with their solutions.
If the issue persists even after confirming that the file has no problems, please contact our chat support.
List of errors
Error: The uploaded file is not in CSV format. Please review the file.
If the uploaded file is not in CSV format, an error is displayed. Please check the file, convert it to CSV format, and try the registration process again.
Error: A required column (customerName) is missing. Please add and re-upload.
An error is displayed if the first five lines of the file you attempted to register show that required fields are missing values. Please input values for all required fields and try the registration process again.
Error: Multiple headers have the same name. Please rename to make headers unique, or delete unnecessary columns and re-upload.
An error is displayed if the first five lines of the file you attempted to register show duplicate names in the header. Please change the names of the duplicate fields or remove the columns, and try the registration process again.
Error: Please enter a value of type XXX in {row number} of {column name}. Please correct and re-upload.
An error is displayed if the first five lines of the file you attempted to register do not match the set field types. Please correct the registration data and try the registration process again.
Numeric type: This field can only accept numbers (e.g., 1000).
Date type: This field can only accept dates.
Supported date formats:
YYYY-MM-DD (e.g., 2024-06-01)
YYYY/MM/DD (e.g., 2024/06/01)
YYYYMMDD (e.g., 20240601)
Currency code type: This field can only accept currency codes.
Error: No values have been entered in the file. Please check the contents.
An error is displayed if the first five lines of the file you attempted to register show that the uploaded CSV file contains 0 or 1 line (header only). Please enter values and try the registration process again.
Error: The file name contains invalid characters. Please change the file name and re-upload.
An error is displayed if the file name you attempted to register is inappropriate. Please change the file name and try the registration process again.
The file name must be between 1 and 255 characters.
Do not start the file name with a period (.).
The characters #, [, ], ?, * cannot be used in the file name.
Line break characters cannot be used in the file name.
The file name must end with “.csv”.