Purchase Order DespatchedUpdated a month ago
This message is responsible for updating us once you have despatched an order and letting us know of any tracking information.
Folder Location
This file should be generated in real-time as orders are dispatched and should be saved to “inbox”. Once successfully processed, we will move the file to “inbox_archive” folder.
Version
This version is “1_3”. Released on 30th January 2020.
Filename Format
order_despatched-{version}-{yyyymmddhhmmssnnnnn}.csv
File Sections
- Header Record (1 per order)
- Detail Record (1 per order line, unlimited number per order)
- Checksum Record (1 per file)
File Contents
| Column Header | Section | Required | Type | Max Length | Notes | |
1 | section | Header | Y | Text | 255 | Will always be “header” | |
2 | order_number | Header | Y | Text | 100 | Our unique identifier for the order | |
3 | supplier_order_ref | Header | Y | Text | 100 | Your unique reference for the order | |
4 | spare_field_1 | Header | N | Text | 255 |
| |
5 | spare_field_2 | Header | N | Text | 255 |
|
| Column Header | Section | Required | Type | Max Length | Notes |
1 | section | Detail | Y | Text | 255 | Will always be “detail” |
2 | line_ref | Detail | Y | Text | 5 | Our unique identifier for the line within the order |
3 | supplier_sku | Detail | Y | Text | 255 | Your unique identifier for the product/service |
4 | retailer_sku | Detail | Y | Text | 255 | Our unique identifier for the product/service |
5 | grade | Detail | Y | Text | 3 | Grading scale 100 - New |
6 | despatched_qty | Detail | Y | Numeric | N/A | Quantity despatched |
7 | despatched_date | Detail | Y | Date | N/A | Format: yyyy-MM-dd |
8 | despatched_serial_numbers | Detail | Y (unless non serial tracked item) | Text | 2000 | A pipe (|) delimited list of the despatched items serial numbers |
9 | carrier | Detail | Y | Text | 100 | For allowed values, see Supported Carriers |
10 | carrier_service | Detail | Y | Text | 100 |
|
11 | carrier_tracking_number | Detail | Y (unless untrackable) | Text | 255 |
|
12 | carrier_tracking_url | Detail | N | Text | 2000 |
|
13 | estimated_delivery_date | Detail | N | Date | N/A | Format: yyyy-MM-dd |
14 | spare_field_1 | Detail | N | Text | 255 |
|
15 | spare_field_2 | Detail | N | Text | 255 |
|