The file must be a CSV (comma separated values) or Text (tab delimited). You can use the Save As option in your spreadsheet application to export as one of these formats.
The order of the columns does not matter but the file must have a header as the first row and the following column names in the header are recognised.
ProductCode and Description columns (with data) are required always; Qualifier1Type is a required column (data optional); all other columns/data are optional.
Columns with unrecognised names in the header are ignored.
Qualifier1Type must be present and a valid type.
Qualifier2,3Type are optional but if specified must also be a valid type.
ProductCode or Code | Product code (required) |
|---|---|
| Description | Product description (required) |
| OverrideDescription | Y to indicate that the classified product description should be used for declaration lines (overriding the consignment product description) |
| SupplierTswCode | The supplier's code for TSW |
| Tariff | Tariff or H/S Code |
| ManufCtry | Manufacture country code - only required if qualifiers are country specific |
| ManufRegion | Manufacture region code |
| Qualifier1Type | e.g. EXM (required) |
| Qualifier1Code | e.g. OZO |
| Qualifier1RefNo | |
| Qualifier1Details | |
| Qualifier2Type | e.g. PER |
| Qualifier2Code | e.g. MPI |
| Qualifier2RefNo | e.g. AF900574743 |
| Qualifier2Details | |
| Qualifier3Type | e.g. DTC |
| Qualifier3Code | |
| Qualifier3RefNo | e.g. 343243A |
| Qualifier3Details | |
| Qualifier4Type | 4th qualifier type |
| Qualifier4Code | |
| Qualifier4RefNo | |
| Qualifier4Details | |
| Qualifier5Type | 5th qualifier type |
| Qualifier5Code | |
| Qualifier5RefNo | |
| Qualifier5Details |