Skip to content

Toy Store Inventory: A List for a Small Shop

A toy store inventory list for a small shop: a row for each toy, seasonal reorder levels, the batch on each delivery for recalls, the count, 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 toy store's list has three jobs that a general shop's can skip. It has to cope with a season: the shop in this example sells more than four times as many board games a week from October to December as in the rest of the year, so a reorder level that's right in March is wrong in November. It has to be wide: many items, a few of each. And it has to hold the batch on each delivery, because when a recall notice names a batch, the shop has to know which boxes are that batch. So a toy store inventory list has a row for each toy a customer can buy, with on hand, a reorder level that changes by season, what one cost, and where it is, and a second sheet where each delivery's batch or tracking label is written down. Below is a list for a made-up neighborhood toy store, how to set levels for the holidays, what to record for recalls, and the file.

The short version

  • One row for each toy a customer can buy, down to size and edition.
  • Unit cost is what you paid, not the price on the shelf.
  • Two reorder levels: one for the holiday season, one for the rest of the year.
  • Write the batch or tracking label from each delivery.
  • Count a section a week. Count everything in January.
  • Summer and holiday toys sit at zero in the off season.
  • TaroStack keeps stock by lot and counts on a phone. More below.

An example list

Counted in the second week of November.

Item Unit On hand Reorder at Unit cost Value Status
Building blocks, 100 piece set each 14 12 $11.50 $161.00 OK
Wooden train set each 6 6 $22.00 $132.00 REORDER
Plush bear, 12 in each 22 15 $6.40 $140.80 OK
Jigsaw puzzle, 500 piece each 9 10 $9.60 $86.40 REORDER
Board game, family each 11 8 $15.80 $173.80 OK
Card game, kids each 30 20 $4.90 $147.00 OK

Ten rows in all, $1,072.05 at cost, with four to reorder: train sets, puzzles, marker sets and slime kits. The kite on the list has four on hand and a level of zero. Nobody buys a kite in November, and it'll get a level in March.

Holiday levels

Family board game Jan to Sep Oct to Dec
Sold in a week 2 9
Weeks to get a delivery 2 3
Sold while waiting 4 27
Cushion 4 9
Reorder at 8 36

The numbers are this shop's own. Two things change in the season, not one: the game sells more than four times as fast, and the distributor takes a week longer. The level goes from 8 to 36. The list above still shows 8, which is the mistake to catch: with 11 on hand it reads OK, and at nine a week it's just over a week from empty with a three-week wait.

Set the season's levels in September, from last year's sales by week, and put the date on the calendar. The sum is in reorder point example. Ask each supplier for its last order date for delivery before the holidays, and put that on the calendar too.

Batches, for recalls

Received Item Lot or tracking label Quantity Use by Note
Nov 9 Plush bear, 12 in Tracking label PB-2609-A 24 Batch from the label sewn into the seam
Nov 12 Slime kit Lot SK-1147 12 Jun 1, 2028 Use-by printed on the box
Oct 28 Building blocks, 100 piece set Tracking label BB-2608 18

A product made mainly for children 12 and under carries a tracking label that says who made it, where, when and in which batch. When a recall names a batch, a shop that wrote that label down at receiving can go straight to the right boxes, and can say how many it had and how many are left. A shop that didn't pulls every bear in the building. What the label is and where to find it is in CPSIA tracking label requirements.

Some stock has a date as well. This shop's slime kits carry a use-by. Write the date where there is one.

Counting

Count a wall or a shelf a week, in the order of the list. In January, after the returns, count everything: it's the opening number for the year and the one the accountant wants. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A general shop's version is in store inventory sheet, and a count plan in cycle count form.

Get the list

Download the toy store inventory. Four sheets: inventory with value and REORDER, deliveries with tracking labels 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

In December nobody subtracts a day's sales from a spreadsheet at nine at night. So in the weeks when knowing what's left matters most, the list is furthest from true, and reorders are made by walking the floor.

How TaroStack does it

TaroStack keeps the list current through the season.

Receiving adds each delivery as a lot, with its tracking label or batch, at what you paid.

Counting works on a phone with no signal, in the back room. 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 stock actually moves.

One report for a lot: how many came in, and how many are left. Starting a recall holds what's still in stock.

Barcodes by phone camera or scanner, for counting and receiving.

The recall notice Paper In TaroStack
Do we have that batch Open every box Search the lot
How many came in, how many are left Unknown The lot's stock
Stop selling them now Tell everyone Starting a recall holds the lot
What to reorder this week Walk the floor A reorder list

TaroStack doesn't run the register. It connects to Square. Stock, lots, counts 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 keep inventory for a toy store?

A row for each toy with the count, a reorder level, the cost and where it's kept, plus a record of each delivery's batch. Count a section a week and everything in January.

How should a toy store set reorder levels for the holidays?

Separately from the rest of the year: what sells in a week in the season, times the weeks a delivery takes then, plus a cushion. In the example a board game's level goes from 8 to 36.

Why record the batch of a toy?

Recalls of children's products are by batch. A shop that recorded the tracking label at receiving can find the affected stock without opening every box.

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.