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 | Click for more information | 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 | ||||
| ContentsPieceURL | Alphanumeric (URL) | 80 | URL pointing to details about the specific product. Must link to the specific product page, not a general homepage or shop page | From 1st July 2026 Mandatory for EU and USA destinations |
| 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. | From 1st July 2026 Mandatory for EU and USA destinations |
| Name | Alphanumeric | 800 | No | |
|
Quantity
|
Numeric (Integer e.g. ‘9’) | 6 | No | |
| Reference ID | Alphanumeric | 50 | Manufacturer's product reference (internal or standardised), e.g. GTIN, EAN, UPC | From 1st July 2026 Mandatory for EU and USA destinations |
| 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 |