Cargo supports adding Products for a contact from a file.
The file must be a tab separated text file. To output from an Excel spreadsheet with the correct delimiters you would save the file as 'Text (Tab delimited)'.
The first row of data must contain the column names.
The column names can be in any order but must match those below exactly.
Columns names that are not recognized are ignored.
A column for the product code (ie Code or ProductCode) is required. All other data items are optional.
Names ending with a % indicate that only the first part of the name (the letters preceding the %) must match.
ProductCode or Code
|The unique product code. This is a required field.|
|The product description|
|BulkUnit||The order/invoice units e.g. KGM|
|Weight||Weight (per unit)|
|WgtUnit||Weight units (default = KGM)|
|Volume or Cubic||Volume/capacity (per unit)|
|VolUnit||Volume units (default = MTQ)|
|ClassificationCategory or TariffCode||The classification lookup code|
|ManufStreet||Manufacturers street address|
|ManufStreet2||Manufacturers street address continued|
|ManufCtry or Origin||Manufacturers country/origin country e.g. CN|
|Brand or Marks||Brand name or product markings|
|Package type, e.g. CT|
|PackMaterial||Packaging materials description|
|UnitPrice||Price (per unit in the currency below)|
|Currency||Price currency, e.g. USD|