CStoreOffice® Support & Learning

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.

  • 0 or blank: Stockable
  • 1: Non-stockable

When this flag is set to non-stockable, the other stock related fields will be ignored.