A hardware store's trouble with inventory is the count of things, not their value. A candle shop has forty items. A hardware store has thousands, most of them small, cheap and sold a few at a time. Nobody builds that list in a weekend, and the stores that try give up in aisle 3. The way in is to list what sells every week and what's seasonal first, give each row an on-hand count, a reorder level, a cost and an aisle, and add the slow aisles one at a time. Below is a starting list for a made-up neighborhood store, how seasonal levels work, what to write down about paint, and the file.
The short version
- Start with the fast sellers and the seasonal items. Add an aisle a month.
- One row for each thing a customer can buy: size, length and pack count make separate rows.
- Unit cost is what you paid, not the shelf price.
- Seasonal items get a reorder level for the season and zero outside it.
- Write down the batch of each paint delivery.
- Count an aisle at a time, on a schedule.
- TaroStack keeps stock current and counts it on a phone. More below.
An example list
Counted on a Sunday in the middle of November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Deck screws, #8 x 2-1/2 in, 1 lb box | each | 42 | 24 | $6.20 | $260.40 | OK |
| Wood glue, 16 oz | each | 18 | 12 | $4.85 | $87.30 | OK |
| Paint, interior white, 1 gal | each | 9 | 12 | $21.40 | $192.60 | REORDER |
| Painter's tape, 1.5 in | each | 36 | 24 | $3.10 | $111.60 | OK |
| Furnace filter, 16x25x1 | each | 14 | 20 | $5.60 | $78.40 | REORDER |
| Ice melt, 20 lb bag | bag | 30 | 40 | $7.25 | $217.50 | REORDER |
Ten rows in all, $1,440.70 at cost, with three to reorder: white paint, furnace filters and ice melt.
What a row is. Deck screws in a 1 lb box and in a 5 lb box are two rows. So are a 25 ft and a 50 ft extension cord. The test is whether you reorder them separately. A code for each row helps once the list is long: see how to create SKU numbers.
Loose items. Screws, bolts and washers sold from bins by the piece or the pound are the hard case. This store counts bins by the box they're filled from: when the last full box of a size is opened, that's the reorder signal. It doesn't count loose screws.
Seasonal levels
| Ice melt, 20 lb bag | Nov to Feb | Mar to Oct |
|---|---|---|
| Sold in a week | 15 | 0 |
| Weeks to get a delivery | 2 | |
| Sold while waiting | 30 | |
| Cushion | 10 | |
| Reorder at | 40 | 0 |
A reorder level is what sells while you wait for the truck, plus a cushion. For a seasonal item that's two numbers, not one. This store's ice melt sells fifteen bags a week in winter and none in summer, so its level is 40 from November and zero from March. The numbers are this store's own. The sum is in reorder point example.
The way to get caught is a level still on its summer setting when the first cold week arrives. Put the dates the levels change on the calendar. Furnace filters, fans, grass seed, canning jars and holiday lights all work the same way.
Things with batches and dates
| Received | Item | Lot or batch | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 2 | Paint, interior white, 1 gal | Batch 26K114 | 12 | Sell one job from one batch where you can | |
| Oct 12 | Wood glue, 16 oz | Lot 0926 | 24 | Oct 1, 2027 | |
| Sep 30 | Furnace filter, 16x25x1 | 40 | Fall order: next one in January |
Most of a hardware store has no dates. A few things do, such as glues, caulks, batteries and garden seed. Paint cans carry a batch number, and this store tries to sell one job from one batch, because a shade can vary a little between batches. Writing the batch on the delivery row lets you answer "do you have three more from the same batch?" without reading every lid.
Counting
Nobody counts a hardware store in a day. Count an aisle a week, on the same morning, so every aisle is counted several times a year and the fast aisles more often. The file's count sheet takes what the list said and what you found, and works out the difference at cost. How to schedule it is in cycle count form, and a general shop list in store inventory sheet.
Get the list
Download the hardware store inventory list. Four sheets: inventory with value and REORDER, deliveries with batches and dates, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A list of two hundred rows is right on the Sunday it's counted. By Wednesday the register has sold three hundred things and nobody has typed one of them in. The reorder column goes stale first, and after that the list is something you update for the accountant in January. Seasonal levels kept in someone's head leave with that person.
How TaroStack does it
TaroStack keeps the list current between counts.
Receiving adds stock as it arrives, with or without a purchase order, at what you paid, with a lot or batch where there is one.
Counting works on a phone with no signal, aisle by aisle. A count shows what each difference is worth.
A reorder list in days of cover, with each supplier's lead time and minimum, and reorder points suggested from how fast things really sell.
Barcodes by phone camera or scanner, for counting and receiving.
Every adjustment carries a reason: damaged, stolen, used in the shop.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What's on hand | As of the last count | Kept current |
| What to reorder, from whom | Rows that look low | A reorder list by supplier |
| Counting aisle 4 | Clipboard, then typing | On the phone, valued |
| Which paint batch is on the shelf | Read the lids | Stock by lot |
TaroStack doesn't run the register. It connects to Square. Stock, counts, receiving and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
