How to manage pharmacy OTC inventory efficiently

The OTC inventory blind spot

Most pharmacy chains run two parallel worlds. The back office sees what was sold through the POS. The counter sees what was asked for — including every symptom, every recommendation the pharmacist made, and every basket that walked out empty because the right SKU was out of stock. Inventory systems are calibrated on the first signal and almost never on the second.

That gap is the single largest source of OTC waste and lost revenue. Expiry write-offs pile up on slow movers stocked at the same depth as fast movers. Substitutions hide stock-outs from reorder logic. Promotional pulls aren't anticipated because demand spikes look like noise instead of intent.

The five levers that actually move OTC inventory KPIs

1. Demand at the counter, not just at the till. Capture structured intake from every patient interaction — symptoms, requested category, recommended SKU, and whether the recommendation converted. Sales data alone undercounts demand by every basket that was substituted or abandoned.
2. Velocity-weighted cycle counts. Replace the once-a-quarter physical count with a weekly cycle count scoped to the top decile of moving SKUs. Use intake data to flag categories where on-shelf availability is silently dragging conversion.
3. Expiry buckets by margin, not by aisle. Group SKUs by margin band and days-to-expiry, then trigger discount, rotation, or return-to-supplier actions automatically as items cross thresholds. The cost of a write-off compounds the longer the SKU sits.
4. Pharmacist-validated forecasts. The most accurate forecasting signal in a pharmacy is the pharmacist's confirmed recommendation. Use it as a first-class input alongside POS history — it's smaller in volume but vastly higher in intent quality.
5. Replenishment that closes the loop with the supplier. Push demand-validated reorder signals upstream. Suppliers can collapse lead time when the order arrives with confidence scoring, not just last month's sell-through.

Why the pharmacist-in-the-loop changes the math

Automating inventory without the pharmacist is how chains end up over-rotating fast movers and starving long-tail categories that drive basket value. A pharmacist who validates every recommendation produces a clean stream of structured demand data — and unlike raw POS data, that stream carries intent: what the patient wanted, what was offered, what was accepted, and why a substitution happened. Feed that into your inventory engine and three things change:

• Forecasts pick up demand earlier — recommendation volume leads sell-through by days or weeks for seasonal categories.
• Substitutions stop hiding stock-outs — every swap is logged with the requested SKU, so reorder logic sees real demand for the missing item.
• Slow movers get rationalized faster — categories where the pharmacist consistently recommends a substitute are candidates for delisting or repositioning, not deeper stocking.

A 30-day pilot plan

1. Week 1 — Instrument intake. Add structured capture at the counter and the kiosk: requested category, recommended SKU, validation outcome, substitution reason. Don't change reorder logic yet — just collect.
2. Week 2 — Reconcile to POS. For each high-velocity category, compare recommended baskets to confirmed sales. The delta is your hidden demand signal.
3. Week 3 — Re-stratify SKUs. Rebuild the ABC classification using recommendation volume, not just sell-through. Expect 5-15% of SKUs to move bands.
4. Week 4 — Adjust min/max and run the first velocity-weighted count. Push the new thresholds into your replenishment system and measure write-off avoidance and on-shelf availability against the baseline.

Metrics that prove it's working

• Expiry write-off rate (target: -30% within two quarters).
• On-shelf availability on top-decile OTC SKUs (target: 98%+).
• Recommendation conversion — share of pharmacist-recommended SKUs that convert at the till.
• Stock-turn on the long tail — the categories where rationalization pays the most.

Where Phaimy fits

Phaimy is the OTC infrastructure layer between patient intake and the pharmacy's inventory and POS systems. Kiosk and mobile intake capture structured symptoms and requests; the pharmacist cockpit validates every recommendation; the resulting data stream feeds inventory and basket intelligence — closing exactly the loop described above. Pharmacies running on Phaimy don't have to choose between automation and pharmacist judgment; the pharmacist is the system.

See how Phaimy works for pharmacy networks →