How it Works
To integrate offline orders, the following is how it works (which is similar to the full stock file and stock delta files):
- 1 Full Orders File Each Night - You have to send 1 orders file by CSV each night (e.g. 3:00am) with all orders. For example, if you only want to have the last 15 months of orders, then only export the last 15 months of orders and the older ones will automatically remove themselves from the website.
- Order Deltas during the Day - Then you just send new orders throughout the day – called “Order Deltas”.
CSV File Naming Standards
The following are the CSV files that you can export:
CSV File |
|
|
All Orders |
orders_YYYYMMDDHHMMSS.csv |
Sent once a day during the night with all orders (e.g. 3:00am) |
New Orders |
orders_YYYYMMDDHHMMSS_DELTA.csv (same columns as All Orders file) |
If sending new orders throughout the day, send this file every 15 minutes with just the latest orders |
Mandatory Fields
The following are the mandatory fields that must be included in the files:
OrderNumber |
Text(50) |
The unique order number |
CurrencyCode |
Text(3) |
e.g. EUR, GBP, USD, etc |
OrderDate |
|
Must be in format "14 Feb 2020" or "14 Feb 2020 15:35" |
OrderItemsTotal
|
Number |
Total before TAX |
Total | Number |
Total including TAX (if not syncing tax and tax is always zero, then this should be the same as OrderItemsTotal) |
Optional Fields
The following are the optional fields that can be included in the files:
AccountCode |
Text(50) |
The unique customer code (matched to the customers file) |
PrimaryEmail
|
Text(100) |
The email address entered with this order |
OutletCode |
Text(50) |
If this order was purchased in an outlet, enter the outlet code - contact the help desk for your list of outlet codes |
InvoiceNumber |
Text(50) |
|
PONumber |
Text(20) |
|
TaxTotal |
Number |
If sending a tax amount, enter it here |
ReplaceOrderID OR ReplaceShipmentID |
Guid |
Only for finalised orders replacing a web order OR Only for finalised orders replacing a web shipment (if using "shipments" instead of orders - which are a group of web orders grouped into 1 order for a customer) |
Comments
0 comments
Please sign in to leave a comment.