Hardware store inventory: how a DIY shop or builders merchant counts from loose screws to paint and tools
By mise · Updated October 15, 2026
Quick answer: a hardware store counts by barcode where there is one (tools, paint, fittings, boxed fasteners) and by count or weight where there is not (loose screws in bins, chain by the metre or foot, cement by the bag). Tools are counted weekly, one aisle a week on rotation covers the rest, the yard quarterly, and minimums go only on the fast movers.
Scan the barcode on the tool, the paint can or the box of screws, or snap a photo: mise's AI finds the product and brings it back categorized, ready to count. In a hardware store or builders merchant that means counting the power tool wall in ten minutes and knowing which of twelve thousand items have not moved in a year.
A hardware store is the hardest retail inventory there is: ten to twenty thousand items, from a two-cent washer to a four-hundred-dollar drill, some sold by the piece, some by the pound, some by the foot. A DIY shop or builders merchant cannot count all of it every month, and does not need to.
What a hardware store counts, and in what unit
| Section | Unit | How to count |
|---|---|---|
| Hand tools, power tools, batteries, blades | Unit | Scan the barcode; weekly |
| Paint, primer, stain | Gallon (litre), quart, can | Scan each size; tinted cans as their own item |
| Loose fasteners in bins | Count or weight | Own item per bin; weigh with a Bluetooth scale or photo of the display |
| Chain, rope, wire, cable | Foot (metre) on the reel | Own item; measure or estimate what is left |
| Lumber; cement, sand, salt, grass seed | Piece by size; bag, pallet of 40 or 56 | Count pieces and bags; sealed pallets multiplied |
Loose bin stock and cut-to-length goods have no barcode of their own: create each bin and each reel once by hand, with a name and a photo, and count it by weight or estimate. For an odd label, snap a photo and mise's AI tries to identify it.
Where a hardware store loses stock
- Loose bins. Customers grab a handful, pay for ten, take fourteen. Nobody will count washers one by one; weigh the bin and accept a tolerance.
- Cut to length. Three feet of chain sold, four cut.
- Tool theft. Drills, batteries, blades and meters: small, expensive and easy to resell.
- Tinted paint. A custom colour not collected cannot go back on the shelf; write it off with a reason.
Cycle counting: one aisle a week, tools every week
| Section | When | Why |
|---|---|---|
| Power tools, batteries, blades, meters | Weekly | Theft and high value |
| One aisle on rotation; bins and reels monthly | Each week | Whole store covered in a quarter |
| Yard: lumber, bags, pallets | Quarterly | Pallet counts, weather damage |
Split the store into numbered aisles and the yard into bays; each team member counts one on their own phone with their own permissions. See cycle counting and ABC analysis.
Do it in mise
- Scan the barcode on the tool, the can or the box, or snap a photo: mise's AI finds the product and brings it back categorized.
- Loose bins and reels created once by hand with a name and a photo; weighed with a Bluetooth scale or a photo of the scale display.
- Cycle count one aisle a week and the tool wall every week with the team, each on their own phone with their own permissions.
- Movement history per item to find seasonal and long-tail dead stock; tinted paint and damaged stock written off with a reason.
- Minimum stock on the fast movers and a shopping list in PDF, Excel, WhatsApp or email split by supplier; invoices in XML, Excel or CSV; export to Excel and PDF.
7 days free, no card needed.
Dead stock and the reorder point in a store with twelve thousand items
No one can set a minimum on twelve thousand items, and no one should. Use the movement history per item to split the range: the few hundred items that sell every week get a minimum stock (par level); the long tail gets counted and reviewed once a year. Below the minimum the item turns red and goes on the shopping list with the quantity short. The list exports as PDF or Excel or opens in WhatsApp or email, split by supplier from the last invoice. Supplier invoices import as XML, Excel or CSV. See reorder point formula and dead stock.
Boxes, bags and singles: the same fitting three ways
A compression fitting comes as a single with its barcode, in a bag of 10 with another and in a trade box of 100 with a third. Keep the ones you actually sell as separate items. When a box is opened for the shelf, stock out one box and stock in 100 units, or count the shelf in units at the next count. See UPC vs EAN vs GTIN.
What mise does in a hardware store, and what it does not
In short, everything in the "Do it in mise" box above, with no limit on items, counts or scans.
Scan every box on the wall and what is missing comes out in money this week, not at year end. 7-day free trial, no card.
Start free
Frequently asked questions
How do I count loose screws and nails in bins?
Create one item per bin, by hand, once, and count it by weight on a Bluetooth scale or a photo of the scale display. Accept a tolerance: a bin of washers is not worth counting one by one.
How often should a hardware store count everything?
Never all at once except at year end. Tools weekly, one aisle a week on rotation, the yard quarterly: the whole store is covered every quarter.
How do I handle a fitting sold as a single, a bag of 10 and a box of 100?
Keep the ones you sell as separate items, each with its own barcode. When a box is opened for the shelf, stock out one box and stock in the units.
Does it work for several branches and a trade counter?
Yes: each branch, and the trade counter if you want it separate, is a location in the same account, with its own team and counts.
How much does mise cost?
7 days free, no card needed, to try it in your store.