Order Import spreadsheet field specifications

Please note: CSV imports currently only support a numeric string of 11 or lower characters.

Field Name

Format

Max. Length (characters)

 

Comments

 

Mandatory Field

Order information

Order reference

Alphanumeric

 

40

 

Unique order reference

No

Special instructions

 

Alphanumeric

 

100

 

No

Date

 

Date (dd/mm/yy)

8

Date the order was placed/created

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

Package Size

 

Alpha (‘letter’, ‘large letter’, ‘small parcel’, ‘medium parcel’, or ‘parcel’ 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

Sub-total

 

Numeric (Decimal e.g. '9.99')

6

Maximum 2 decimal places

No

Shipping Cost

 

Numeric (Decimal e.g. '9.99')

6

Shipping cost paid by customer

(Maximum 2 decimal places)

No

Total

 

Numeric (Decimal e.g. '9.99')

6

Maximum 2 decimal places

No

Currency Code

 

Alpha (3-digit)

20

Click for more information

No

Service code

 

Alphanumeric

10

Allows Royal Mail service code or Alias (Dependent on settings)

No

Service register code

 

Numeric (2-digit e.g. '01')

2

Enter unique service register code for the service you want to apply.

No

Safeplace

 (OBA only)

Alphanumeric

90

 

No

Department

 (OBA only)

Alphanumeric

25

Allows full name or department code.

No

Planned despatch date

 (OBA only)

Date 

25

Uses date format used in import settings. (otherwise defaults to DD/MM/YY)

No

Consequential Loss

OBA only)

Numeric (Decimal)

25

Enter the value in pounds (£) do not include the pound sign.

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

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

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

Harmonised system codes

 

Numeric (8-digits e.g. 01022920)

8

Harmonized system codes must include only numbers consisting of 8 digits. For multiple numbers, separate by commas. Example: 01022920,01022930

No

Address book information

Address book reference

 

Alphanumeric

100

 

No

Shipping address information

Customer title

 

Alphanumeric

10

 

No

First Name

 

Alphanumeric (Standard Roman characters only)

100

 

Yes

Last 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)

Phone

 

Numeric

25

 

No

Email

 

Alphanumeric (email)

100

Must include both the ‘@’ and ‘.’ Symbols

No

Company Name

 

Alphanumeric

100

 

 

No

Address Line 1

 

Alphanumeric

100

 

Yes

Address Line 2

 

Alphanumeric

100

 

No

Address Line 3

 

Alphanumeric

100

 

No

City

 

Alpha

100

 

Yes

County

 

Alpha

100

 

No

Postcode

 

Alphanumeric

20

May be numeric for international postal codes such as Zip Codes

Yes

Country

 

Alpha

200

 

Full name of country, ie 'Peru', or 3-digit ISO code

No

Product information

SKU

 

Alphanumeric

100

 

No

Name

 

Alphanumeric

100

 

No

Unit price

 

Numeric (Decimal e.g. '9.99')

6

Maximum 2 decimal places

No

Quantity

 

Numeric (Integer e.g. ‘9’)

6

 

No

Unit Weight

 

Numeric (Decimal e.g. '9.99')

Maximum 3 decimal places.

Weight of product only (Value in Kilograms (Kg) only. Max weight dependent on service)

No

Product harmonised system code

 

Numeric (8-digits e.g. 01022920)

8

Harmonized system codes must include only numbers consisting of 8 digits. For multiple numbers, separate by commas. Example: 01022920,01022930

No

Stock location

 

Alphanumeric

50

 

No