File Guidelines
Ensure a successful upload – follow these guidelines to create and set up your file properly. You can save time by using one of our sample files. Just download the preferred file, edit it with your item details, save and upload it.
|
|
|
- For every item, every field must be present in your file, but details can be blank for some fields (as noted)
- Fields must be in the order noted below for each item in your file
- Describe items in English only
- Details that exceed character maximum will result in errors when uploading
- Maximum 250 items per file
|
Order
|
Field Name
|
Character Maximum
|
Format
|
Description
|
Example
|
|---|---|---|---|---|---|
|
1
|
Unique Item Number
|
1 |
Must always be 1
|
1 must be the first field for every unique item
|
1
|
|
2
|
Item
|
None
|
INV_ITEM |
INV_ITEM must be present in this field, for every item
|
INV_ITEM
|
|
3
|
Item Description
|
170
|
Alpha/Numeric |
Description should include details about what the items is, what it is made of and what it is used for.
|
Women’s dress made of cotton
|
|
4
|
Commodity Code
|
Minimum: 6 Maximum: 15 |
Numeric and periods (.) |
This is for the Commodity Code (or Schedule B code) that corresponds to the item.
Can be a whole number, such as:
Can include a decimal, such as:
|
123456
|
|
5
|
Quantity
|
None
|
Numeric Only |
This is for the Quantity of each unique item (how many).
|
20
|
|
6
|
Units
|
3
|
Alpha/Numeric |
This is for the code that corresponds to Units.
Refer to Reference Codes |
EA
|
|
7
|
Value
|
Maximum: 18
Maximum numbers after decimal: 5
|
Numeric, periods (.) and comma (,) |
This is for the Value for each individual item.
Can be a whole number, such as:
Can include a decimal, such as:
If less than 1, must include a zero (0) before the decimal point, for example:
|
50
|
|
8
|
Currency
|
3
|
Alpha Only |
This is for the item value Currency Code
Refer to Reference Codes |
EUR
|
|
9
|
Weight
|
Maximum after decimal: 3
|
Numeric, periods (.) and comma (,) |
This is for the Weight of each individual item.
Can be a whole number, such as:
Can include a decimal, such as:
If less than 1, must include a zero (0) before the decimal point, for example:
|
2
|
|
10
|
Weight 2
|
None
|
Must be blank
|
Include this field in your file but leave details blank
|
|
|
11
|
Country of Origin
|
2
|
Alpha Only |
This is for the Country Code that corresponds to where the item was made
Refer to Reference Codes
|
CN
|
|
12
|
Reference Type
|
3
|
Can be blank
Only one code per item:
SE
MID
SON
BRD
MAK
AFE
AAJ
PAN
ABW
|
You may want to add a Reference Type for an item. This is for the code that corresponds to the Reference Type. Codes are:
Ensure you provide a Reference Type code if you have set up a default to always include an item reference in Shipment Settings. |
SON
|
|
13
|
Reference Details
|
35
|
Alpha/Numeric
Cannot be blank if Reference Type included in file
|
This is for the details that correspond to the Reference Type, for example the item's serial number or brand.
|
1234ABCD
|
|
14
|
Tax Paid
|
1
|
Y, N
Can be blank
|
This is to indicate whether tax is paid for the item
|
Y
|
- For every item, every field must be present in your file, but details can be blank for some fields (as noted)
- Field tags must appear before and after the corresponding field details. Include start and end details in the file. Refer to example
- Describe items in English only
- Details that exceed character maximum will result in errors when uploading
- Maximum 250 items per file
|
Order
|
Field Name
|
Character Maximum
|
Format
|
Field Tag and Description
|
Example
|
|---|---|---|---|---|---|
|
1
|
Unique Item Number
|
None |
<ID>1</ID>
|
Field Tag: ID
1 must be the first field for every unique item
|
<ID>1</ID>
|
|
2
|
Item
|
None
|
INV_ITEM |
Field Tag: INV_ITEM
INV_ITEM must be present in this field, for every item
|
INV_ITEM
|
|
3
|
Item Description
|
170
|
Alpha/Numeric |
Field Tag: INV_DESCRIPTION
Description should include details about what the items is, what it is made of and what it is used for.
|
Women’s dress made of cotton
|
|
4
|
Commodity Code
|
Minimum: 6 Maximum: 15 |
Numeric and periods (.) |
Field Tag: COMMODITY
This is for the Commodity Code (or Schedule B code) that corresponds to the item.
Can be a whole number, such as:
Can include a decimal, such as:
|
123456
|
|
5
|
Quantity
|
None
|
Numeric Only |
Field Tag: QUANTITY
This is for the Quantity of each unique item (how many).
|
20
|
|
6
|
Units
|
3
|
Alpha/Numeric |
Field Tag: QTY_UOM
This is for the code that corresponds to Units.
Refer to Reference Codes |
EA
|
|
7
|
Value
|
Maximum: 18
Maximum numbers after decimal: 5
|
Numeric, periods (.) and comma (,) |
Field Tag: ITEM_VALUE
This is for the Value for each individual item.
Can be a whole number, such as:
Can include a decimal, such as:
If less than 1, must include a zero (0) before the decimal point, for example:
|
50
|
|
8
|
Currency
|
3
|
Alpha Only |
Field Tag: ITEM_VALUE_CURRENCY
This is for the item value Currency Code
Refer to Reference Codes |
EUR
|
|
9
|
Weight
|
Maximum after decimal: 3
|
Numeric, periods (.) and comma (,) |
Field Tag: NET_WEIGHT
This is for the Weight of each individual item.
Can be a whole number, such as:
Can include a decimal, such as:
If less than 1, must include a zero (0) before the decimal point, for example:
|
2
|
|
10
|
Weight 2
|
None
|
Must be blank
|
Field Tag: GROSS_WEIGHT
Include this field in your file but leave details blank
|
|
|
11
|
Country of Origin
|
2
|
Alpha Only |
Field Tag: COUNTRY_ORIGIN
This is for the Country Code that corresponds to where the item was made
Refer to Reference Codes
|
CN
|
|
12
|
Reference Type
|
3
|
Can be blank
Only one code per item:
SE
MID
SON
BRD
MAK
AFE
AAJ
PAN
ABW
|
Field Tag: REFERENCE_TYPE
You may want to add a Reference Type for an item. This is for the code that corresponds to the Reference Type. Codes are:
|
SON
|
|
13
|
Reference Details
|
35
|
Alpha/Numeric
Cannot be blank if Reference Type included in file
|
Field Tag: REFERENCE_NUMBER
This is for the details that correspond to the Reference Type, for example the item's serial number or brand.
|
1234ABCD
|
|
14
|
Tax Paid
|
1
|
Y, N
Can be blank
|
Field Tag: VAT_PAID
This is to indicate whether tax is paid for the item
|
Y
|