Please note: CSV imports currently only support a numeric string of 11 or lower characters.
The following is a full list of all supported fields when importing orders via spreadsheet into Click & Drop.
| Field name | Format | Max Length (Characters) | Comments | Mandatory Field |
| Address Book Information | ||||
|
Address book reference |
Alphanumeric |
100 |
|
No |
|
Shipping address |
||||
|
Address Line 1 |
Alphanumeric |
100 |
|
Yes |
|
Address Line 2 |
Alphanumeric |
100 |
|
No |
|
Address Line 3 |
Alphanumeric |
100 |
|
No |
|
Addressee Identification Reference Number (AIRN) |
Alpha |
20
|
Enter AIRN number if required |
Mandatory for specific international destinations only |
|
City |
Alpha |
100 |
|
Yes |
|
Company Name |
Alphanumeric |
100
|
|
No (Yes if no 'First name' or 'Last name' fields are present. |
|
Country |
Alpha |
200
|
Full name of country, ie 'Peru', or 3-digit ISO code. |
No |
|
County |
Alpha |
100 |
|
No |
|
Customer title |
Alphanumeric |
10 |
|
No |
|
|
Alphanumeric (email) |
100 |
Must include both the ‘@’ and ‘.’ Symbols |
No |
|
First Name |
Alphanumeric (Standard Roman characters only) |
100 |
|
Yes |
|
Full name |
Alphanumeric (Standard Roman characters only) |
200 |
Combined of ‘First name’ and ‘last name’ |
No (Yes if ‘First and last names are combined’ option is selected) |
|
Last Name |
Alphanumeric (Standard Roman characters only) |
100
|
|
No |
|
Phone |
Numeric |
25 |
|
No |
|
Postcode |
Alphanumeric |
20 |
May be numeric for international postal codes such as Zip Codes |
Yes |
|
Recipient is a business |
Alphanumeric |
5 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
| Order Information | ||||
|
Commercial invoice date |
Date (DD/MM/YY) |
8 |
Date the commercial invoice was created |
No |
|
Commercial invoice number |
Alphanumeric |
35 |
|
No |
|
Consequential Loss (OBA only) |
Numeric (Decimal) |
25 |
Enter the value in pounds (£) do not include the pound sign. |
No |
|
Currency Code |
Alpha (3-digit) |
20 |
No |
|
|
Customs duty costs (OBA only) |
Numeric (Decimal e.g. '9.99') |
6 |
Any custom duty costs already paid under the Delivery Duty Paid scheme |
Only when using (P)DDP Services. Zero value accepted |
|
Date |
Date (DD/MM/YY) |
8 |
Date the order was placed/created |
No |
|
Department (OBA only) |
Alphanumeric |
25 |
Allows full name or department code. |
No |
|
Email Notification |
Alphanumeric |
10 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
Guaranteed Saturday Delivery (OBA only) |
Alphanumeric |
200 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
IOSS Number
|
Alphanumeric |
50 |
International orders only, enter an IOSS number only if applicable. |
No |
|
Local Collect (OBA only) |
Alphanumeric |
10 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
Obtain a signature (OBA only) |
Alphanumeric |
10 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
Order reference |
Alphanumeric
|
40
|
Unique order reference |
No |
|
Other Costs |
Numeric (Decimal e.g. '9.99') |
6 |
Any additional costs that must be declared for international customs |
No |
|
Package Size |
Alpha (‘letter’, ‘large letter’, ‘small parcel’, ‘medium parcel’, or ‘parcel’, or 'printed papers' only) |
N/A |
Valid package sizes are: Letter, Large letter and Parcel. Small parcel and Medium parcel package sizes are for domestic orders only |
No |
|
Planned despatch date (OBA only) |
Date |
25 |
Uses date format used in import settings. (otherwise defaults to DD/MM/YY) |
No |
|
Recipient EORI number |
Alphanumeric |
18 |
Enter recipient EORI if required. (NOTE - Column present only for testing - functionality not yet live) |
No |
|
Requires export license |
Alphanumeric |
10 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
Safeplace (OBA only) |
Alphanumeric |
90 |
|
No |
|
Service code |
Alphanumeric |
100 |
Allows Royal Mail service code or Alias (Dependent on settings) |
No |
|
Service register code (OBA only) |
Numeric (2-digit e.g. '01') |
2 |
Enter unique service register code for the service you want to apply. |
No |
|
Shipping Cost |
Numeric (Decimal e.g. '9.99') |
6 |
Shipping cost paid by customer (Maximum 2 decimal places) |
No |
|
SMS Notification |
Alphanumeric |
10 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
|
Special instructions |
Alphanumeric
|
100 |
|
No |
|
Order Tax |
Numeric (Decimal e.g. '9.99') |
6 |
Total value of order tax |
No |
|
Sub-total |
Numeric (Decimal e.g. '9.99') |
6 |
Total value of order excluding tax and retail shipping costs (Maximum 2 decimal places) |
No, but highly recommended for international orders
|
|
Tag
|
Alphanumeric |
100 |
Enter the order tag in the format 'key=value', 'key:value', or 'value' |
No |
|
Total
|
Numeric (Decimal, e.g. '9.99') |
6 |
The total value of an order, including tax and Retail shipping costs. Please do not complete the Order tax and Retail shipping costs if using this field (Maximum 2 decimal places) |
No |
|
Trading name |
Alphanumeric (Case sensitive) |
250 |
Enter the trading name associated with the order. If no match is found, default trading name will be selected. |
No |
|
Weight |
Numeric (Decimal e.g. '9.99') |
Maximum 3 decimal places. |
Combined weight of product + packaging (Value in Kilograms (Kg) only. Max weight dependent on service) |
No |
|
Product information |
||||
|
Country of origin |
Alpha |
200 |
Full name of country, ie 'Peru', or 3-digit ISO code. |
No |
|
Customs code |
Alphanumeric (6 - 13 digits) |
10 |
Product customs codes (harmonised system codes) include only numbers consisting of 8 digits.) |
No |
|
Customs declaration category |
Alphanumeric (not case sensitive) |
20 |
Enter one of: 'Gift', 'Commercial sample', 'Documents', 'Other', 'Returned goods', 'Sale of goods', 'Mixed content', or 'None'. if left blank, will default to 'None' |
No |
|
Customs description
|
Alphanumeric |
50 |
For international orders, please enter a short description of your item for customs. (Examples: Computer parts, shirts, ceramic ornament) |
No |
|
Extended customs description |
Alphanumeric |
250 |
For international orders, please enter a longer description of your item for customs. (Example: Large-Sized Male Polo Pique T-Shirt, Colour: Red, Composition: 70% Cotton 30% Viscose, Machine Washable) |
No |
|
Identifier (SKU)
|
Alphanumeric |
100 |
Stock Keeping Unit must be unique per product. |
No |
|
Name |
Alphanumeric |
800 |
|
No |
|
Quantity
|
Numeric (Integer e.g. ‘9’) |
6 |
|
No |
|
Stock location |
Alphanumeric |
50 |
|
No |
|
Unit price
|
Numeric (Decimal e.g. '9.99') |
6 |
Unit price excluding tax (Maximum 2 decimal places) |
No |
|
Unit weight |
Numeric (Decimal e.g. '9.99') |
Maximum 3 decimal places |
Weight of a single quantity product in kilograms only |
No |