Order Import spreadsheet field specifications

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

Email 

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 ‘Firstname’ 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

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

Numeric (Decimal e.g. '9.99')

6

Any custom duty costs already paid

No

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

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

Sub-total 

Numeric (Decimal e.g. '9.99')

6

Maximum 2 decimal places

No

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

This is the total price of the order. 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 

Numeric (8-digits e.g. 01022920)

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

100

 

No

Quantity

 

Numeric (Integer e.g. ‘9’)

6

 

No

Stock location 

Alphanumeric

50

 

No

Unit price

 

Numeric (Decimal e.g. '9.99')

6

Maximum 2 decimal places

No