What is this import?
The Order import sends outbound orders to Access Delta WMS. The system uses this data to pick, pack, and despatch stock to customers.
You can create, amend, delete, hold, or add lines to existing orders. Each file can only contain one action type per order.
Package name: DeltaWMS IE Order Import V5 File format: CSV (header and detail lines in the same file)
Before you start
Each file can only contain one action (CREATE, AMEND, DELETE, HOLD, or ADDTO) per order
The HOLD action creates orders with a Held status — it cannot change the status of an existing order
All lines in an ADDTO file are treated as additions to the existing order
At least one of the four quantity fields (ITEM, PACK, INNER, or OUTER) must be present on each product line
Header line field specification
CSV Column | Field Name | Type | Max Characters | Required | Notes |
1 | "H" | A | 1 | M | Denotes header line |
2 | Data Type | AN | 10 | M | Must be "ORDER" |
3 | Action | A | 6 | Optional | CREATE / AMEND / DELETE / HOLD / ADDTO |
4 | Account Code | AN | 8 | M |
|
5 | Order Type | AN | 12 | Optional |
|
6 | Delivery Code | AN | 8 | Optional |
|
7 | Delivery Name | AN | 30 | Optional |
|
8 | Delivery Address 1 | AN | 50 | Optional |
|
9 | Delivery Address 2 | AN | 50 | Optional |
|
10 | Delivery Address 3 | AN | 50 | Optional |
|
11 | Delivery Address 4 | AN | 50 | Optional |
|
12 | Delivery Address 5 | AN | 50 | Optional |
|
13 | Delivery Post Code | AN | 12 | Optional |
|
14 | Delivery Country | AN | 30 | Optional |
|
15 | Delivery Contact | AN | 30 | Optional |
|
16 | Delivery Tel | AN | 20 | Optional |
|
17 | Delivery Fax | AN | 20 | Optional |
|
18 | Haulier Code | AN | 8 | Optional |
|
19 | Haulier Name | AN | 30 | Optional |
|
20 | Haulier Address1 | AN | 30 | Optional |
|
21 | Haulier Address2 | AN | 30 | Optional |
|
22 | Haulier Address3 | AN | 30 | Optional |
|
23 | Haulier Address4 | AN | 30 | Optional |
|
24 | Haulier Post Code | AN | 12 | Optional |
|
25 | Haulier Telephone | AN | 20 | Optional |
|
26 | Haulier Fax | AN | 20 | Optional |
|
27 | Site Code | AN | 8 | Optional |
|
28 | Expected Delivery Date | DT | — | M | dd/mm/yyyy hh:mm |
29 | Vehicle Registration | AN | 10 | Optional |
|
30 | Order Code | AN | 20 | M |
|
31–36 | Reference1–Reference6 | AN | 20 | Optional |
|
37 | Picking Instructions1 | AN | 500 | Optional | \n = forced new line |
38–42 | Picking Instructions2–6 | AN | 30 | Optional |
|
43 | Delivery Instructions1 | AN | 500 | Optional | \n = forced new line |
44–48 | Delivery Instructions2–6 | AN | 30 | Optional |
|
49 | Send To Location | AN | 13 | Optional |
|
50 | Haulier Cases | N | — | Optional |
|
51 | Haulier Pallets | N | — | Optional |
|
52 | Haulier Weight | N | — | Optional |
|
53 | Pick Ref | AN | 12 | Optional |
|
54 | Load Ref | AN | 12 | Optional |
|
55 | Trailer | AN | 20 | Optional |
|
56 | Driver | AN | 20 | Optional |
|
57 | ClientCustomerEDICode | AN | 40 | Optional |
|
58–65 | Order Invoice fields | AN | Various | Optional | Used for bespoke reports/labels |
66 | Order-Gross-Weight | N | — | Optional | Used for bespoke reports/labels |
67 | Order-Net-Weight | N | — | Optional | Used for bespoke reports/labels |
68 | Delivery-Terms | AN | 40 | Optional | Used for bespoke reports/labels |
69 | Shipping-Conditions | AN | 20 | Optional | Used for bespoke reports/labels |
70 | Means-of-Transport | AN | 20 | Optional | Used for bespoke reports/labels |
71 | Order Priority | N | — | Optional |
|
72 | Partial Despatch Enabled | AN | 5 | Optional | True or False |
73 | Drop Sequence | N | — | Optional |
|
Order item line field specification
CSV Column | Field Name | Type | Max Characters | Required | Notes |
1 | "L" | A | 1 | M | Denotes product detail line |
2 | Product Code | AN | 50 | M |
|
3 | Batch | AN | 20 | Optional |
|
4 | ITEM Quantity | N | — | Optional | One of columns 4–7 must be present |
5 | PACK Quantity | N | — | Optional | One of columns 4–7 must be present |
6 | INNER Quantity | N | — | Optional | One of columns 4–7 must be present |
7 | OUTER Quantity | N | — | Optional | One of columns 4–7 must be present |
8 | Weight | N | — | Optional |
|
9 | Stock Condition | AN | 5 | Optional | SND or DMG |
10 | Serial | AN | 20 | Optional |
|
11 | Serial2 | AN | 20 | Optional |
|
12 | Batch2 | AN | 20 | Optional |
|
13 | Product Variant | AN | 30 | Optional |
|
14 | Production Date | DT | — | Optional | DD/MM/YYYY |
15 | Production Date To | DT | — | Optional | DD/MM/YYYY |
16 | Packaging Date | DT | — | Optional | DD/MM/YYYY |
17 | Packaging Date To | DT | — | Optional | DD/MM/YYYY |
18 | Expiration Date | DT | — | Optional | DD/MM/YYYY |
19 | Expiration Date To | DT | — | Optional | DD/MM/YYYY |
20 | Sell By Date From | DT | — | Optional | DD/MM/YYYY |
21 | Sell By Date To | DT | — | Optional | DD/MM/YYYY |
22 | Customer Order Ref | AN | 30 | Optional |
|
23 | Customs Reference | AN | 30 | Optional |
|
24 | Roll Length | N | — | Optional |
|
25 | Product Colour | AN | 20 | Optional |
|
26 | Product Size | AN | 20 | Optional |
|
27 | Bonded | AN | 5 | Optional | True or False |
28 | Number Range From | N | — | Optional |
|
29 | Number Range To | N | — | Optional |
|
30 | Rotation | AN | 20 | Optional |
|
31 | Alt Prod Code | AN | 50 | Optional | Used for bespoke reports/labels |
32 | Alt Line Note | AN | 40 | Optional | Used for bespoke reports/labels |
33 | Alt Line Reference | AN | 50 | Optional | Used for bespoke reports/labels |
34 | Pallet Reference | AN | 30 | Optional | Requested pallet to pick from |
35 | Alt Line Text | AN | 500 | Optional | \n = forced new line |
36 | HoldReference | AN | 10 | Optional |
|
Note: You do not need to include product line details if the action is DELETE and you are deleting the whole order.
Troubleshooting
If your import fails, check:
Account Code (Column 4), Expected Delivery Date (Column 28), and Order Code (Column 30) are present
At least one quantity field (ITEM, PACK, INNER, or OUTER) is on each product line
The file does not contain more than one action type for the same order
You are not using the HOLD action to change the status of an existing order