CSV Sales Order Top Level
- James Seabrook
These fields are required:
External Reference, eg. US-0000234
Created date
Client Ref
Booking Reason
Allocate Goods from Ref
Customer (Consignee/Delivery details)
Title
Forename
Surname
Phone Number
Email
Delivery required by date (only need 1 date on here, no time required)
Fulfilment warehouse
Warehouse Code
Warehouse Name
ESD - Scheduled ship date only
Packaging info
Delivery notes
Expected ETA
Assembly required
Notes
Field | Description |
|---|---|
Document Number | External Reference Number supplied by the client |
Transfer Order Reference # | Connected Transfer Order (another External Reference Number) |
Shipping Instructions | General instructions for the attention of the haulier |
Company Name | Company Name |
Shipping Address 1 | Shipping Address |
Shipping Address 2 | Shipping Address |
Shipping City | Shipping Address |
Shipping State/Province | Shipping Address |
Shipping Zip | Shipping Address |
Shipping Country | Shipping Address |
First Name | Addressee |
Last Name | Addressee |
Phone Number | Addressee |
Delivery Contact Email | Addressee |
Quantity | Quantity of Item |
Item | SKU to be delivered |
KIT BOX 1 | “Child SKU” - quantity 1 by definition |
KIT BOX 2 | “Child SKU” - quantity 1 by definition |
KIT BOX 3 | “Child SKU” - quantity 1 by definition |
KIT BOX 4 | “Child SKU” - quantity 1 by definition |
KIT BOX 5 | “Child SKU” - quantity 1 by definition |
KIT BOX 6 | “Child SKU” - quantity 1 by definition |
KIT BOX 7 | “Child SKU” - quantity 1 by definition |
KIT BOX 8 | “Child SKU” - quantity 1 by definition |
KIT BOX 9 | “Child SKU” - quantity 1 by definition |
KIT BOX 10 | “Child SKU” - quantity 1 by definition |
KIT BOX 11 | “Child SKU” - quantity 1 by definition |
KIT BOX 12 | “Child SKU” - quantity 1 by definition |
KIT BOX 13 | “Child SKU” - quantity 1 by definition |
KIT BOX 14 | “Child SKU” - quantity 1 by definition |
KIT BOX 15 | “Child SKU” - quantity 1 by definition |
KIT BOX 16 | “Child SKU” - quantity 1 by definition |
KIT BOX 17 | “Child SKU” - quantity 1 by definition |
KIT BOX 18 | “Child SKU” - quantity 1 by definition |
KIT BOX 19 | “Child SKU” - quantity 1 by definition |
KIT BOX 20 | “Child SKU” - quantity 1 by definition |
KIT BOX 21 | “Child SKU” - quantity 1 by definition |
KIT BOX 22 | “Child SKU” - quantity 1 by definition |
KIT BOX 23 | “Child SKU” - quantity 1 by definition |
Estimated Ship Date | Ship date |
Customer Deliver by Date | Deliver by |
Carrier | Carrier (if applicable) |
Internal ID | Client Internal ID |
Order Type | Client Order Type |
Location | Preferred warehouse for picking |
Assembly? | Is assembly required? |
TransitMode | Usually “ROAD” |
QuantityUnit | Quantity Type, usually PCS |