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