Converted products

hi

the conversion table is literally the product name as it goes through the till, what the product is called in the cellar stock and what the till product converts to as part of the cellar product.  For the below-  Till Product in the left hand column (as labelled in original post), Cellar product in the middle, conversion rate as the number.  So looking at the below, a measure of rum is 0.035.... of a bottle, Guinness Pint is 0.0056... of a keg

Therefore if i sell 10 pints of guinness, it wll equate to 0.056... of a keg in the cellar stock.

All these calculations have been made previously and come from a CSV doc.

The sales data - at present this is just a made up table, but will ultimately feed from an API connection with the tills -there are around 250 tills so this is just a very small test.  All i need from the data, however, is as below.  At present this is a CSV doc.

Let me know if you need anything else, and thanks for replying.