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 item to you 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
The Stock Feed module.