Opening Inventory for a New Independent Pharmacy: A Method
How to build a new pharmacy's opening order from local prescriber and payer mix, check dating on the first delivery, and set reorder points from real fills.
ShelfLifePro Editorial Team
Inventory management insights for retail and pharmacy
The biggest check you'll write before your first fill
Your shelves are built, the license is on the wall, and the software is set up. Now you have to fill the bays. The opening order is the biggest single purchase a new pharmacy makes, and you make it with no dispensing history at all.
That's exactly why it's the easiest place to buy dead stock. Every line you guess wrong sits there for months, ties up cash you need for payroll, and slowly gets closer to its expiry date. Opening inventory for a new independent pharmacy shouldn't be a wish list. Treat it as a hypothesis you'll test against real fills.
Why opening orders turn into dead stock
The mechanism is simple. You don't know what your patients will need yet, so you buy "just in case." Each just-in-case bottle looks harmless on its own. Add up a few hundred of them and you've got shelves of product that nobody nearby prescribes.
Then there's the starter list. Your primary wholesaler may hand you a suggested opening package built from national or regional dispensing data. That's a reasonable place to start, but it describes an average pharmacy, not yours. A store next to a pediatric practice and a store next to a cardiology group need very different shelves.
The third trap is pack size. Picture a typical new store ordering the big bottle of a slow generic because the per-unit cost looks better. If you dispense a couple of fills a month, that bottle can outlive its dating, and the "savings" end up as a return to a reverse distributor or a write-off.
Start from who will write and who will pay
Before you look at a single NDC, map your demand. Two questions drive almost everything:
- Who will prescribe? List the practices within your realistic catchment: family medicine, internal medicine, pediatrics, OB/GYN, psychiatry, urgent care, dental, any specialists. Visit them. Ask the office managers which pharmacies they send to now and which drugs keep causing callbacks for being out of stock.
- Who will pay? Find out which PBM networks and Medicare Part D plans dominate your area, and whether there's a big Medicaid population. Payer formularies decide which generic or brand actually gets dispensed. Stocking a brand that the main local plans won't cover is money on a shelf.
Put those two lists together and you get a rough shape: the therapeutic classes you'll fill a lot, the ones you'll fill sometimes, and the ones you'll hardly ever see. The brand-versus-generic side of this gets more detail in our guide to generic and brand formulary inventory.
A tiered opening list
Don't think of the opening order as one list. Break it into tiers, each with its own buying rule.
Tier 1: high-confidence maintenance drugs. These are the chronic meds your prescriber map says you'll fill every week: common antihypertensives, statins, diabetes drugs, thyroid, and so on. Stock these properly, in pack sizes that match how fast you expect to dispense them.
Tier 2: likely but uncertain. Acute meds and maintenance drugs tied to one or two specialists who may or may not send you patients. Buy the smallest sensible pack. Your wholesaler delivers often enough that running out of a tier-2 item for a day is a minor inconvenience, not a crisis.
Tier 3: must-have slow movers. Some items have to be on hand even though they rarely move, such as emergency meds, antidotes, or anything your state board or local hospital discharge patterns make essential. Keep one unit, track its dating closely, and accept the occasional write-off as a cost of being a real pharmacy. There's more on this trade-off in the slow movers a pharmacy must stock.
Tier 4: everything else. Don't stock it. Order it when the prescription comes in. The rule for a new store is to buy narrow at the start and go deep later, once fills show you where the depth belongs.
Get the free expiry-tracking spreadsheet
Batch-level rows, days-left and status formulas, colour-coded alerts, and a live value-at-risk summary. Works in Excel and Google Sheets. See what's inside.
Instant download. No spam, unsubscribe in one click.
Dating on the opening delivery
This is the step people skip because the delivery shows up during the busiest week of the build-out. It's also the step that decides whether you start on fresh stock or someone else's short-dated leftovers.
A big opening order is an easy spot for a supplier to clear older lots. Nobody has to act in bad faith for this to happen. The picker just pulls whatever is at the front. You won't know unless you check.
Here's how to check the opening delivery:
- Agree on a minimum remaining shelf life in writing before the order ships, and ask what happens to lines that arrive under it.
- Check dating line by line at receiving, not a week later. Record lot and expiry for every line, ideally by scanning the 2D barcode rather than typing it in. Our post on capturing expiry dates at receiving walks through the rules.
- Flag short-dated lines immediately and request credit or exchange while the invoice is still open.
- Keep the transaction data that comes with each shipment. Under the Drug Supply Chain Security Act, dispensers have to receive and keep transaction information for the product they buy, so your receiving process has to handle that paperwork from day one.
If you want a simple place to log lot and expiry while you're still finding your feet, the expiry-tracking spreadsheet template works for a first pass.
The first two months of fills
Don't set reorder points on opening day. You don't have data yet, and any number you type in is the same guess that built the opening order.
Instead, run the first couple of months on short, frequent wholesaler orders and watch the fills. By the end of that window you'll see which tier-1 assumptions were right, which tier-2 items turned out to be steady sellers, and which opening lines haven't moved at all.
Worked example: say you opened with a large bottle of a generic antihypertensive and a small pack of a tier-2 antidepressant. After two months the antihypertensive has barely moved because the cardiology group you were counting on still sends patients elsewhere, while the antidepressant has refilled every week thanks to a psychiatry practice you hadn't mapped. Your reorder point for the antidepressant should come from those real weekly fills. The antihypertensive gets no reorder point until it moves, and you watch its dating.
Then set reorder points from actual sell-through plus your real wholesaler lead time. The arithmetic is laid out in our sell-through reorder point method, and the bigger picture of matching purchases to turns is in optimizing pharmacy purchasing around inventory turns.
Last step: go back to the opening-order lines that haven't moved. Check whether they can be returned to the wholesaler while they're still in date. Every week you wait makes that return harder.
Paper, spreadsheet, or software
You can run all of this on paper or in a spreadsheet. A notebook handles the prescriber map, the tier list, and a receiving log fine. Being careful about pack sizes doesn't take software, and a spreadsheet can sort lots by expiry date.
Where manual tracking struggles is the follow-through. Nobody re-sorts the spreadsheet on a busy Monday. Opening-order lines that aren't moving don't speak up on their own. And comparing two months of fills against a few hundred opening lines by hand is the kind of job that gets put off until the first expired bottle turns up in a cycle count.
So whatever you use, give it three jobs: record lot and expiry at receiving, show which opening lines haven't moved, and warn you about short dating while there's still time to return the stock.
How much expired stock is on your shelves right now?
Upload your stock register or purchase CSV. ShelfSense reads the batch expiry dates and shows what is expiring soon, what has already expired, and what to return first. 60 seconds, no signup.
Run the free pharmacy auditGetting the pharmacy open clean
A clean opening order is narrow, built from local prescribers and payers, checked for dating at the door, and adjusted after real fills. That beats a full-looking shelf that's half guesswork.
If you'd rather not build the expiry side yourself, ShelfLifePro serves independent pharmacies and tracks dating by lot from your first delivery. Every plan comes with a 14-day free trial, no credit card required, so you can run it during your opening weeks and see whether it fits. Start at our pharmacy page.
ShelfLifePro Editorial Team
The ShelfLifePro editorial team covers inventory management, expiry tracking, and waste reduction for pharmacies, supermarkets, and retail businesses worldwide.
One question, optional
What would stop you from trying ShelfLifePro?
See what batch-level tracking actually looks like
ShelfLifePro tracks expiry by batch, automates FEFO rotation, and sends markdown alerts before stock expires. 14-day free trial, no credit card required.
Prefer to talk it through? Book a 30-min call
The monthly expiry-tracking brief
One short email a month, only when there is something worth reading. FEFO tactics, markdown math, and real-world waste-reduction wins. Unsubscribe anytime.
No spam. Unsubscribe in one click.