The following is a full list of all supported fields when importing orders via spreadsheet into Click & Drop.
Fields are arranged alphabetically in sections in this guide, but they can go into your spreadsheets in any order.
- Address and Recipient information fields
- Order information fields
- Product information fields
- Enhanced feature fields
Address and Recipient information fields
If you have the 'Use shipping address for billing address' setting checked in your import settings, we will automatically copy all shipping address fields into the order billing address fields.
If you have the 'Use shipping address for billing address' setting checked off, you will need to copy all of the address fields in the Shipping address information into your spreadsheet and map them as billing address fields.
| Field name | Format | Max Length (Characters) | Comments | Mandatory Field |
| Shipping address information | ||||
| Address Line 1 | Alphanumeric | 100 | Yes | |
| Address Line 2 | Alphanumeric | 100 | No | |
| Address Line 3 | Alphanumeric | 100 | No | |
| 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 |
Address additional information | ||||
| Address book reference | Alphanumeric | 100 | If you enter an address book reference, we will use those details, so you can leave the shipping address fields blank. | No |
| Addressee Identification Reference Number (AIRN) | Alpha | 20 | Enter AIRN number if required | Mandatory for specific international destinations only |
| 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). | Mandatory if shipping from UK Mainland to Northern Ireland |
Order information fields
| Field name | Format | Max Length (Characters) | Comments | Mandatory Field |
| 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 |
| Delivery terms | Alphanumeric | 20 | Enter one of: DAP, DDP, DDU, DDU_DAP, IOSS, IOSS_DDP, IOSS_DDU, PDDP |
Optional for EU and USA shipments (may become mandatory in the future) |
| 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 | No (Required for some international orders) | |
| 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 fields
| Field name | Format | Max Length (Characters) | Comments | Mandatory Field |
| 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 | Optional for EU and USA shipments (may become mandatory in the future) |
| 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: 'Documents', 'Other', 'Returned goods', 'Commercial Sale of Goods', or 'E-Commerce Goods' | 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. | Required for EU shipments declared as E-Commerce Goods from (optional for all other shipments). If not provided on import, you will need to add it before applying postage. |
| Non-standardised Manufacturer ID | Alphanumeric | 50 | The manufacturer's product identifier or internal product code | Required for EU shipments declared as E-Commerce Goods (optional for all other shipments). If not provided on import, you will need to add it before applying postage. |
| ProductName | Alphanumeric | 800 | No | |
| Quantity | Numeric (Integer e.g. ‘9’) | 6 | No | |
| Standardised Manufacturer ID | Alphanumeric | 50 | A GTIN, EAN, UPC, ISBN, or similar standardised number. | Recommended for EU shipments declared as E-Commerce Goods from 1st November 2026. Optional for all other shipments. |
| 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 |
Enhanced feature fields
The fields are required for specific features or posting options.
If you post using commercial export services, you are required to provide additional information about the importer of the goods.
| Field name | Format | Max Length (Characters) | Comments | Mandatory Field |
Commercial export fields (OBA accounts only) | ||||
| Alphanumeric | 100 | No (Yes if no 'First name' or 'Last name' fields are present. | ||
| Importer Address line 1 | Alphanumeric | 100 | Yes | |
| Importer Address line 2 | Alphanumeric | 100 | No | |
| Importer Address line 3 | Alphanumeric | 100 | No | |
| Importer City | Alpha | 100 | Yes | |
| Importer Company Name | Alphanumeric | 100 | No (Yes if no 'First name' or 'Last name' fields are present. | |
| Importer Contact name | Alphanumeric | 200 | Full name | No (Yes if ‘First and last names are combined’ option is selected) |
| Importer Country | Alpha | 200 | Full name of country, ie 'Peru', or 3-digit ISO code. | No |
| Importer Email | Alphanumeric (email) | 100 | Must include both the ‘@’ and ‘.’ Symbols | No |
| Importer EORI number | Alphanumeric | 18 | No | |
| Importer 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 |
| Importer Phone number | Numeric | 25 | No | |
| Importer Postcode | Alphanumeric | 20 | May be numeric for international postal codes such as Zip Codes | Yes |
| Importer VAT number | Alphanumeric | 15 | No | |
Low Quality Dangerous Goods (LQDG) fields | ||||
| Contains dangerous goods | Alphanumeric | 5 | Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). | Mandatory if shipping dangerous goods |
| Dangerous goods description | Alphanumeric | 500 | Mandatory if shipping dangerous goods | |
| Dangerous goods quantity | Numeric (Integer e.g. ‘9’) | 6 | Mandatory if shipping dangerous goods | |
| Dangerous goods UN code | Alphanumeric | 4 | Mandatory if shipping dangerous goods | |