The shelf that lies
A pharmacist is asked for a common medicine. The system says there are forty units in stock. The shelf has twelve. Or the shelf has plenty, but the batch at the front expires next month while a fresher batch sits behind it. Either way, someone has to guess, and in a pharmacy a guess has consequences that a shortage of stationery never does.
Pharmacy inventory looks like ordinary stock control. It is harder, for reasons worth understanding before choosing or building a system.
What makes it different
Most retail stock is interchangeable: one tin of tomatoes is the same as another. Medicines are not. Each unit belongs to a batch, and each batch has an expiry date, a supplier and sometimes storage requirements. Two boxes of the same product can have very different value to the pharmacy, because one may have six months of life left and the other six weeks.
So the real unit of inventory is not the product but the product in a batch. A system that tracks only totals cannot tell you what is about to become waste, or which batch to dispense first.
Other differences add up:
- Expiry is a hard deadline. Expired stock cannot be sold or dispensed. It is a pure loss, and in some settings it must be disposed of in a documented way.
- Some medicines are controlled. They require stricter records of who received what, in what quantity, with reconciliation that matches the register.
- Demand is lumpy. Seasonal illness, a clinic's prescribing habits or a single large prescription can swing consumption.
- Supply is unreliable. In many markets, stock-outs and delayed deliveries are routine, which tempts pharmacies to over order and then hold stock that ages.
The failures we see in principle
Three patterns recur wherever inventory is managed loosely.
First, the count drifts away from reality. Stock is dispensed without being recorded, or received without being checked in. The system number becomes folklore, and staff stop trusting it, which accelerates the drift.
Second, expiry is found by accident. Without batch level visibility, the only way to discover short dated stock is to walk the shelves. Things get missed.
Third, ordering is by instinct. Reorder decisions based on memory lead to both shortages and surplus, often in the same week.
What a good system does
Receiving should capture batch number and expiry at the door, when the box is in hand. Dispensing should suggest the batch that expires first, a rule often called first expiry, first out. Stock counts should be quick enough to do regularly, in small cycles by shelf or category, rather than a dreaded annual exercise.
Alerts should be few and meaningful: items nearing expiry within a window the pharmacy chooses, items below a reorder level that reflects real consumption, and discrepancies between counts and records. Reports should help a pharmacist decide what to order, what to return to suppliers where terms allow, and what to move between branches.
For hospital pharmacies, linking dispensing to the prescription and the patient record closes the loop. Stock leaves because something was prescribed, and that link is what makes discrepancies explainable.
Start simple, stay honest
Barcode scanning reduces typing and errors, but only if products and batches are scanned consistently. A modest system used every day beats an elaborate one used when convenient. Begin with accurate receiving and dispensing, add regular cycle counts, and let the data show you where the waste actually is. Trust in the number is the real asset, and everything else follows from it.