Excel for a store: which product is out
A store stockout list is one row per product on the shelf. The quantity you type is what you counted. The minimum you type is the level you chose. IF marks the row out when the count is zero, and low when the count is above zero but under that minimum. COUNTIFS counts the rows marked out. A delivery log, one line per carton received, is a different sheet. This list is what you open before the shop opens, to see what a customer cannot buy. You do not rebuild the receiving history here. The guide below is that list. Elyx writes the flag from the numbers you typed. You still decide what to reorder. The trial lasts 7 days, with no card.
- The stockout list
- An inventory tracker, if you want the wider file
- Goods receipt, if the work is the warehouse rather than the shop floor
Frequently asked questions
What is one row on the stockout list?
One product in this store: the code, the name, the quantity you counted, and the minimum you typed. The flag compares those two numbers.
Where do deliveries go?
On a receipt sheet, one line per delivery. When the shelf count changes, type the new quantity on this list. Do not paste every carton onto the list.
Does the sheet know what you will sell tomorrow?
No. You type the minimum. The formula only compares the count you typed with that minimum, and with zero.