Moving Beyond SKU-Level Logic: The High Cost of Ignoring Batch Segregation in FMCG

12:30 | 7 June 2024

by Kamal Kumawat

Moving Beyond SKU-Level Logic: The High Cost of Ignoring Batch Segregation in FMCG

If you are still managing "inventory" as a single SKU count in your WMS, you aren't running an FMCG operation; you’re running a ticking time bomb.

In fast-moving packaged foods, the distinction between Item A and Item B is often irrelevant to the customer, but it is everything to the CFO. When a shipment of shelf-stable snacks or dairy-based products hits the floor with a 60-day shelf life versus a 12-month window, "average" inventory logic fails. If your system doesn't force a hard distinction at the bin level, you are eventually going to ship a product that expires on the customer’s doorstep. That isn't just a logistical hiccup; it’s a brand-killer and a potential regulatory nightmare.

The "Zombie Stock" Problem

Most mid-market FMCG brands outsource their fulfillment but lose granular visibility. They see "Stock Available: 5,000 units." What they don't see is that 4,000 of those are sitting in the back of a third-party warehouse with 45 days to live.

When you lack native batch tracking, your pickers move toward what is physically closest or most accessible. They grab the "easy" units—the ones getting closer to expiration—leaving the fresh stock to rot while you pay for storage. In my experience, I’ve seen FMCG players lose up to 8% of their annual margin simply because they failed to automate FEFO (First Expiry, First Out) logic at the WMS level. That is 8% of your profit literally turning into waste in a warehouse.

The Cost of Ignorance (A Field Note)

I recently audited a regional distribution hub for a major snack brand that scaled too fast to maintain manual controls. They had "master" SKUs but no batch-specific logic in their picking instructions. During a 4x volume spike over a festive period, the warehouse staff—under pressure to hit throughput targets—stopped checking dates entirely.

They shipped out 12,000 units of a granola line that were within 30 days of expiry. The fallout was immediate: a 12% RTO (Return to Origin) rate as customers complained about "short-dated" products. The cost of reverse logistics, the damaged packaging from double handling, and the fact that those 12,000 units had to be destroyed rather than restocked wiped out the margin of that entire campaign. They didn't have a "process" problem; they had a data integrity failure where the WMS was blind to the date-stamp component of the SKU.

The Logic Layer: How it Must Function

Stop asking your vendors if they "can handle" expiry dates. Ask them how they technically enforce FEFO at the point of picking. A robust system doesn't just "flag" an item; it must logically block a picker from selecting an invalid batch.

The infrastructure should function on three specific triggers:

  • Automatic Buffer Zones : The system must calculate a "hard stop." If a product has <90 days of shelf life, the WMS must automatically move it into a "Liquidation/Short-Date" pool. It shouldn't be available for standard e-commerce fulfillment; it should only be visible to B2B bulk liquidators or "clearance" channels.
  • Batch-Specific Bin Mapping : You cannot have multiple batches in the same physical bin. If Batch A (short date) and Batch B (long date) are mixed, your pickers will eventually grab the wrong one. The system must generate a unique Pick Location for every distinct batch.
  • Real-Time Sync Cycles : Your ERP must push expiry data to the WMS via API at least every hour—not daily. If a batch is flagged as "near-expiry" in the manufacturing backend, it needs to be reflected in the warehouse's picker app immediately to prevent it from being bundled into a standard shipment.

The Bottom Line

If your fulfillment architecture treats "Date" as a secondary data point rather than a primary constraint on the packing logic, you are gambling with your margins. In FMCG, every unit that expires in your warehouse is a lost sale; every unit that expires in a customer's kitchen is a lost customer. Fix the logic at the bin level or prepare to pay for the waste.

Compliance

Streamline your pan-India expansion. We support in your APOB/PPOB, handling GST compliance and licensing for any industry.

Get Closer to Your Customers

Get 98% SLA Compliance with Edgistify

Deliver Same-day with Sonic

Ensure guaranteed reduced RTOs with Same Day Delivery