Managing Expiry Dates and Batch Tracking in FMCG

The High Stakes of Perishable Inventory

In the Fast-Moving Consumer Goods (FMCG) sector—which includes food, beverages, cosmetics, and pharmaceuticals—inventory management is a race against the clock. Unlike electronics or apparel, these products have a hard shelf life. If you fail to sell them before their expiration date, they turn from valuable assets into total losses, destroying your profit margins.

Managing perishable goods requires a level of detail that basic inventory systems cannot provide. If you track inventory purely by SKU (e.g., "Orange Juice"), your warehouse staff will naturally grab the boxes closest to the front of the shelf to fulfill orders. This leads to new stock being sold first, while older stock sits hidden in the back until it expires. To prevent this, you must track inventory not just by SKU, but by specific production batches.

The Transition from FIFO to FEFO

Most basic businesses attempt to use FIFO (First-In, First-Out) logic, assuming that the oldest stock received is the first that should be sold. However, in complex supply chains, this isn't always true. A supplier might ship you a newer batch today and an older batch tomorrow due to their own warehouse errors.

The superior standard for FMCG is FEFO: First-Expired, First-Out. This guarantees that regardless of when a product entered your building, the product with the earliest expiration date is prioritized for dispatch. Enforcing FEFO manually is impossible at scale; it requires a specialized Warehouse Management System.

Deep Batch Tracking with Oishia Commerce

Oishia Commerce provides enterprise-grade lot and batch tracking capabilities designed specifically to protect FMCG distributors from spoilage and enable rapid recalls.

1. Strict Inbound Data Capture

The control begins at the loading dock. When a Purchase Order for perishable goods is received, Oishia does not allow the staff to simply input quantities. The system mandates the entry of the manufacturer's Batch/Lot Number and the specific Expiration Date for that delivery. The system now tracks this batch as a distinct entity within the broader SKU profile.

2. Automated FEFO Picking

When wholesale orders drop into the Oishia fulfillment dashboard, the system's picking algorithm takes over. It analyzes all available batches for the requested SKU and automatically directs the warehouse picker to the specific Bin Location holding the batch that is closest to expiration. This systemic enforcement of FEFO ensures that your oldest stock is always liquidated first, drastically reducing spoilage rates.

3. Proactive Expiry Alerts

Oishia doesn't just passively track dates; it actively warns you. Managers can configure the dashboard to highlight batches that are within a certain window of expiration (e.g., 30 days). This allows your sales team to proactively run aggressive promotions, flash sales, or B2B discounts to clear the stock before it becomes worthless.

4. Rapid Recall Capabilities

In the event a manufacturer issues a health and safety recall for a specific batch, Oishia provides instant traceability. With a single search of the Batch Number, you can trace exactly which warehouse received it, which delivery van carried it, and which specific retail customers purchased it, allowing you to execute a targeted, compliant product recall in minutes rather than days.

Best Practices for Batch Management

• Standardize Date Formats: Train receiving staff to always input expiration dates in a strict YYYY-MM-DD format to ensure the software sorts them correctly without regional formatting confusion.
• Physical Segregation: Even with software routing, make it physically easier for pickers. Store different batches of the same SKU in separate, clearly labeled bins to prevent accidental mixing.
• Discount the Danger Zone: Set up automated pricing rules in your Oishia B2B portal to automatically apply a 20% discount to any batch that drops below 45 days to expiration, incentivizing buyers to take it off your hands.

Conclusion

Selling perishable goods is a high-risk endeavor. If you are flying blind without batch tracking, you are inevitably losing money to spoilage. By implementing Oishia Commerce's deep batch tracking and automated FEFO picking algorithms, you maximize the shelf life of your inventory, protect your margins, and ensure the safety of your customers.