Generic CSV Feed File Format

Back Top Prev Next Print

The generic CSV format (Jim2 Generic) must follow the conventions outlined below:

▪The first row of the file must contain the column headers.

▪The first column must be the supplier's stock code.

▪If data is not to be included in the feed, the relevant column should be left blank.

▪The following columns are supported:

Stock Code

Supplier's stock code

ShortDesc
The stock's short description.

Desc
The stock's long description.

SupplierPrice
The price the supplier will sell the stock for, excluding GST.

RRPInc
The recommended retail price, including GST.

Brand
The product brand or manufacturer.

ManufPartCode
The manufacturer's part code.

StockGroup1
The level 1 stock group name.

StockGroup2
The level 2 stock group name.

StockGroup3
The level 3 stock group name.

StockGroup4
The level 4 stock group name.

StockGroup5
The level 5 stock group name.

An example feed file content is below:

Stock Code,ShortDesc,Desc,SupplierPrice,RRPInc,Brand,ManufPartCode,StockGroup1,StockGroup2,StockGroup3,StockGroup4,StockGroup5

Stock1,'The short description','This would be the long description',12,15,Brand,Partcode1,Group1,Group1.1,Group1.1.1,

Stock2,'The short description (Stock2)','This would be the long description (Stock2)',17,20,Brand,Partcode2,Group2,Group2.1,Group2.1.1,

Further information