6 min read
Expiry is the hardest part of running a pharmacy
Stock that expires on the shelf is money that was already spent. Here is why it is so hard to see coming, and what a system has to know to warn you in time.
Read moreProduct5 min read
Most inventory systems count boxes. A pharmacy needs to count batches — and the difference decides whether a recall takes ten minutes or a weekend.
By Stock Sewa Team
“Batch tracking” appears on almost every inventory system’s feature list, and it means at least three different things depending on who wrote the list. The differences are not academic — they decide what you can answer when something goes wrong.
Level one: a batch number field. The product record has somewhere to type a batch number. It is a note. Quantities are still held against the product, so the field tells you what the last batch was called and nothing else. Most systems that advertise batch tracking stop here.
Level two: batches as stock records. Quantity lives on the batch, not on the product. Two hundred units of a product might be four batches of fifty, each with its own expiry date and its own purchase cost. The product’s stock figure becomes a sum rather than a stored number.
Level three: batches through the sale. Selling decrements a specific batch, and the sale record remembers which one. This is the level that costs real engineering effort, and it is the level that makes the other two worth having.
A recall notice arrives naming a manufacturer’s batch. At level one you know you might have bought it. At level two you know whether you still have it on the shelf. Only at level three can you answer the question that actually matters: who did we sell it to?
The same distinction drives ordinary commercial questions. If two batches of the same product were bought at different prices, your true margin depends on which one went across the counter. Sell the cheaper batch and report against the newer cost and your margin is wrong in a direction that flatters you.
Batch-level stock is more work at the point of entry. Receiving a delivery means recording batch numbers and expiry dates, not just quantities. There is no way to avoid this — the information has to enter the system at the only moment anyone is holding the physical box.
What you can do is make that moment fast: default the batch from the last purchase of the same product, accept the expiry in the format printed on the strip, and never make someone type a product name they have already scanned. Good software does not remove the data entry; it removes everything around the data entry.
The payoff is that every later question — expiry exposure, true margin, recall scope, valuation — is answerable from records you already have, instead of a stock-take and an afternoon of guessing.
Running a pharmacy or a church office and recognise any of this? Tell us how you work today — stocksewa01@gmail.com.
6 min read
Stock that expires on the shelf is money that was already spent. Here is why it is so hard to see coming, and what a system has to know to warn you in time.
Read more7 min read
A counter cannot stop selling because the internet did. What it takes to build software that keeps working through an outage and reconciles cleanly afterwards.
Read more5 min read
Treasurers do not want a dashboard. They want to close the month, answer a question from the committee, and be trusted with the answer.
Read more