Inventory management for small shops in India: simple systems that stop stock-outs and dead stock

Ask a small shopkeeper where their money is and the honest answer is often: “On the shelves.” Stock is usually a small shop’s biggest investment, bigger than the counter, the fridge and the signboard combined. Yet most small shops manage it from memory: the owner glances at the shelf, thinks “atta is low”, and calls the distributor.

Memory works surprisingly well, until it doesn’t. Best-sellers run out on busy days. Slow items sit for months tying up cash. Expiry dates pass unnoticed. Money goes missing and nobody knows where. This guide gives small shops a simple stock system that works with a notebook, a spreadsheet or a billing app, and doesn’t take more than a few minutes a day.

Why stock control matters so much for small shops

Too little stock

• Regular customers find their product missing
• They buy it elsewhere, and maybe the rest of their list too
• Lost sales you never see in your accounts
• Rushed emergency orders at worse prices

Too much stock

• Cash locked on shelves instead of in the bank
• Expired and damaged goods you can’t sell
• Cluttered shelves that hide good products
• Discounts just to clear space

Step 1: Know what sells, using ABC analysis

You can’t watch every item equally closely. ABC analysis sorts your products so you focus where it matters:

Group	What it is	Typically	How to manage it
A items	Your biggest sellers by value	A small share of items bringing most of your sales	Never let them run out. Check daily. Keep a buffer.
B items	Steady middle sellers	A larger group bringing a moderate share of sales	Check weekly. Normal reorder levels.
C items	Slow or occasional sellers	Many items bringing a small share of sales	Keep low stock. Review whether to keep them at all.

How to do it: list your items with last month’s sales value (from your billing app, or from your purchase records if you don’t have one). Sort from highest to lowest. The top items that together make up most of your sales are your A list. For most kiranas, that’s a few dozen products: milk, atta, rice, oil, sugar, tea, popular biscuits and soaps.

Step 2: Set reorder levels for your A and B items

A reorder level is the point at which you place a new order, so the new stock arrives before you run out. You need two numbers: how much you sell per day, and how many days the supplier takes to deliver.

Reorder level, worked out

Reorder level=Daily salesaverage units×Lead timedays to arrive+Safety stockbuffer

Example: 26 packs=6 packsatta 5 kg a day×3 daysdistributor delivery+8 packsfor busy days

Write the reorder level on the shelf edge, in your notebook or in your billing app. Now anyone in the shop knows when to order, not just the owner.

Step 3: Receive stock properly

Many stock problems start at the door. A delivery arrives during a rush, someone signs the challan without counting, and the missing cartons or damaged packets are never claimed.

Five checks for every delivery

1. Count against the invoiceCheck every item and quantity before signing. Open a sample of cartons.
2. Check condition and datesDamaged, leaking or near-expiry goods go back or are noted on the challan.
3. Check prices and MRPRates match what you agreed; packs carry a proper MRP and label.
4. Record it the same dayIn your app, sheet or notebook. Note any shortage and get the delivery person to sign it.
5. Store it rightNew stock behind old stock, in its labelled place.

We go deeper into receiving and loss in our guide to inventory shrinkage and stock control.

Step 4: FIFO and FEFO

FIFO (first in, first out) means older stock is sold before newer stock. FEFO (first expiry, first out) means whatever expires first goes in front, which matters more for food, medicines and cosmetics. Every time you refill a shelf, put new stock behind old stock and check dates on the way. Once a week, check the expiry dates of slow-moving food and medicine items.

Step 5: Give everything a home

A shop where every product has a fixed place is faster to serve from, easier to refill and much easier to count. Label shelves in the backroom as well as the shop. Keep a photo of each well-arranged shelf on your phone as a simple guide for helpers; see how to make a simple planogram.

Step 6: Count a little, often

Instead of one exhausting full count a year, do cycle counts: count 10–20 items a week, starting with your A items and anything expensive or easy to steal. Compare with your records. If there’s a gap, find out why while it’s fresh: a missed entry, a damaged pack, a billing mistake or theft.

Step 7: Deal with dead stock

Every shop has items that haven’t sold in months. They tie up cash and space. Once a month:

• List items that haven’t sold in 60–90 days.
• Move them to a more visible spot, or bundle them with a popular item.
• Ask the supplier about returns or exchanges, if your terms allow.
• Offer a clear discount (never above MRP, and never selling expired goods).
• Stop reordering them, and note why, so you don’t make the same buying mistake.

Choosing a system: notebook, Excel or app

Tool	Good for	Limits
Stock notebook	Very small shops; owners comfortable with paper; zero cost	Hard to see trends; depends on one person; easy to forget entries
Spreadsheet (Excel or Google Sheets)	Shops with a computer or phone and a few hundred items	Manual entry; needs discipline to update daily
Billing / inventory app	Shops ready to bill digitally; stock updates automatically with each sale	Setup time; small monthly fees for some; needs accurate barcode or item entry

If you plan to sell online, through WhatsApp, ONDC (which had over 1.16 lakh retail sellers by late 2025) or a delivery app, accurate stock records become essential, because online customers order what your system says you have. See ONDC explained for small retailers.

Two numbers worth tracking

Stock turnsper year=Cost of goods soldin a year÷Average stock valueat cost

Days of stock=Stock valueat cost÷Daily cost of goods sold

A weekly stock routine

Pair stock records with simple daily accounts and you’ll always know where your money is. Our Hindi guide दुकान का हिसाब-किताब कैसे रखें covers that side. For opening and closing routines that include stock checks, see the store opening and closing checklist.

Common questions

How much stock should a small shop carry?

Enough of your A items to never run out between deliveries, plus a buffer; as little as possible of C items. Many kiranas aim to hold a few weeks of stock overall, but your supplier frequency and credit terms decide what’s right.

Is it worth buying in bulk for a discount?

Only for fast-moving items with a long shelf life, and only if the discount is worth more than the cash you lock up. Bulk-buying slow items is a common way to create dead stock.

The short version

• Sort products into A, B and C by sales value; watch A items daily.
• Set reorder levels from daily sales, lead time and a buffer.
• Count deliveries before signing; rotate stock FIFO and FEFO.
• Cycle count a few items every week.
• Clear dead stock monthly and stop reordering it.

Common mistakes

1. Ordering by feel instead of by sales. Use your numbers, even rough ones.
2. Treating every item the same. Focus on A items first.
3. Signing for deliveries without counting. Shortages are rarely recovered later.
4. Forgetting seasonality. Festivals, weddings, school reopening and summer change what sells.
5. Keeping slow stock “just in case”. Cash on a shelf earns nothing.
6. Only the owner knows the system. Teach helpers the reorder levels and receiving checks.

Good stock control isn’t about software. It’s about a few habits repeated every day. Start with your top 20 items this week, set their reorder levels, and see how many fewer “sorry, khatam ho gaya” moments you have by the end of the month. If you’re just starting a shop, read how to start a kirana store for the bigger picture.