Master lot tracking and expiration date management: reduce waste, ensure FEFO compliance, handle recalls efficiently, and protect your small business from expired inventory losses.
You received 50 cases of a product in March. You sold 30, then restocked with 40 more cases in May. Now it's July and a customer complains about an expired item. Which batch was it? When did it arrive? How many more expired units are in your inventory?
If answering those questions takes more than five minutes, you have a lot tracking problem.
For businesses dealing with perishable goods, supplements, cosmetics, or any dated inventory, lot tracking isn't optional — it's the difference between serving customers and disposing of dead stock. Here's how to implement it without enterprise-level complexity.
Lot tracking — also called batch tracking — means recording which specific batch or production run each unit of inventory belongs to. It sounds administrative, but it solves three critical problems:
Recalls and returns. When a supplier announces a quality issue with production run #2047, you need to know immediately: did I receive that batch? Where is it now? Did any ship to customers? Without lot tracking, you're either recalling everything (expensive) or recalling nothing (risky).
Expiration management. Different batches of the same product can have different expiration dates. If you only track total quantity on hand, you might sell old stock first while newer stock sits. Worse, you might mix batches and lose track of which units expire when.
Quality disputes. When a customer complains about a defective item, the batch number tells you everything: which supplier produced it, when you received it, and whether other customers received units from the same batch. This turns he-said-she-said into data-driven conversations.
Most small businesses use FIFO (First In, First Out) for inventory valuation. But for physical stock movement, especially with expiration dates, you need FEFO (First Expired, First Out).
FEFO means you pick and ship items with the earliest expiration date first, regardless of when they arrived. This is critical because:
Implementing FEFO without a warehouse system:
For businesses with 50+ dated SKUs, this quickly becomes impractical to manage manually. A system that tracks expiration dates per batch and suggests pick order saves hours per week.
You don't need a million-dollar ERP. Here's a practical approach for small operations:
Start with a batch register. For every inbound shipment, record:
This can live in a spreadsheet. The key is consistency: record every batch, every time.
Assign internal batch numbers for products without supplier lot numbers. Use a simple convention: supplier initials + date. For example, "AC-20260615" for supplier ABC Corp on June 15, 2026. This gives you traceability even for unlabeled stock.
Track batch consumption at shipment. When you fulfill an order, note which batches were picked. This creates a complete audit trail: you can trace any shipped unit back to its receiving batch and supplier.
Run weekly expiration reports. Review all batches expiring within 30, 60, and 90 days. Decide on action: discount, donate, return to supplier, or dispose. A proactive approach recovers value that reactive disposal loses.
If a supplier contacts you about a recall, here's your response process:
Step 1: Identify affected batches. Cross-reference the supplier's recall notice with your batch register. Do you have any of the affected lot numbers in stock?
Step 2: Locate current stock. Find all units of the affected batches in your warehouse. Set them aside immediately to prevent accidental sale.
Step 3: Trace customer shipments. Check your outbound records to see if any affected batches were shipped to customers. You'll need to contact each customer with the batch number, product details, and recall instructions.
Step 4: Document everything. Record the recall notice, affected batch details, quantities quarantined and returned, and customer communications. This documentation protects you if questions arise later.
Without lot tracking, Step 2 takes hours of physical counting and Step 3 is impossible. With good records, the entire process takes a single afternoon.
Mistake #1: Trusting supplier rotation. Relying on suppliers to rotate stock is a recipe for expired inventory. A 2023 study found that nearly 30% of expired stock in small retail resulted from receiving already-aged product. Always check expiration dates on receipt.
Mistake #2: Mixing batches in storage. Once you combine two batches of the same product into one bin, you lose traceability. Keep batches separate with clear labels.
Mistake #3: Ignoring slow movers. The product that sells through in 30 days doesn't need FEFO. But the one that turns every 90 days — with a 120-day shelf life — is a ticking clock. Calculate days of supply vs. shelf life for every dated SKU.
Mistake #4: No write-off procedure. Expired products sitting in your inventory skew your stock counts, carrying cost calculations, and reorder points. Create a monthly write-off process that removes expired items from your active inventory.
Consider a small supplement retailer with 200 SKUs, average shelf life of 18 months, and 15% annual inventory turnover.
Without lot tracking: ~3-5% of inventory expires before sale, costing roughly $3,000-5,000 per year in write-offs, depending on margin and volume.
With FEFO and lot tracking: expiration losses drop to under 1%, and the labor saved on counting and rotating pays for the system within months.
During a recall scenario — which most small businesses face at least once — good lot data can save tens of thousands in unnecessary returns and liability.
Fluxventory supports lot and batch tracking out of the box. Record batch numbers on receiving, track expiration dates per batch, and let the system suggest FEFO picking order automatically. During a recall, search by batch number to instantly see where every unit is — in stock or already shipped. No extra spreadsheets, no manual cross-referencing.
Take control of your dated inventory today. Start your free trial and reduce expiration losses from day one.
Join businesses using Fluxventory to track stock in real time, reduce losses, and make smarter decisions.