How it Works
For all order files, there must be a corresponding order line items file suing the following naming convention (i.e. filename starts with "orderitems" instead of "orders")
|
CSV File |
|
|
|
All Order Items |
orderitems_YYYYMMDDHHMMSS.csv |
Sent once a day during the night |
|
New Order Items |
orderitems_YYYYMMDDHHMMSS_DELTA.csv (same columns as All Order Items file) |
If sending new orders throughout the day |
Mandatory Fields
The following are the mandatory fields that must be included in the files:
|
OrderNumber |
Text(50) |
The unique order number |
|
OrderItemNumber |
Number |
A sequential number starting at 1 and increasing by 1 for each line item - i.e. 1, 2, 3, 4, ... |
|
ProductCode |
text(50) |
The unique product code |
| Quantity
|
Integer Number |
The quantity purchased |
| UnitPrice | Number |
The per unit price |
| Title | Text(100) |
The title of the product |
Optional Fields
The following are the optional fields that can be included in the files:
|
ShortDescription |
Text(3900) |
Optional longer description about the product |
Comments
0 comments
Please sign in to leave a comment.