Skip to content

Hardware Store Inventory List: Where to Start

A hardware store inventory list for a small shop: start with what sells every week, seasonal reorder levels, paint batches, the count, and a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

Questions people also ask

How do you inventory a hardware store?

Start with the items that sell every week and the seasonal ones, with a count, a reorder level, a cost and an aisle for each. Add the slower aisles one at a time, and count an aisle a week.

How do you track loose screws and bolts?

This example doesn't count them loose. It counts the boxes the bins are filled from, and reorders a size when its last full box is opened.

How should seasonal items be reordered?

With two reorder levels: one for the season, from what sells in a week and how long delivery takes, and zero outside it. Put the dates the levels change on a calendar.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.