Notes:
Please note that this import can only be done in the back-end. After filling out the spreadsheet, please contact our Support Team for assistance.
Trim leading and trailing spaces from the entire sheet. If available, we recommend using the Excel add-in Ablebits to do this.
Column header names must follow the exact same naming scheme as provided or the import upload will fail.
Blank rows are considered empty and skipped by the importer.
It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed”.
Once imported, these orders will have a status of “Imported Historical Order”.
Field | Is Field Required? | Additional Details |
CustomerNumber | Yes |
|
OrderNumber | Yes |
|
Contact Name | No |
|
Receiver | No |
|
OrderDate | Yes |
|
InvoiceDate | Yes | |
PurchaseOrderNumber | No | |
TaxTypeName | Yes |
|
OrderTotal | Yes |
|
OrderItemNumber | Yes |
|
ItemPrice | Yes |
|
Quantity | No |
|
Description | No | |
StockName | No | |
StockSize | No | |
StockColor | No | |
StockFinish | No | |
StockWeight | No | |
FinishSize | No | |
RunSize | No | |
Note | No |