FMCG Warehouse Inventory: Godown to Shelf Control

The Reality of FMCG Distribution: Too Many SKUs, Too Little Visibility

picture a typical mid-size FMCG distributor: 12,000 SKUs across three warehouses, Britannia biscuits to Unilever soaps, Parle-G to Fair & Lovely tubes. the biggest headache usually isn't sales, it's knowing what's actually sitting on which shelf, in which batch, expiring when.

his current system tracks quantities. "500 units of Marie Gold biscuits." but which production batch? manufactured when? expiring when? the system doesn't know. so when Britannia calls about a batch recall, he's manually checking thousands of cartons.

and that's every FMCG distributor's problem, whatever the city.

Why Standard Inventory Tools Fail FMCG Distributors

Most inventory software was built for simple retail. one product, one price, sell till it's gone. FMCG distribution is different:

Multiple batches of same product - you might have Maggi noodles from three different production runs, each with different expiry dates

Bulk packaging variations - same Lux soap comes in units of 6, 24, or 96 pieces

Supplier-specific batch codes - HUL uses different batch numbering than P&G

Zone-wise pricing - same product, different MRP for different states

Expiry management at scale - tracking thousands of different expiry dates across hundreds of product lines

standard inventory tools treat "Lux soap 100g" as one line item. but you need to track:

• Batch B2024031A (expires March 2026)
• Batch C2024042B (expires April 2026)
• Different purchase rates for each batch
• Which warehouse stores which batch

The Batch-Level Tracking Challenge

here's what happens without proper batch tracking:

scenario one: Dabur calls about a batch recall for Chyawanprash. you stock 200 jars. which ones are from the recalled batch? without batch-level records, you're physically checking every jar.

scenario two: you're moving Closeup toothpaste that expires in 2 months to clear old stock. but your picker keeps sending fresh stock (expires in 18 months) because the system just says "pick Closeup."

scenario three: GST audit. officer wants batch-wise purchase and sales records for Dettol handwash. your accounting shows total quantities, not batch movement.

First-In-First-Out Without the Complexity

FIFO sounds simple. in practice, it's hard:

manual FIFO: warehouse staff checks manufacture dates on every pick. slow and error-prone. (For the full method, rotation rules included, see the FEFO inventory management guide.)

automated FIFO: system tracks batch dates and tells pickers which batch to pick first. faster, more accurate.

but here's the catch: automated FIFO needs batch-level inventory tracking. your system needs to know:

• which batches you have
• how much of each batch
• where each batch is located
• expiry date for each batch

most distributors try to manage this with Excel. works for 100 SKUs. breaks down at 1000 SKUs.

Location-Wise Inventory for Multi-Warehouse Operations

many FMCG distributors run multiple warehouses (and if any of them hold temperature-sensitive stock, cold-chain tracking has its own rules):

• main warehouse in city center
• smaller hubs in different zones
• factory-direct delivery points

each location needs independent inventory tracking, but consolidated reporting.

what you need to know:

• which products are in which warehouse
• batch-wise stock at each location
• inter-warehouse transfer tracking
• location-wise expiry alerts

what breaks the system: treating all locations as one inventory pool. then you promise customers stock you can't deliver because it's in the wrong warehouse.

Managing Supplier Variations and Pricing

same product, different suppliers, different complications:

Colgate toothpaste 100g might come from:

• Colgate-Palmolive India (Mumbai plant)
• Colgate-Palmolive India (Goa plant)
• imports from Thailand plant

each has different batch coding, different purchase rates, potentially different MRPs.

your inventory system needs to track not just quantity, but:

• supplier source
• purchase rate for each batch
• expiry date format (DD/MM/YY vs MM/DD/YY vs Julian dates)
• packaging variations

Expiry Alerts That Actually Work

"expires in 30 days" alerts sound useful. in practice, they're useless if they arrive too late.

better approach: alerts based on product velocity

• fast-moving items (Maggi, Lux): alert at 45 days
• medium-moving items (specialty shampoos): alert at 90 days
• slow-moving items (premium chocolates): alert at 120 days

even better: velocity-based + margin analysis

• high-margin items: earlier alerts, more aggressive markdowns
• low-margin items: standard timeline

goal is moving stock before write-offs, not just knowing about expiries.

Integration Points That Matter for FMCG

your inventory system doesn't work in isolation:

billing software: needs real-time stock quantities and batch information

accounting system: needs batch-wise COGS for accurate margin analysis

sales team mobile apps: need current stock status and delivery timelines

supplier portals: for electronic invoicing and direct inventory updates

logistics partners: for real-time shipment tracking and delivery confirmation

most distributors end up with 5 different systems that don't talk to each other. then spend hours updating each one manually.

Getting Started: Pilot Before You Scale

don't try to fix everything at once:

phase 1: pick your top 50 SKUs by value. implement batch tracking for these first.

phase 2: add location tracking if you have multiple warehouses.

phase 3: expand to full SKU range once processes are working.

phase 4: integrate with billing and accounting systems.

start with products where expiry matters most—chocolates, health drinks, personal care with shorter shelf life.

The Real Cost of Poor FMCG Inventory Management

run the math on that illustrative distributor:

• even a 2-3% slice of stock value quietly lost to expiry each year
• hours every week burned on manual stock reconciliation
• fast movers going out of stock while slow movers pile up
• GST complications during audits due to poor batch records

in this example, on ₹50 lakh of annual inventory, a 3% expiry loss alone is ₹1.5 lakh a year.

Moving Beyond Spreadsheets

if you're managing FMCG inventory with Excel, you're not alone. but there's a reason enterprise distributors invest in proper inventory systems.

batch-level tracking, location management, and automated FIFO aren't luxury features. they're operational necessities at scale.

ShelfLifePro offers batch-level inventory tracking designed for FMCG distributors, and it comes with a 14-day free trial, no credit card required. because knowing what you have, where it is, and when it expires shouldn't require a team of data entry clerks.