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’, 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 |
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 |
This is the total price of the order. Maximum 2 decimal places |
No |
Currency Code
|
Alpha (3-digit) |
20 |
No |
|
Service code
|
Alphanumeric |
100 |
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 |
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 |
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 |
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 |
Tag
|
Alphanumeric |
100 |
Enter the order tag in the format 'key=value', 'key:value', or 'value' |
No |
Requires export license
|
Alphanumeric |
1 |
Enter any of the following: True, False, Yes, No, Y, N, 1, 0 (will default to 0 if left blank). |
No |
Commercial Invoice Number
|
Alphanumeric |
35 |
Enter the Commercial Invoice Number of the order |
No |
Commercial Invoice Date
|
Date |
25 |
Enter the Commercial Invoice Date in format DD/MM/YY |
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
|
|
No |
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 |
|
Alphanumeric (email) |
100 |
Must include both the ‘@’ and ‘.’ Symbols |
No |
Company Name
|
Alphanumeric |
100
|
|
No (Yes if no 'First name' or 'Last name' fields are present. |
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 Please note: You will need to include SKU and Name for us to display your product information. |
||||
SKU
|
Alphanumeric |
100 |
Stock Keeping Unit must be unique per product. |
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 customs code
|
Numeric (8-digits e.g. 01022920) |
10 |
Product customs codes (harmonised system codes) include only numbers consisting of 8 digits.) |
No |
Stock location
|
Alphanumeric |
50 |
|
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 |
Country of origin
|
Alpha |
200 |
Full name of country, ie 'Peru', or 3-digit ISO code. |
No |