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; all other columns/data are optional.
Columns with unrecognized names in the header are ignored.
Column names below ending with a % indicate that only the first part of the name must match. For example Tariff% will match TariffCode
WgtUnit, VolUnit, OtherUnit, HSCode, PackType, ManufCtry, SuppCtry and Currency codes must be valid codes if specified.
| ProductCode or Code | Product code (required) |
|---|---|
| Description | Product description (required) |
| Items | Number of items per unit |
| BulkUnit | Order unit code if bulk product, eg kgm |
| Weight% | Weight per unit |
| WgtUnit | Weight unit, eg kgm (default = kgm) |
| Volume% or Cubic | Volume/capacity per unit |
| VolUnit | Volume unit, eg ltr (default = mtq) |
| OtherMeasure | Other measure per unit |
| OtherUnit | Other unit, eg mtk |
| Tariff% or HSCode | WCO Harmonised System classification (tariff) eg 4510.30 or 4510.30.00 or 4510.30.00.00A |
| ManufName | Manufacturers name |
| ManufStreet | Manufacturers street address |
| ManufStreet2 | Manufacturers street address continued |
| ManufCity | Manufacturers city |
| ManufRegion | Manufacturers region/state |
| ManufCtry or Origin | Manufacturers country/origin country, eg CN |
| Brand% or Marks | Brand name and/or package marks |
| PackType | Package type, eg CT |
| PackMaterial | Packaging materials description |
| Supplier% or NFSPurchFrom | Supplier’s short name |
| ReplProduct | Product code of product replacing this one |
| UnitPrice | Price |
| Currency | Price currency, eg USD |
| Status | N=Not for sale product, D=Discontinued product |
| SuppProductCode | Suppliers product code |
| InvoiceCode | Invoice code (for split invoicing/shipment) |
| SuppCtry | Suppliers country |
| SecondaryCode | Used to apply qualifiers applicable to the TSW declaration. For NZ, a duty concession code can be stated. |