Options for sending the CSV to Stiller:

<aside> ℹ️ You must allow emails from [email protected]

</aside>

<aside> ✅ Deliveries into Amazon are supported. Please see the detail below.

</aside>

<aside> ⚠️ Hazardous (ADR) consignments are supported via API but not yet via CSV.

</aside>

Example CSV file

CSV files should be of the following format. You can send one file containing multiple orders (on different rows) or one file per order.

Do not include the header row in your CSV files. It is included here for reference.

CSV Import example file.csv

<aside> ℹ️ If your system cannot generate this file structure, please contact us. It may be possible to accept CSV files in a different structure.

</aside>

<aside> ❌ Please note the following characters/combinations which are not permitted in fields within the CSV (except where stated in the table/notes below): • | - Pipe • ¦ - Broken pipe • { or } - Curly parentheses • [ or ] - Square parentheses

</aside>

Fields

<aside> ⚠️ The cases of system codes and names are important, for example: • PALLETLINE not palletline • LC,SC not lc,sc • json not Json

</aside>

Column Field Required Description Example
1 customer_code Y Your account code with Stiller. This will be 6 letters and 2 digits, as printed on all invoices from Stiller. YOURCO01
2 transport_network Y Either PALLETLINE, HAZCHEM or GENERAL PALLETLINE
3 service_level Y A for 24h
B for 48h
C for 72h B
4 collection_date Y Date in format yyyy-mm-dd 2024-05-22
5 delivery_date Y Date in format yyyy-mm-dd 2024-05-24
6 order_identifier Y Your unique identifier for the order (e.g. the order id from your system). If this is not unique a new order will not be placed - it will cause a previous order with the same order_identifier to be updated. 654778
7 order_reference Your order reference (e.g. PO number) which can be repeated on different orders. This does not have to be unique. PO-1234
8 collection_name Name of business/contact at the location Joe Bloggs
9 collection_address_1 Y Address first line Stiller Warehousing & Distribution Ltd.
10 collection_address_2 Address second line Ridgeway, Aycliffe Business Park
11 collection_city Y Postal town Newton Aycliffe
12 collection_postal_code Y Postal code including space (excluding country code) DL5 6SP
13 collection_country_code Y • See note 1 below GB
14 collection_telephone Include the international dialling code for non-UK numbers
( +44 is optional for UK numbers) 01325 313140
15 collection_mobile Include the international dialling code for non-UK numbers
( +44 is optional for UK numbers) +447890123456
16 collection_email Email of the location [email protected]
17 collection_reference Reference for the stop (e.g. collection/delivery booking reference). REF_123
18 collection_note Instructions for the stop. Ring top buzzer at gate
19 delivery_name Similar for collection above. Jane Doe
20 delivery_address_1 Y Similar for collection above. High Street
21 delivery_address_2 Similar for collection above. The Village
22 delivery_city Y Similar for collection above. Newtown
23 delivery_postal_code Y Similar for collection above. NT12 3AB
24 delivery_country_code Y Similar for collection above. GB
25 delivery_telephone Similar for collection above. +44 1234 567890
26 delivery_mobile Similar for collection above. 07123 456789
27 delivery_email Similar for collection above. [email protected]
28 delivery_reference Similar for collection above. Delivery 2334
29 delivery_note Similar for collection above. Ring mobile if no answer at door
30 collection_time_window_code • See note 2 below CA
31 collection_time_window_start • See note 2 below
32 collection_time_window_end • See note 2 below
33 collection_extras • See note 3 below LC,SC
34 delivery_time_window_code • See note 4 below BD
35 delivery_time_window_start • See note 4 below 09:45
36 delivery_time_window_end • See note 4 below
37 delivery_extras • See note 5 below LA,PU
38 goods_description Description of the goods Kitchen furniture
39 non_stackable Y TRUE if non-stackable
FALSE if stackable FALSE
40 pallet_wrap Y TRUE if required palletisation and wrap
FALSE if not FALSE
41 limited_quantity Y TRUE if hazardous limited quantity
FALSE if not FALSE
42 amazon_ASN_number ASN no for deliveries into Amazon
Extra AMAZON must be entered in column 37
43 amazon_FBA_number FBA no for deliveries into Amazon
Extra AMAZON must be entered in column 37
44 amazon_PO_number PO no for deliveries into Amazon
Extra AMAZON must be entered in column 37
45 amazon_carton_count Carton count for deliveries into Amazon
Extra AMAZON must be entered in column 37
46 amazon_unit_count Unit count for deliveries into Amazon
Extra AMAZON must be entered in column 37
47 • See note 8 below
48 • See note 8 below
49 • See note 8 below
50 • See note 8 below
51 goods_format Y simple or json
• See note 6 below simple
52 goods Goods to be carried
** • See note 7 below
53 • See note 8 below
54 • See note 8 below
55 • See note 8 below
56 • See note 8 below
57 half_pallet_quantity Number of half-sized pallets
• See note 6 below 2
58 half_pallet_total_weight Total weight (kg) of all half-sized pallets
• See note 6 below 320
59 full_pallet_quantity Number of full-sized pallets
• See note 6 below 1
60 full_pallet_total_weight Total weight (kg) of all full-sized pallets
• See note 6 below 650
61 oversized_2sp_quantity Number of 2-space-sized pallets
• See note 6 below 2
62 oversized_2sp_total_weight Total weight (kg) of all 2-space-sized pallets
• See note 6 below 950
63 oversized_3sp_quantity Number of 3-space-sized pallets
• See note 6 below 1
64 oversized_3sp_total_weight Total weight (kg) of all 3-space-sized pallets
• See note 6 below 700
65 • See note 8 below
66 • See note 8 below
67 • See note 8 below
68 • See note 8 below
69 • See note 8 below
70 • See note 8 below

Notes

Note 1

Country codes must be the internationally recognised 2-letter codes according to ISO 3166. Please note the following often misquoted country codes: