The Notebook Problem: Why Manual Tracking Fails
Walk into any traditional saree or suit shop in India and you will find a notebook — sometimes multiple notebooks — where the owner or a trusted employee records every purchase and sale. This system has worked for decades, but it breaks down as soon as the business grows beyond a single counter and a hundred SKUs.
The problems with notebook-based tracking are predictable and painful:
- No real-time stock count: You have to physically check the shelves to know what you have. During wedding season, this means constant interruptions.
- Shrinkage goes unnoticed: When inventory is only counted once a year (if at all), theft and damage accumulate silently. Many shop owners discover lakhs worth of missing stock during annual audits.
- Dead stock hides in plain sight: That pile of floral chiffon sarees from two seasons ago? Without data, you do not realise they have been sitting unsold for 18 months until they are out of fashion entirely.
- Reordering is guesswork: "I think we need more Chanderi sarees" is not a reorder strategy. It leads to overstocking slow items and running out of fast movers.
Excel: Better Than Notebooks, But Not Enough
Many shop owners graduate from notebooks to Excel. This is a meaningful step — you gain search, basic formulas, and some structure. But Excel was never designed for retail inventory:
- No multi-user access: Only one person can update the file at a time. If your salesperson and billing counter both need to record transactions, someone waits.
- Formula errors compound: A single wrong formula can silently corrupt months of data. And no one audits Excel formulas regularly.
- No barcode integration: You still have to look up the item, type in the details, and update the stock manually. This is slow and error-prone.
- No alerts: Excel will not tell you when stock is running low. You have to remember to check.
Per-Metre vs Per-Piece: The Fabric Challenge
Fashion retail has a unique inventory challenge that most generic software ignores: fabric is sold by the metre, not by the piece. A saree is typically 5.5 to 6.5 metres. An unstitched suit length might be 2.5 metres for the top, 2.5 metres for the bottom, and 2.25 metres for the dupatta. Dress materials come in running metres.
This means your inventory system needs to track:
- Total metres in stock per fabric/design
- Metres deducted per sale (not just "1 piece sold")
- Remnants and cut pieces that cannot be sold as full sarees or suit lengths
- Conversion between purchase units and sale units (you may buy a thaan of 40 metres and sell individual suit lengths from it)
Most generic inventory software treats everything as discrete units. If you try to track fabric in such systems, you end up with a parallel paper record for metres — defeating the purpose of going digital in the first place.
Barcoding: The Game Changer for Fashion Retail
Barcoding transforms inventory management from a chore into a seamless process. Here is how it works in practice for a saree or suit shop:
- Label every item on arrival: When a new lot arrives from your supplier, print barcode labels and tag every piece. This takes 15-20 minutes per hundred items.
- Scan during billing: Instead of searching for the item, typing its name, and looking up the price, the salesperson scans the barcode. The item, price, GST rate, and stock count update instantly.
- Scan during stock audits: Walk through your shop with a scanner and compare scanned stock against system stock. Discrepancies are flagged immediately.
- Track item history: Every scan creates a log — when the item arrived, when it was moved to the showroom, when it was billed, if it was returned.
The initial investment in a barcode printer (around INR 4,000-8,000) and labels pays for itself within weeks through faster billing, fewer errors, and better stock visibility.
Identifying and Managing Dead Stock
Dead stock is the silent killer of fashion retail profitability. Items that have not sold in 90-180 days are tying up your capital and shelf space. Here is a practical framework:
- 90-day rule: Any item unsold for 90 days should be flagged for review. Consider moving it to a prominent display or pairing it with a fast-moving item.
- 180-day rule: Items unsold for 180 days need aggressive action — discounts, bundling, or wholesale liquidation to another market.
- Seasonal awareness: Wedding-season lehengas unsold by March are unlikely to move until October. Factor seasonality into your dead stock calculations.
- Cost of holding: Every unsold item costs you — rent for the space it occupies, capital locked up, and the opportunity cost of not buying something that would sell.
Modern retail software tracks item age automatically. HisabLekha, for instance, shows you a dead stock dashboard with ageing analysis — you can see at a glance which items have been sitting for 30, 60, 90, and 180+ days, sorted by the capital locked in each category.
Building a Practical Inventory System
You do not need to overhaul your entire shop in one day. Here is a phased approach:
- Week 1: Set up your product catalogue in software. Enter item categories, HSN codes, and prices. You can start with your top 50 fast-moving items.
- Week 2: Start barcode labelling for new arrivals. Old stock can be added gradually during slow hours.
- Week 3: Begin billing through the system (scan-to-bill). Stock levels will start reflecting reality.
- Month 2: Run your first stock audit. Compare system counts with physical counts. Resolve discrepancies.
- Month 3 onward: You now have reliable inventory data. Use it for reordering, dead stock clearance, and supplier negotiations.
The goal is not perfection on day one. It is building a system that gets more accurate with every transaction and gives you the data you need to make smarter buying and selling decisions.