Dharmik Supermarket Cut Expiry Waste by 40%

A store in Coimbatore that was losing money to expiry every single month

Dharmik Health & Beauty is a supermarket and health store in Coimbatore, Tamil Nadu. Not a chain. Not a franchise. A single store, independently owned, carrying roughly 4,000 SKUs across grocery, personal care, health supplements, ayurvedic products, and daily essentials. The kind of store where the owner knows regulars by name and the staff has been around long enough to argue about where the new gondola should go.

Kavitha manages the store. She has been there for several years, and when we first spoke with her, she was frustrated about something specific: every month, without fail, she was pulling expired products off shelves during audits. Not one or two items. Dozens. Sometimes more. The financial loss was not catastrophic in any single month — it was the kind of slow, steady bleed that does not show up as a crisis but compounds into a serious problem over a year.

The store's annual expiry-related write-offs were running at approximately 3.5% of inventory value. For a store of Dharmik's size, that translates to several lakhs per year in products that were purchased, received, shelved, and then thrown away because nobody caught them in time. Products that had already been paid for, already accounted for in GST filings, already sitting in the store's working capital.

This is the story of how that number came down by 40%.

The problem: what was actually going wrong

At Dharmik, the problems fell into four categories.

1. Manual expiry checking that depended entirely on staff memory

The store had no system for tracking batch-level expiry dates. Products were entered into the billing software at the SKU level — product name, MRP, quantity. That was it. When a delivery of Himalaya face wash arrived with three different batches carrying three different expiry dates, the system recorded "Himalaya Face Wash x 36 units." Which batch expired when? Nobody's system knew. Kavitha's staff knew, sometimes, because they remembered — until they didn't.

Shelf audits happened weekly, but they were visual inspections. A staff member would walk the aisles, pick up products, check dates printed on packaging. If the print was faded, if the product was at the back of the shelf, if the staff member was rushed — things got missed. And they did get missed. Regularly.

2. No batch-level visibility in inventory

This was the root cause underneath most of the other problems. Without batch tracking, the store could not answer basic questions: How many units of a particular batch do we have? When does our oldest stock of a given product expire? Which supplier sent us the batch that is about to expire?

When a supplier's delivery arrived with short-dated stock — 2 months remaining on a product with a 12-month shelf life — there was no systematic way to flag it at the time of receiving. It would get shelved alongside longer-dated stock, and the short-dated batch would sit there until someone noticed it during a shelf audit, by which point it might be too late to return it or discount it effectively.

3. GRN entry that consumed 45+ minutes per invoice

Dharmik receives inventory from 25-30 suppliers. Each delivery comes with an invoice that needs to be entered into the system — what's called Goods Received Note (GRN) entry. For a typical invoice with 40-50 line items, Kavitha's billing staff needed 45 minutes to an hour. Sometimes longer, depending on the supplier's invoice format and handwriting.

The process: read the product name on the invoice, find it in the system's dropdown, confirm the match, type in the quantity, batch number, expiry date, MRP, rate, GST percentage. Repeat 50 times. Then reconcile the total with the invoice amount, check the GST breakup, and file the paperwork.

At 4-5 invoices per day, GRN entry alone consumed 3-4 hours of billing staff time daily. That was time not spent serving customers, not spent checking shelves, not spent on anything that directly generated revenue. And the error rate was meaningful — a batch number mistyped here, an expiry date entered wrong there. Each error created a small downstream problem that might not surface for months.

4. FIFO instead of FEFO at the point of sale

The store's billing system sold on FIFO — First In, First Out. Whatever was received first was sold first, at least in the system's records. But receipt order and expiry order are not the same thing. A delivery received on the 1st might carry stock expiring in March, while a delivery received on the 5th might carry stock expiring in February. FIFO would sell the March-expiring stock first, leaving the February-expiring stock to sit until it became a problem.

On the shop floor, staff tried to rotate stock manually — putting older-dated products in front. But without system support, this was inconsistent. And at the POS, the billing system had no concept of which batch was being sold, so the inventory records gradually drifted from physical reality.

The solution: implementing ShelfLifePro

Dharmik implemented ShelfLifePro for Supermarkets in stages over about three weeks. Not a big-bang deployment — Kavitha was clear that she could not afford to disrupt daily operations for an extended implementation period. The rollout was practical and sequential.

Week 1: Catalogue setup and OCR invoice scanning

The first change was the one that generated the most immediate relief: OCR-based GRN entry. Instead of manually typing each line item from a supplier invoice, the billing staff now photographs the invoice with a phone camera. ShelfLifePro's OCR engine reads the invoice, extracts product names, quantities, batch numbers, expiry dates, MRP, rates, and GST details, and presents them for human review and confirmation.

The time impact was dramatic. A 50-line invoice that previously took 45 minutes now takes about 5 minutes — one minute to photograph, one to two for processing, and two to three minutes for the staff member to review the extracted data, confirm product matches, and approve. By the end of the first week, Kavitha's billing staff had recovered roughly 3 hours per day.

"The first day we used the OCR, my billing person finished all the morning invoices before lunch. She came and asked me what else she should do. That had never happened before." — **Kavitha, Store Manager, Dharmik Health & Beauty**

The OCR also captured batch numbers and expiry dates automatically, which meant that for the first time, every product entering the store was tracked at the batch level without requiring additional manual effort. The batch data rode in on the invoice scan, effectively for free.

Week 2: Batch-level tracking and FEFO activation

With batch-level data now flowing into the system from GRN, the next step was activating FEFO (First Expiry, First Out) at the POS. When a customer purchases a product, the system now automatically deducts from the batch with the nearest expiry date. This means the inventory records stay aligned with what should be happening on the shelf — oldest-expiring stock sells first.

This also activated batch-level inventory visibility. For the first time, Kavitha could open a dashboard and see, for any product, exactly which batches were in stock, how many units of each, and when each batch expires. No more guessing. No more relying on staff memory. The data was there, updated in real time with every sale and every new delivery.

Week 3: WhatsApp expiry alerts and supplier management

ShelfLifePro's automated alert system was configured to send WhatsApp notifications at three intervals:

• 90 days before expiry for long-shelf-life products (health supplements, packaged foods, personal care)
• 30 days before expiry for medium-shelf-life products (certain dairy items, specialty foods)
• 7 days before expiry as a final action alert for anything still in stock

These alerts go directly to Kavitha's WhatsApp — not buried in a software dashboard she might not check daily, but on the phone she checks constantly. Each alert includes the product name, batch number, quantity remaining, expiry date, and the supplier who provided that batch.

That last detail — the supplier name — turned out to be more valuable than expected. When Kavitha could see that a specific supplier was consistently sending short-dated stock, she had data to support a conversation with that supplier. Not a complaint based on general feeling, but specific batches, specific dates, specific patterns. Two supplier relationships were renegotiated within the first two months based on this data, resulting in better shelf-life-at-receipt terms.

The results: what actually changed

The numbers below are from the first six months of ShelfLifePro usage at Dharmik, compared to the six months prior. They are real numbers from a real store, not projections or industry averages.

40% reduction in expiry waste

Monthly expiry write-offs dropped from an average of approximately ₹28,000 to approximately ₹17,000. The 40% figure is the average across six months — some months were better (one month saw a 52% reduction), some were closer to 30%. The variance tracks with seasonal demand patterns and supplier behaviour, which is expected.

The reduction came from three mechanisms working together:

• Earlier detection: The 90-day and 30-day alerts meant products were identified as at-risk well before they actually expired, giving time to run promotions, adjust shelf placement, or initiate supplier returns
• FEFO enforcement: Older-expiring stock was consistently sold before newer-expiring stock, reducing the accumulation of near-expiry inventory
• Better receiving practices: Short-dated stock from suppliers was flagged at the GRN stage itself, allowing Kavitha to reject or negotiate before shelving

GRN time: from 45 minutes to 5 minutes per invoice

This was the most operationally visible change. The billing staff went from spending 3-4 hours daily on invoice entry to roughly 25-30 minutes. The recovered time was redirected to shelf management, customer service, and the kind of proactive stock checking that prevents problems rather than reacting to them.

The accuracy improvement was equally significant. Manual entry error rates dropped substantially because the OCR reads directly from the source document. GST reconciliation — matching purchase data against GSTR-2A filings — became cleaner, which protects the store's Input Tax Credit claims.

Zero customer complaints about expired products

In the six months before ShelfLifePro, Dharmik had received four customer complaints about expired products found on shelves. In the six months after, zero. This is a small sample size and should be treated accordingly — it is not proof that the system is perfect, just that the most obvious failures stopped occurring. For a store that depends on neighbourhood trust and repeat customers, even a single expired-product complaint carries reputational cost that far exceeds the MRP of the product involved.

Staff productivity and morale

This is harder to quantify but worth noting. When billing staff are not buried in invoice entry, they can do higher-value work. When shelf audits are supported by data — the system tells you which products to check, rather than asking you to check everything — audits become faster and more targeted. Kavitha reported that staff engagement with expiry management improved noticeably because the system made the work feel manageable rather than overwhelming.

What this means for similar stores

Dharmik is not a large retailer. It does not have an IT department or a dedicated inventory manager. It is a single supermarket in Coimbatore, run by people who are busy serving customers and managing suppliers and dealing with the hundred daily operational details that running a store involves.

The 40% waste reduction was not achieved through heroic effort or expensive infrastructure. It came from three specific capabilities that did not exist before:

• Batch-level visibility — knowing what you have, at the batch level, in real time
• Automated alerts with adequate lead time — being told about problems before they become losses
• OCR-based GRN — eliminating the data entry bottleneck that was preventing batch-level tracking in the first place

If your store carries perishable or date-sensitive products — and most supermarkets, health stores, and pharmacies in India do — the same pattern of problems likely exists in your operations. Manual expiry checking misses things. SKU-level inventory cannot tell you which batch is about to expire. GRN entry consumes staff time that could be used for higher-value work.

Dharmik was a well-run store. The constraint was tooling, not effort.

The specifics

Dharmik Health & Beauty started with a simple goal: stop finding expired products on shelves during audits. The OCR-based GRN, batch tracking, and automated alerts delivered that. The 40% waste reduction was a side effect of having accurate data.

• See how ShelfLifePro works for supermarkets
• Start your free trial