Your inventory shows 400 packs of a medicine in stock. An order comes in for 150 packs, but the customer needs at least six months of remaining shelf life. One batch expires in four months, another is on hold, and only one can fulfil the order. The total stock figure looks reassuring, but it can’t tell the sales team what the warehouse can actually ship.
Pharmaceutical warehouses can avoid this problem by tracking stock at batch level from receipt through dispatch. That gives sales, warehouse, and quality teams the same view of what’s available, what needs attention, and what has already been shipped. Here’s how to put that into practice.
1. Record each batch separately when stock arrives
Keep one product record for each combination of medicine, strength, dosage form, and pack size. Under that record, track the batch number, expiry date, quantity, storage location, and status of each batch. Use the same product name and code across purchasing, receiving, and dispatch so staff can find the right record without guessing.
At receiving, check the batch number and expiry date printed on the packs against the delivery documents. If a supplier sends 200 packs across two batches, record the quantity for each batch on a separate line. If a label is unreadable or the paperwork shows a different expiry date, set the affected stock aside for review. Record what the receiver found so the next person can investigate the discrepancy without repeating the entire check.
2. Use FEFO to choose which batch to pick first
First Expiry, First Out (FEFO) means picking the earliest-expiring batch that is eligible for the order. A batch that arrived yesterday can take priority over stock received last month if it expires sooner. The EU’s Good Distribution Practice guidelines call for FEFO stock rotation and documentation of exceptions
Consider this stock position on 1 February:
| Batch | Expiry date | Quantity | Status |
| A102 | 31 May | 120 packs | Available |
| B205 | 30 September | 180 packs | Available |
| C307 | 31 December | 100 packs | On hold |
For a 150-pack order, the warehouse could pick 120 packs from A102 and 30 from B205 if both meet the order requirements and the customer accepts two batches. If the customer needs six months of remaining shelf life on delivery in February, B205 can fulfil the entire order. C307 stays out of the pick list while it is on hold.
Calculate remaining shelf life against the expected delivery date. If a shipment is delayed and the batch falls below the customer’s minimum, review the allocation before dispatch. This matters most when an order sits close to the cutoff.
3. Set up shelves and picking instructions by batch
Give each storage location a clear identifier and make batch numbers visible on shelf or pallet labels. If two batches share a location, use clearly marked positions so a picker can tell them apart. Put the batch number, location, expiry date, and quantity on the pick list. A product name alone leaves the picker to decide which stock to take.
At packing, compare the physical batch against the pick list and record the batch actually shipped. If the allocated batch is short at its location, have the picker report the discrepancy before using another batch. The replacement may have a different expiry date or stock status, even if the packs look identical.
4. Use near-expiry reports to make stock decisions
A product can sell steadily while an individual batch stays untouched. Review near-expiry reports by batch and location. For each flagged batch, check the quantity left, expected demand before the applicable cutoff, and the supplier’s return deadline. Assign someone to follow up and give them a date for the decision. If a supplier return is possible, waiting until the packs are almost expired may leave too little time to arrange it.
Stock quantities are only part of that review. If purchasing sees 400 packs on hand but 100 are on hold and 120 are too short-dated for regular customers, its reorder decision should reflect the quantity that can meet demand. Review pending supplier orders too. A shipment due next week can create excess stock if earlier batches are moving more slowly than expected.
5. Keep held and returned stock out of the picking process
A batch can be physically present in the warehouse while it awaits inspection, release, or investigation. Give held stock a status that blocks it from allocation and identify it clearly in the storage area. When the responsible team makes a decision, record who authorised the status change and when. This gives warehouse staff a clear basis for acting on the updated record.
Use the same care with customer returns. Record the batch, quantity, and reason for the return, then route the packs through the applicable assessment process before deciding their disposition. EU Good Distribution Practice guidelines specify conditions for returning medicines to saleable stock and call for near-expiry stock to be withdrawn from saleable inventory.
When evaluating a product testing service germany, clarify how testing and release information will be shared with your team. The warehouse needs to know which batch the decision covers and who is authorised to update its status.
6. Make every dispatched batch traceable
If a recall affects one batch, the warehouse needs to know how many packs remain, which customers received it, and how many went to each customer. Record the actual batch and quantity on the dispatch record, especially when a single order line is fulfilled from multiple batches. Capture the same information when stock moves to another warehouse so the destination team can account for it on arrival.
Test your records with a sample batch. Start with the quantity received, then trace what remains in stock, what was dispatched, and what was returned or otherwise accounted for. If the numbers don’t reconcile, check for missed transfers, picking substitutions, or adjustments entered against the wrong batch. EU Good Distribution Practice guidelines call for distributors to be able to initiate recalls promptly and access the records needed to carry them out.
The same traceability process can support a broad portfolio ofFollow each product’s storage and handling instructions, whether your warehouse stocks anti cancer drugs or receives products.
7. Show sales which batches can fulfil an order
Sales and customer service teams need a view of stock they can actually allocate. Give them the available quantity by batch and expiry date, taking account of existing reservations and stock holds. When a customer has a minimum shelf-life requirement or wants a single batch, capture that condition on the order so it follows the shipment from allocation through packing.
This can prevent a common problem. A salesperson promises 150 packs based on the product total, but the only eligible batch has 110 packs after another order is reserved. With batch-level availability, the team can confirm 110 packs and agree on how to handle the remaining 40 before the warehouse starts picking.
8. Review discrepancies where they occur
When a physical count differs from the system, check the batch and location before adjusting the quantity. If one batch is short by ten packs and another is over by ten, the product total will still balance. A batch-level check can uncover a picking or receiving error that a product-level count would miss.
Record the cause when you find it and look for patterns. Repeated differences at one shelf may point to unclear labels. Repeated differences after split-batch orders may show that the packing team needs a better way to record which quantity came from each batch. Fixing the step where the error occurs makes the records more dependable for future orders.
Conclusion
Start with one fast-moving medicine that has several batches in stock. Ask the receiving team to verify the batch records, the picking team to choose a batch for an order with a shelf-life requirement, and the dispatch team to trace a shipment back to its batch. Any gap will show you where to improve the workflow. Once those checks work for one product, apply them across the warehouse to reduce expiry losses, improve order accuracy, and make recalls easier to manage.
