The Stock levels page provides a table overview of your inventory, including cost price, quantity on hand, total cost, and the total stock value of all inventory combined.
Accessing Stock levels
- Log in to the Inventory module with your Lightspeed credentials.
- From the navigation menu, select Stock management > Stock levels.
- (Optional) Sort the table by Item name, Cost price, Quantity, or Total cost by clicking the column header. Click once for ascending order or twice for descending.
- (Optional) Find specific items using the Search field, or filter items by accounting group using the available drop-down.
- (Optional) Click Export to CSV to download a spreadsheet file that can be opened with your preferred spreadsheet program.
Stock levels columns
|Item name||Name of the item as entered in the Back Office.|
|Cost price||The cost of the item. Note: This is set from the Back Office via Menu management > Items. Receiving purchase orders does not automatically update the cost price.|
|Quantity||The number of items in stock. This value automatically updates when items are sold, purchase orders are received, or when stock counts are completed. Quantity will also adjust accordingly when recipes are made, adding quantity to finished products and removing ingredients.|
||The total cost of the item's combined inventory (Cost price x Quantity).|
Understanding stock conversion rates
Some stock levels are represented by a decimal. This is because stock levels are measured in units (like bottles or boxes), while recipes use dimensional measurements (like milliliters or grams). The Inventory Add-on uses a conversion calculation to reconcile this: Decrease in stock level = Quantity used in the recipe / Total capacity of one stock unit.
To illustrate how this works, let's consider a few examples:
You have a recipe that requires 60ml of olive oil. In your inventory, you've defined a stock unit of olive oil as a 1-liter (1000ml) bottle. When you use 60ml of olive oil for your recipe, the stock count for olive oil will decrease by 60/1000, or 0.06. This means that your olive oil stock will decrease by 0.06 when you make this recipe. If you have 4 bottles of olive oil, your stock level will be reduced to 3.94 once you create a batch (4.00 - 0.06).
- 1000ml bottle of olive oil (1 stock unit) x 4 bottles on hand = 4000ml of olive oil (4 stock units).
- 60ml of olive oil used for recipe / 1000ml = 0.06 stock units.
- 4 stock units on hand - 0.06 stock units used for recipe = 3.96 stock units remaining.
As another example, let's say one unit of flour in your inventory is a 10kg bag, and you have a bread recipe that requires 500g of flour per loaf. When you use 500 grams of flour to prepare the bread, the flour's stock level will diminish by 500/10,000, which is 0.05. If you have 3 bags of flour in stock, your inventory level will be reduced to 2.95 every time you make a single loaf. If you make 5 loaves at once, you'll use five times the amount of flour, or 2500g. As a result, your flour stock level would decrease to 2.75 (3.00 - 0.25).
- 10kg bag of flour (1 stock unit) x 3 bags on hand = 30kg (or 30,000g) of flour (3 stock units).
- 500g of flour used for bread recipe / 10,000g = 0.05 stock units.
- 3 stock units on hand - 0.05 stock units used for recipe = 2.95 stock units remaining.