CSV File with Product Stock Levels Data
Product Stock Levels data is sent from CStoreOffice® into the CSV file which has the following structure:
Field Name | Type | Description |
Header data | ||
Product Code | String |
The product code (PLU code) used to identify the product. |
Stock Level | Integer |
The stock count for this product as determined by the back office application. |
Stock Calculation Flag | Integer |
Flag to indicate whether the POS should calculate the actual stock on hand based on the stock level passed from the back office application. This means whether the POS should include sales/refunds that have occurred for this product since the point that the back office interface last processed transactions from the POS. 1: Calculate actual stock levels based on the stock level passed in this message and the last transaction field. 0: Do not do any calculation of the stock levels. Use the stock level in this message as-is. |
Last Transaction ID | Integer |
When the stock calculation flag is set to 1, the back office application must supply the last transaction ID that has been processed from the POS. This will indicate to the POS from which point the stock calculation based on sales must take place. |
Last Shift ID | Integer |
When the stock calculation is 1, the back office application must supply the last shift period ID that has been processed from the POS. This will be used for debugging purposes if there are any synchronization issues. |
Product Stock Type | Integer |
Flag to indicate whether the product is stockable or non-stockable. If the product is specified as non-stockable then the POS will stop updating the product stock inventory levels.
When this flag is set to non-stockable, the other stock related fields will be ignored. |