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

Numbers correspond to guidelines details
File Type: TXT, Field Delimiter: |
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

  • This is not for Quantity
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.
  • Describe each unique item separately in your file
  • Do not combine item descriptions in the same field
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:
  • 123456
Can include a decimal, such as:
  • 1234.12.1234
123456
5
Quantity
None

Numeric Only

This is for the Quantity of each unique item (how many).
  • Must be a whole number
  • Cannot include decimals
20
6
Units
3

Alpha/Numeric

This is for the code that corresponds to Units.
  • Units are things like: each, cartons, pieces, grams
  • Unit codes are things like: EA, CTS, PCS, GM
  • Only 1 code per item

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:
  • 10
Can include a decimal, such as:
  • 10.5
  • 20,25
If less than 1, must include a zero (0) before the decimal point, for example:
  • 0.5
50
8
Currency
3

Alpha Only

This is for the item value Currency Code
  • All items in your file must be the same 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:
  • 5.0
Can include a decimal, such as:
  • 1.5
If less than 1, must include a zero (0) before the decimal point, for example:
  • 0.25
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:

  • Serial Number: SE
  • Manufacturer's ID: MID
  • Sales Order Number: SON
  • Brand: BRD
  • Make: MAK
  • Export Control Classification Number (ECCN): AFE
  • Delivery Order Number: AAJ
  • : PAN
  • Stock Keeping Unit: ABW

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

Numbers correspond to guidelines details
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
  • This is not for Quantity
<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.
  • Describe each unique item separately in your file
  • Do not combine item descriptions in the same field
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:
  • 123456
Can include a decimal, such as:
  • 1234.12.1234
123456
5
Quantity
None

Numeric Only

Field Tag: QUANTITY
 
This is for the Quantity of each unique item (how many).
  • Must be a whole number
  • Cannot include decimals
20
6
Units
3

Alpha/Numeric

Field Tag: QTY_UOM
 
This is for the code that corresponds to Units.
  • Units are things like: each, cartons, pieces, grams
  • Unit codes are things like: EA, CTS, PCS, GM
  • Only 1 code per item

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:
  • 10
Can include a decimal, such as:
  • 10.5
  • 20,25
If less than 1, must include a zero (0) before the decimal point, for example:
  • 0.5
50
8
Currency
3

Alpha Only

Field Tag: ITEM_VALUE_CURRENCY
 
This is for the item value Currency Code
  • All items in your file must be the same 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:
  • 5.0
Can include a decimal, such as:
  • 1.5
If less than 1, must include a zero (0) before the decimal point, for example:
  • 0.25
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:

  • Serial Number: SE
  • Manufacturer's ID: MID
  • Sales Order Number: SON
  • Brand: BRD
  • Make: MAK
  • Export Control Classification Number (ECCN): AFE
  • Delivery Order Number: AAJ
  • : PAN
  • Stock Keeping Unit: ABW
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
Unit Codes
Unit Codes
Unit
Unit Code
Boxes
BOX
Centigram
2GM
Centimeters
2M
Cubic Centimeters
2M4
Cubic Feet
3M4
Cubic Meters
M3
Dozen Pairs
DPR
Dozen
DOZ
Pieces
PCS
Grams
GM
Gross
GRS
Kilograms
KG
Liters
L
Meters
M
No Unit Required
X
Number
NO
Ounces
2KG
Pairs
PRS
Gallons
2L
Pounds
3KG
Square Centimeters
CM2
Square Feet
2M2
Square Inches
3M2
Cartons
CT
Feet
FT
Inches
IN
Sachets
SK
Set
SET
Millimeters
MM
Yards
YD
Milligrams
MG
Square Yards
SYD
Milliliters
ML
Each
EA
Square Meters
M2
Currency Codes
Currency Codes
Currency
Currency Code
Afghani
AFN
Algerian Dinar
DZD
Argentine Peso
ARS
Ariary
MGA
Aruba Guilder
AWG
Australian Dollar
AUD
Bahamian Dollar
BSD
Bahraini Dinar
BHD
Baht
THB
Balboa
PAB
Barbadian Dollar
BBD
Belarussian Ruble
BYN
Belize Dollar
BZD
Bermudian Dollar
BMD
Birr
ETB
Bolivar Soberano
VES
Boliviano
BOB
Brunei Dollar
BND
Bulgarian Lev
BGN
Burundese Franc
BIF
Canadian Dollar
CAD
Cape Verde Escudo
CVE
Cayman Islands Dollar
KYD
Cedi
GHS
CFA Franc - Central Africa
XAF
CFA Franc - West Africa
XOF
CFP Franc
XPF
Colombian Peso
COP
Comoros Franc
KMF
Convertible Marks
BAM
Cordoba Oro
NIO
Costa Rican Colon
CRC
Croatian Kuna
HRK
Cuban Peso
CUP
Czech Koruna
CZK
Dalasi
GMD
Danish Krone
DKK
Denar
MKD
Djibouti Franc
DJF
Dobra
STN
Dominican Republic Peso
DOP
Dong
VND
Dran
AMD
East Caribbean dollar
XCD
Egyptian Pound
EGP
Euro
EUR
Falkland Islands Pound
FKP
Fijian Dollar
FJD
Forint
HUF
Franc Congolais
CDF
Georgian Lari
GEL
Gibraltar Pound
GIP
Gourde
HTG
Guarani
PYG
Guinea Franc
GNF
Guyanan Dollar
GYD
Hong Kong Dollar
HKD
Hryvna
UAH
Icelandic Krona
ISK
IMF Monetary Unit
XDR
Indian Rupee
INR
Iranian Rial
IRR
Iraqi Dinar
IQD
Jamaican Dollar
JMD
Jordanian Dinar
JOD
Kenyan Shilling
KES
Khmer Rial
KHR
Kina
PGK
Kip
LAK
Kuwaiti Dinar
KWD
Kwacha
ZMW
Kwacha
MWK
Kwanza
AOA
Kyat
MMK
Lebanese Pound
LBP
Lek
ALL
Lempira
HNL
Leone
SLE
Leone
SLL
Leu
MDL
Leu
RON
Liberian Dollar
LRD
Libyan Dinar
LYD
Lilangeni
SZL
Loti
LSL
Malaysian Ringgit
MYR
Manat
AZN
Manat
TMT
Mauritius Rupee
MUR
Mexican Nuevo Peso
MXN
Moroccan Dirham
MAD
Mozambique Metical
MZN
Naira
NGN
Nakfa
ERN
Namibian Dollar
NAD
Nepalese Rupee
NPR
Netherlands Antilles Guilder
ANG
New Chile Peso
CLP
New Israeli Shekel
ILS
New Taiwan Dollar
TWD
New Turkish Lira
TRY
New Zealand Dollar
NZD
Ngultrum
BTN
No currency assigned
XXX
North Korean Won
KPW
Norwegian Krone
NOK
Nuevo Sol
PEN
Omani Rial
OMR
Ouguiya
MRU
Pa'anga
TOP
Pakistani Rupee
PKR
Pataca
MOP
Peso Convertible
CUC
Peso Uruguayo
UYU
Phillipines Peso
PHP
Pound Sterling
GBP
Pula
BWP
Qatar Rial
QAR
Quetzal
GTQ
Real
BRL
Real Time Gross Settlement dollars
ZWL
Rufiyaa
MVR
Rupiah
IDR
Russian Ruble
RUB
Rwanda Franc
RWF
Saudi Riyal
SAR
Serbia, Dinars
RSD
Seychelles Rupee
SCR
Singapore Dollar
SGD
Solomon Islands Dollar
SBD
Som
KGS
Somali Shilling
SOS
Somoni
TJS
South African Rand
ZAR
South Sudanese pound
SSP
Sri Lankan Rupee
LKR
St. Helena Pound
SHP
Sudanese Pound
SDG
Sum
UZS
Suriname Dollar
SRD
Swedish Krona
SEK
Swiss Franc
CHF
Syrian Pound
SYP
Taka
BDT
Tala
WST
Tanzanian Shilling
TZS
Tenge
KZT
Trinidad and Tobago Dollar
TTD
Tugrik
MNT
Tunisian Dinar
TND
UAE Dirham
AED
Ugandan Shilling
UGX
US Dollar
USD
Vanuatu Vatu
VUV
Won
KRW
Yemeni Riyal
YER
Yen
JPY
Yuan (Ren Min Bi)
CNY
Zloty
PLN
Country Codes
Country Codes
Country
Country Code
Afghanistan
AF
Albania
AL
Algeria
DZ
American Samoa
AS
Andorra
AD
Angola
AO
Anguilla
AI
Antigua and Barbuda
AG
Argentina
AR
Armenia
AM
Aruba
AW
Australia
AU
Austria
AT
Azerbaijan
AZ
Bahamas
BS
Bahrain
BH
Bangladesh
BD
Barbados
BB
Belarus
BY
Belgium
BE
Belize
BZ
Benin
BJ
Bermuda
BM
Bhutan
BT
Bolivia
BO
Bonaire
XB
Bosnia and Herzegovina
BA
Botswana
BW
Brazil
BR
Brunei
BN
Bulgaria
BG
Burkina Faso
BF
Burundi
BI
Cambodia
KH
Cameroon
CM
Canada
CA
Canary Islands
IC
Cape Verde
CV
Cayman Islands
KY
Central African Republic
CF
Chad
TD
Chile
CL
China
CN
Colombia
CO
Commonwealth of Northern Mariana Islands
MP
Comoros
KM
Congo
CG
Cook Islands
CK
Costa Rica
CR
Croatia
HR
Cuba
CU
Curacao
XC
Cyprus
CY
Czech Republic
CZ
Democratic Republic of the Congo
CD
Denmark
DK
Djibouti
DJ
Dominica
DM
Dominican Republic
DO
Ecuador
EC
Egypt
EG
El Salvador
SV
Equatorial Guinea
GQ
Eritrea
ER
Estonia
EE
Ethiopia
ET
Falkland Islands
FK
Faroe Islands
FO
Fiji
FJ
Finland
FI
France
FR
Gabon
GA
Gambia
GM
Georgia
GE
Germany
DE
Ghana
GH
Gibraltar
GI
Greece
GR
Greenland
GL
Grenada
GD
Guadeloupe
GP
Guam
GU
Guatemala
GT
Guernsey
GG
Guinea Republic
GN
Guinea-Bissau
GW
Guyana (British)
GY
Guyana (French)
GF
Haiti
HT
Honduras
HN
Hong Kong SAR, China
HK
Hungary
HU
Iceland
IS
India
IN
Indonesia
ID
Iran
IR
Iraq
IQ
Israel
IL
Italy
IT
Cote D Ivoire
CI
Jamaica
JM
Japan
JP
Jersey
JE
Jordan
JO
Kazakhstan
KZ
Kenya
KE
Kiribati
KI
Kosovo
KV
Kuwait
KW
Kyrgyzstan
KG
Laos
LA
Latvia
LV
Lebanon
LB
Lesotho
LS
Liberia
LR
Libya
LY
Liechtenstein
LI
Lithuania
LT
Luxembourg
LU
Macao SAR, China
MO
Madagascar
MG
Malawi
MW
Malaysia
MY
Maldives
MV
Mali
ML
Malta
MT
Marshall Islands
MH
Martinique
MQ
Mauritania
MR
Mauritius
MU
Mayotte
YT
Mexico
MX
Micronesia
FM
Monaco
MC
Mongolia
MN
Montserrat
MS
Morocco
MA
Mozambique
MZ
Myanmar
MM
Namibia
NA
Nauru
NR
Nepal
NP
Netherlands
NL
Nevis
XN
New Caledonia
NC
New Zealand
NZ
Nicaragua
NI
Niger
NE
Nigeria
NG
Niue
NU
North Korea
KP
North Macedonia
MK
Norway
NO
Oman
OM
Pakistan
PK
Palau
PW
Panama
PA
Papua New Guinea
PG
Paraguay
PY
Peru
PE
Philippines
PH
Poland
PL
Portugal
PT
Puerto Rico
PR
Qatar
QA
Republic of Ireland
IE
Republic of Moldova
MD
Republic of Montenegro
ME
Reunion, Island of
RE
Romania
RO
Russia
RU
Rwanda
RW
Samoa
WS
San Marino
SM
Sao Tome and Principe
ST
Saudi Arabia
SA
Senegal
SN
Serbia
RS
Seychelles
SC
Sierra Leone
SL
Singapore
SG
Slovakia
SK
Slovenia
SI
Solomon Islands
SB
Somalia
SO
Somaliland
XS
South Africa
ZA
South Korea
KR
South Sudan
SS
Spain
ES
Sri Lanka
LK
St. Eustatius
XE
St. Helena
SH
St. Kitts
KN
St. Lucia
LC
St. Maarten
XM
St. Vincent
VC
St. Barthélemy
XY
Sudan
SD
Suriname
SR
Swaziland
SZ
Sweden
SE
Switzerland
CH
Syria
SY
Tahiti
TI
Taiwan, China
TW
Tajikistan
TJ
Tanzania
TZ
Thailand
TH
Timor Leste
TL
Togo
TG
Tonga
TO
Trinidad & Tobago
TT
Tunisia
TN
Turkey
TR
Turkmenistan
TM
Turks and Caicos Islands
TC
Tuvalu
TV
Uganda
UG
Ukraine
UA
United Arab Emirates
AE
United Kingdom
GB
United States of America
US
Uruguay
UY
Uzbekistan
UZ
Vanuatu
VU
Vatican City State
VA
Venezuela
VE
Vietnam
VN
Virgin Islands (British)
VG
Virgin Islands (US)
VI
Yemen
YE
Zambia
ZM
Zimbabwe
ZW
Back to Top