Pharmacy inventory management in Pakistan: batches, expiry control and traceability

Why batch-level stock control matters

A pharmacy can have hundreds or thousands of medicine packs on its shelves. Some products move every day. Others remain in a drawer or on a back shelf for weeks. When stock is recorded only by product name and total quantity, the pharmacy may know that it has 40 packs of a medicine, but not which batch those packs belong to or when each batch expires.

That gap becomes serious when an expiry date is missed or a manufacturer issues a recall for a specific batch. A pharmacy may need to identify every affected pack, check stock at each branch, stop further sale, and follow the supplier’s or regulator’s instructions. If batch details were never recorded, staff may have to search invoices, cartons and shelves manually.

Pharmacy inventory management is more than counting boxes. It is the process of recording what was received, which batch it belongs to, where it is stored, what has been sold, what is nearing expiry and what must no longer be supplied.

For Pakistani pharmacies, a clear stock process matters during routine days and busy periods such as Ramadan, Eid and seasonal illness peaks. A digital system can help organise records, but the system is only as reliable as the information entered by staff.

If you are comparing pharmacy inventory management software in Pakistan, it helps to understand the process first. This guide therefore moves from batch records and expiry control to barcode scanning, staff permissions, expiry-loss calculation in Pakistani Rupees (PKR), supplier ordering and reporting, and then to the questions worth asking before you choose a system.

This guide explains practical inventory controls, FEFO, expiry reviews, whole-lot recall preparation, barcode scanning, staff accountability, supplier ordering and inventory reporting. It is operational guidance, not legal, clinical or regulatory advice. PKR figures in examples are illustrative and are not market prices.

Why pharmacy stock is hard to control

The same medicine can exist in several batches

A pharmacy may receive the same brand and strength from a supplier more than once. The new delivery may have a different batch number and expiry date from the stock already on the shelf. If staff add every pack to one product total, the system may show the combined quantity but hide the difference between batches.

For example, a pharmacy could hold 12 packs from Batch A expiring in February and 30 packs from Batch B expiring in November. A simple stock count of 42 packs does not tell staff which batch should be sold first or which packs may be affected by a recall.

Common inventory problems

• Expiry dates are checked only when staff physically notice a pack near its expiry.
• New deliveries are entered as product totals without batch or lot details.
• Stock in the shop, store room and godown is combined into one number.
• Returns are placed back on shelves before their condition and batch are checked.
• Staff rely on memory, handwritten notes or separate spreadsheets.
• During a recall, the team cannot quickly identify whether the named batch is still in stock.

These problems can lead to avoidable write-offs, stock discrepancies and delays when a supplier or regulator asks the pharmacy to check a product. The answer is not simply to buy software. The pharmacy first needs a consistent receiving, selling, checking and escalation process.

Record every batch when stock arrives

What should be captured at receiving?

When a medicine delivery arrives, staff should compare the physical goods with the supplier documentation and the pharmacy’s purchase record. The product name alone is not enough for batch-level control. Capture the batch or lot number and expiry date for each batch received, along with the quantity and relevant purchase reference.

• Product name, strength and pack size.
• Manufacturer or supplier details, as shown on the product and documents.
• Batch or lot number exactly as printed on the pack.
• Expiry date exactly as printed on the pack.
• Quantity received for that batch.
• Date received and the relevant invoice or delivery reference.
• Receiving location, such as the front shop, back store or godown.

Do not merge different batches

If one delivery contains two batches of the same medicine, record them as separate batch entries. Do not overwrite the first expiry date with the second one. If a pack label is damaged or a batch number cannot be read, follow the pharmacy’s quality procedure and contact the supplier rather than guessing.

Why receiving discipline matters

A recall can only be handled efficiently if the pharmacy can connect the product on the shelf to its batch record. Correct receiving data creates the starting point for that connection. If the batch number is missing at the beginning, later software reports cannot reliably recreate it.

Practical rule: record batch and expiry information at the point of receiving, not during a later stock-count exercise.

Expiry date control and FEFO

What is FEFO?

FEFO means First Expiry, First Out. It is a stock-rotation method in which the batch with the earliest expiry date is selected first, provided the product is suitable for sale and all required checks are met. FEFO is different from FIFO, or First In, First Out. FIFO prioritises the oldest received stock; FEFO prioritises the earliest expiry.

The World Health Organization’s Good Distribution Practices guidance says systems should ensure pharmaceutical products due to expire first are sold or distributed first, with controls to prevent expired products from being distributed. DRAP’s Good Distribution Practices guidance also discusses FEFO stock rotation and handling products nearing expiry.

Build a regular expiry review

• Review near-expiry batches on a planned schedule, such as weekly or monthly, based on the pharmacy’s risk and stock volume.
• Sort the list by earliest expiry date.
• Physically verify the listed batch and quantity on the shelf.
• Follow supplier return terms and internal approval processes where stock may be eligible for return.
• Remove expired or otherwise non-saleable stock from normal saleable inventory and handle it under the pharmacy’s approved procedure.
• Record any write-off or other final action with the batch details.

Alerts are reminders, not a substitute for checks

An expiring-soon alert can help staff notice a batch before its expiry date. It does not replace physical verification, appropriate storage, professional judgement or the pharmacy’s documented procedures. Staff should also check that the expiry date was entered correctly when the delivery arrived.

Traceability: can you find where a batch went?

The key questions during a recall

When a supplier names Batch X, the pharmacy needs to answer: Do we still have this batch? Which branch has it? How much is on hand? Was any of it returned, written off or transferred? Can staff identify the relevant purchase record? These questions are difficult to answer when batch details are stored only on paper or on the original carton.

Keep batch information connected to stock movement

At minimum, the pharmacy’s process should preserve the batch identity when stock is received, moved, counted, returned or written off. If stock moves from a godown to a shop, the batch and expiry details should remain clear at the receiving location. Staff should not combine two batches simply because the product name and strength match.

A simple batch register

• Product and strength
• Batch or lot number
• Expiry date
• Supplier and purchase reference
• Quantity received
• Current quantity by location
• Quantity sold, transferred, returned or written off, where records are available
• Recall or quality action reference, if applicable

The exact records a pharmacy must retain, the retention period and any mandatory reporting depend on applicable requirements and the pharmacy’s role in the supply chain. Confirm these matters with the relevant authority, supplier and qualified compliance adviser.

Test the process before an actual recall

Choose a sample batch and ask a staff member to locate it without help. Check whether they can find the batch in the record and on the shelf, identify each location that holds it and explain how it would be separated from saleable stock. A short practice exercise can expose missing data before a real alert arrives.

Multiple branches, returns and write-offs

Stock at the shop and godown

Many pharmacies keep fast-moving medicines near the counter and additional stock in a back room or godown. A branch may also transfer products to another branch when demand changes. If the business records only a combined stock figure, staff may know the total quantity but not where the affected batch is located.

Location-wise inventory helps the team distinguish stock held at each place. A stock transfer process should identify the sending location, receiving location, product, batch and quantity. Staff should verify the receiving record after the movement is completed.

Returns need batch checks too

A customer return or supplier return should not automatically be placed back into saleable stock. Staff should follow the pharmacy’s return and quality procedure, verify the product condition and batch identity, and record the final decision. The same principle applies to damaged, recalled or expired items.

Write-offs should leave a record

A write-off records stock removed from usable inventory because it cannot be sold or used under the business’s approved process. Record the product, batch, expiry, quantity, reason, date and authorisation according to internal policy. This helps explain why the physical count differs from the system quantity.

DRAP’s Good Distribution Practices guidance discusses keeping quarantined stock separate from approved stock and maintaining records of quarantined products. A pharmacy should confirm the exact controls that apply to its operation and make sure affected stock cannot be accidentally selected for sale.

Frequently asked questions