A Simple Stock Tracker That Matches Your Shelf Count

Ask most small shop owners how confident they are in their stock count and the honest answer is "roughly." Not because nobody's counting — because somewhere between the register, a notebook, and a spreadsheet someone edited by hand, the number on paper and the number on the shelf quietly drift apart. By the time it's noticed, nobody can say exactly when or why.

The one design choice that causes most of the drift

In a typical spreadsheet, the stock quantity is just a cell — anyone can type a new number into it directly. That's convenient for a quick fix, and it's also exactly how a count quietly goes wrong: a correction that was supposed to be temporary sticks, two people update the same cell at different times and one overwrites the other, or a number gets typed into the wrong row. None of it looks like an error. It just looks like a number, sitting there, slowly disconnected from what's actually on the shelf.

Why "record the movement, not the total" fixes it structurally

The more reliable approach is to never let anyone edit the total directly at all. Instead, every change is recorded as a movement — stock in, stock out, with a note — and the balance is always just the sum of that history. There's no cell to accidentally overwrite, because there's no editable total in the first place. If the shelf count and the system ever disagree, the movement history is right there to check against, not a mystery.

The other common failure: overselling by a few minutes

Even with good intentions, two people working off the same spreadsheet can both issue the last few units of something within minutes of each other, each seeing a count that hasn't caught up yet. Neither did anything wrong — the tool just wasn't built to stop it. A system that locks the item's row for the moment a movement is being recorded, and refuses an issue that would take the balance below zero, closes that gap regardless of how many people are using it at once.

What a purpose-built tracker changes

Our Simple Stock In/Out Tracker is built around exactly this discipline. The item edit screen deliberately has no quantity field — the balance can only ever change by recording a Stock In or Stock Out movement, each with a note for context (supplier, who it was issued to, why). Issuing more than what's actually available is refused with a message showing what's really in stock, and this holds even when two people are recording movements on the same item at the same moment — the item row is locked for that instant, so neither can oversell it.

Each item carries a SKU, unit (pieces, kilos, litres — whatever fits) and a reorder level, and the dashboard shows what's low or out of stock and what moved today, so a quick morning check is enough to catch problems early. Movement history is filterable per item, and an item with any recorded history can't be deleted out from under that history.

It's a stock ledger, not a full inventory or POS system — it doesn't handle purchase orders, suppliers, barcodes, batches or expiry, or multiple warehouses out of the box. For a small shop, workshop or store that mainly needs an honest, tamper-resistant count of what's actually on hand, that's the right amount of tool, and it's plain PHP and MySQL so a developer can extend it if the business grows into needing more.

FAQ

Can someone accidentally edit the stock total directly?

No — there's no quantity field on the item itself to edit. The balance is always the sum of recorded Stock In/Stock Out movements, so there's no single number that can be overwritten by mistake.

What happens if two people try to issue the last units at the same time?

Only one succeeds. The item is locked for the moment a movement is being recorded, so a second, simultaneous request correctly sees the updated balance and is refused if it would oversell.

Does this handle purchase orders or suppliers?

Not in this product — it's a stock-in/stock-out ledger. Movements carry a free-text note where a supplier or reason can be recorded, but there's no separate purchase-order workflow.