Hardware Shop Stock Management: A Simple System
A practical system for hardware and sanitary stores to organise thousands of items, set reorder levels and cut dead stock.
Gaddibook Team · · 7 min read
Hardware shop stock management is one of the hardest jobs in retail. A typical hardware or sanitary store carries thousands of items: screws in twenty sizes, pipes in five diameters, paint in dozens of shades, and fittings from several brands. Some items sell every hour, others once a year. This guide gives a simple, practical system for hardware shop stock management that a small team can actually follow.
Why hardware stock is hard to control
Hardware stores face problems that a grocery store does not:
- Huge variety. The same item comes in many sizes, materials and brands.
- Mixed units. Pipes are sold by length, wire by metre or coil, nails by kg, and fittings by piece or box.
- Slow movers. Many items sell rarely, so dead stock builds up quietly.
- Contractor credit. Plumbers, electricians and contractors buy on credit and return unused material.
- Small, valuable items that are easy to lose or misplace.
Without a system, the owner relies on memory, and memory fails as the shop grows.
Step 1: Name items the same way every time
Most stock confusion starts with inconsistent item names. Decide one naming pattern and use it everywhere:
Category, Type, Size, Material or Brand
| Bad name | Good name |
|---|---|
| Screw 2" | Screw, Wood, 2 inch, MS |
| CPVC elbow | Fitting, CPVC Elbow 90°, 3/4 inch, Astral |
| Wire red | Wire, House, 1.5 sq mm, Red, Havells |
| Paint white 1L | Paint, Emulsion, White, 1 L, Asian Paints |
Brands in this table are examples. With consistent names, searching at the counter becomes fast, and duplicate items stop appearing in your list.
Step 2: Set the right unit and conversion
Set a base unit for each item and a conversion for how you buy it. For example:
- Nails: buy in boxes of 25 kg, sell by kg.
- Wire: buy in 90-metre coils, sell by metre or by coil.
- Pipes: buy in bundles, sell by length (piece of 3 m or 6 m).
- Screws: buy in boxes of 100, sell by piece or box.
Your billing software should let you sell in either unit and reduce stock correctly. If you sell 15 metres from a 90-metre coil, the stock should show 75 metres left, not "one coil".
Step 3: Classify items by importance (ABC)
You cannot watch every item equally. Use ABC classification:
- A items: the 10 to 20% of items that bring in most of your sales value, such as cement, popular pipes and fast fittings. Check stock every week and never run out.
- B items: the middle group. Check every two weeks.
- C items: the large number of slow items. Check monthly, keep low quantities, and order only when needed.
Your sales report sorted by value for the last six months tells you which items fall in each group.
Step 4: Set reorder levels
For every A and B item, set a minimum stock level. When stock falls below it, the item appears on your low-stock list. A simple way to calculate it:
Reorder level = average daily sales × days your supplier takes to deliver + a small safety stock
For example, if you sell 20 metres of a pipe per day and the supplier takes 4 days, the reorder level is 80 metres plus a safety stock of, say, 40 metres, which makes 120 metres. Review these levels every season, because demand for items like PVC pipes and paints changes with construction and festival seasons.
Step 5: Count stock in small parts (cycle counting)
Counting the whole shop once a year takes days and rarely matches the books. Instead, count a small section every week: one rack this week, the paint section next week, fittings the week after. Correct differences in your software immediately and note the reason (damage, wrong billing, theft).
Over a few months, every item is counted, and your stock figures stay close to reality.
Step 6: Deal with dead stock
Run a report of items that have not sold in 180 days. For each:
- Check if the supplier will take it back or exchange it.
- Offer it to contractors at a discount.
- Bundle it with fast-moving items.
- Stop reordering it.
Dead stock is cash stuck on the shelf. Clearing even part of it frees money for items that sell.
Step 7: Organise the shelves to match the software
Stock control is easier when the physical layout follows the same logic as your item list. Group items on racks by category, label each rack and shelf with a simple code (for example R3-S2 for rack 3, shelf 2), and record that location in your software. When a new staff member searches for an item, the screen tells them where it is, and the customer is served faster.
Keep small, high-value items such as taps, locks, switches and power tools near the counter or in a locked display. Keep heavy, low-value items like cement, pipes and rods in the godown or at the back. Fast-moving items should be closest to the counter, so staff walk less during busy hours.
Purchase planning with suppliers
Most hardware shops buy from several distributors and brand dealers. Keep a supplier for each item in your software, so the low-stock list can be split by supplier and turned into purchase orders in minutes. Compare the rates you paid on the last few purchases before each order, and ask for scheme rates or cash discounts when you buy in larger quantities. Record purchase bills on the day they arrive, so stock and supplier balances are always current.
Contractors, credit and returns
Plumbers, electricians and builders often take material on credit and return the unused part. Record every return as a sales return against the original bill, so both stock and the contractor's balance are corrected. Set credit limits for each contractor, and send them a statement at the end of each month. Our guide on the udhar khata app covers credit tracking in detail.
GST and HSN codes for hardware items
Hardware items fall under many HSN chapters: iron and steel articles, plastics, electrical goods, paints and tools. Keeping the correct HSN code and GST rate on each item makes billing and GST returns accurate. Many hardware items moved between rate slabs after the GST changes of September 2025, so check your item rates once. See HSN codes on GST invoices for the digit rules.
Hardware stock management in Gaddibook
Gaddibook supports multiple units with conversions, low-stock alerts based on reorder levels, item-wise sales reports for ABC analysis, and slow-moving stock reports. Contractor credit, returns and statements are built in. See our hardware shop billing software and inventory management software pages.
FAQ
How do I manage stock in a hardware shop?
Use consistent item names, set the right units, classify items by importance, set reorder levels, count stock in small parts every week, and clear dead stock regularly.
What is the best software for a hardware shop?
Look for multi-unit support, fast item search, low-stock alerts, contractor credit tracking and GST billing. Test it with your own items before deciding.
How often should a hardware shop count stock?
Count fast-moving items weekly and the rest in rotating sections, so the whole shop is covered every two to three months.
How do I reduce dead stock?
Find items with no sales in 180 days, return or exchange what you can, offer the rest to contractors at a discount, and stop reordering them.
Can I sell wire by metre and stock it by coil?
Yes. Set the coil as the purchase unit and metre as the sale unit with a conversion, and the software keeps stock correct.
