Hardware and stationery shops share one problem: a huge number of small items. Screws, nuts, pipes, pens, notebooks, files, pins. Counting and tracking all of it can feel impossible. It is not, if you set it up in the right order.
Start with the top 100
You do not need every item on day one. Begin with the 100 items you sell most often. Those are the ones where a stock-out costs you a sale. Add the rest gradually, as they sell.
For each item, record the cost price per piece and the selling price per piece.
Work out the price per piece
Hardware and stationery are often bought in bulk and sold in pieces. A box of 100 screws, a ream of 500 sheets, a roll of wire by the metre.
Pick the unit you sell and use it for everything:
Cost per piece = Cost of the box ÷ Pieces in the box
If a box of 100 screws costs ₹250, each screw costs ₹2.50. Sell at ₹4 and you earn ₹1.50 a piece, a margin of 37.5%. Check any item with the markup calculator if you know the cost and the margin you want.
Group items so you can find them
With hundreds of items, a flat list gets slow. Group by type: plumbing, electrical, fasteners, tools; or pens, paper, files, art supplies. Use the same groups on your shelves and in your records so a count of one shelf matches one group.
Plan for the seasons
Stationery sells in waves: school reopening, exam time, financial-year start. Hardware has its own: monsoon repairs, festival painting and renovation. Look at last year's sales for each season and stock up a few weeks before, not during. After the season ends, mark down what is left rather than carrying it for a year.
Reorder levels for the items that matter
For your fastest 20 items, set a reorder level: average sales per day times the days a supplier takes, plus a little extra. The reorder point calculator gives you the number. Check those 20 each morning. Everything else can be checked weekly.
Count one section at a time
A full stock take of a hardware shop is a nightmare. Instead, count one group each day and compare it with your records. In a week, you have covered the whole shop without closing. More on this in the post about counting stock without closing the shop.
Do not forget the small stuff adds up
Individually, a ₹2 item looks trivial. A hundred sales of it a day is not. Missing small items are the most common source of stock drift in these shops, because nobody notices one missing piece. Record every sale, even the small ones. A phone app that takes a few taps per sale makes that realistic.
The short version
- Start with your top 100 items.
- Record cost and price per piece, not per box.
- Group items the way your shelves are grouped.
- Stock up before the season, mark down after.
- Count one section a day.
To do this on your phone, with stock and profit updating after each sale and no internet needed, see the inventory management app. It is free to download.