Specifications
Filename | StockFeedInit.csv |
Frequency | Once per day at 06:00 am |
Content | All active items |
Format | CSV | TAB separated | no text qualifiers | UTF-8 |
Filename | StockFeedIncremental.csv |
Frequency | Every 15 minutes |
Content | Only the items that differ from the StockFeedInit.csv |
Format | CSV | TAB separated | no text qualifiers | UTF-8 |
Content
Column names in csv file |
Explanation |
Data Types |
Itemcode | Item code Info (never changes) | varchar(30) |
Barcode | Barcode | varchar(13) |
Price | Purchase price | varchar(9) |
StockINT | Internal (shelf) stock | varchar(8) |
DeliveryDaysINT | Delivery time (days) (1 = tomorrow, 2 = the day after etc.) | varchar(15) |
StockEXT | External (shelf) stock | varchar(8) |
DeliveryDaysEXT | Delivery time (days) (1 = tomorrow, 2 = the day after etc.) | varchar(15) |