Skip to content

Gift Shop Inventory: Categories, Seasons and a Sheet

How to manage gift shop inventory: fast lines by item, the rest by group, seasonal buys with a sell-by date, consignment kept apart, and a free sheet.

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 · 7 min read

A gift shop sells a few of a great many things, which makes its inventory awkward: hundreds of items, most selling one or two a week, and a third of the year's sales in six weeks. Counting every card by its design isn't worth the time. Counting nothing means buying blind. The workable middle has four parts. Track your fast lines item by item. Track everything else by group, at an average cost. Treat seasonal stock as its own thing, with a date after which it's worth a fraction. And keep consignment goods on the sheet, and out of the value, because they aren't yours. Then count on a rota, and look at what each category has tied up against what it sells. Below is a sheet for a made-up shop in late November, how to buy for a season, and the file.

The short version

  • Fast sellers by the item. Slow, varied lines by the group.
  • Every row: on hand, reorder level, cost, supplier, where it is.
  • Seasonal lines have a sell-by date, not a reorder level.
  • Consignment: on the sheet, not in your stock value. Pay the maker when it sells.
  • Count one category a week.
  • TaroStack counts on a phone and shows what's sitting. More below.

An example sheet

Item Category On hand Reorder at Unit cost Value Status
Greeting cards, assorted Cards and paper 310 200 $1.75 $542.50 OK
Soy candle, 8 oz, local Home 22 18 $12.00 $264.00 OK
Earrings, assorted (consignment) Jewelry 44 30 $9.00 $396.00 OK
Chocolate bar, local Food 36 48 $3.10 $111.60 REORDER
Jam, 8 oz, local Food 19 24 $5.50 $104.50 REORDER
Holiday ornament, glass Seasonal 140 $4.20 $588.00 OK

Thirteen rows in all. The sheet's total is $3,218.30, of which $794 is consignment jewelry and mugs that belong to their makers. The shop's own stock is $2,424.30.

By item or by group

Kind of line Example Track
Few designs, steady sales The local candle, the jam, the best-selling mug By item: one row each
Many designs, each selling slowly Greeting cards, earrings, stickers By group: one row, a count, an average cost
One-offs A single hand-carved bowl By group, or not at all under a set value

Cards are the classic case. Three hundred cards in eighty designs is one row: 310 at an average of $1.75. When you reorder, you walk the spinner and fill the empty pockets. You don't need a spreadsheet to tell you which pocket is empty.

The test for moving something from a group to its own row: would you be annoyed to run out of it? If a particular card sells ten a week, give it a row.

Seasonal stock

Seasonal goods break the usual rule. There's no reordering: the order went in in the summer, it arrives once, and on a known date it's nearly worthless.

Holiday ornaments Advent calendars
Bought 240 60
Sold by November 20 100 26
On hand 140 34
Worth little after December 24 December 1
Weeks left 5 Under 2
Selling a week so far 10 3

The ornaments have sold about ten a week since they went out, and the big weeks are ahead: they may be fine. The advent calendars aren't. Thirty-four left, three a week, and after December 1 nobody wants one. The time to mark them down is now, while a discount still sells them, not on December 2.

Write three numbers when you place a seasonal order: how many, the date they stop selling, and the date you'll start marking down if they're behind. Then keep what's left in a note for next year's order: "bought 240, sold 190" is worth more than any forecast.

How much to buy

A simple version of what retailers call open-to-buy, for one category and one month:

Home, December
Sales you expect, at cost $2,400
Stock you want at the end of the month $900
Less stock on hand now −$1,150
Less already on order −$600
You can still buy $1,550

It stops the commonest gift shop mistake, which is buying at a trade show by eye. If the number is $1,550, the lovely $2,000 range of ceramics waits.

Consignment

Local makers' work on consignment is on your shelves and isn't your stock. Keep it on the sheet, marked, so you know what's there and what's sold. When a piece sells, you owe the maker their share, here 60%. Count it with the maker when they restock, and both sign. What the maker should be keeping at their end is in craft business inventory spreadsheet, and terms worth writing down in wholesale agreement template.

Counting

A full count of a gift shop is a long evening. Do it once a year, for the accounts. In between, count one category a week: jewelry this Monday, food next. Small, expensive and easy to pocket gets counted most. The method is in how to count inventory. What the shop should make on what it sells is in gift shop profit margin, and the plan for the business in gift shop business plan.

Food lines have dates. Chocolate and jam get a row on the dated-stock tab, oldest to the front.

Get the sheet

Download the gift shop inventory sheet. Four sheets: inventory with value and a REORDER flag, a lots sheet for seasonal orders, dated food and consignment drops, a count sheet to print, 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

The sheet is right on the night you count. A gift shop in December sells two hundred items a day, and nobody updates a spreadsheet from the till roll. By the second week the candle row says 22 and the table is empty. The reorder that should have gone on the 5th goes on the 14th, and arrives on the 23rd.

How TaroStack does it

TaroStack keeps the counts moving between full counts.

Counting on a phone, by category, in a few minutes, as often as you like. It suggests what to count first.

The count shows what a difference is worth before it's posted: six missing pairs of earrings is a dollar figure.

A reorder list in days of cover, with each supplier's lead time, so the candles are ordered while there's still a week of them.

Lots and dates for food lines, with an alert before a best-by passes.

Every adjustment carries a reason: damaged, lost, sample. Shrink is reported by reason and item.

Stock value by month, for the accountant.

The job Spreadsheet In TaroStack
Count a category Clipboard, then type it in On a phone, at the shelf
When to reorder the candles When the table looks thin The reorder list
What went missing A feeling The count, in dollars
Chocolate near its date Found in March An alert

TaroStack isn't a till. It connects to Square. Stock, counting and the reorder list are on every plan; Starter holds 50 items, and a shop's range wants Growth, at $39 a month for 3,000. 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 manage inventory in a gift shop?

Track fast sellers by item and slow, varied lines by group; give seasonal goods a sell-by date; keep consignment apart; and count one category a week.

How much inventory should a gift shop carry?

Work it out by category: expected sales at cost, plus the stock you want left at the end, less what's on hand and on order. That's what you can still buy.

How do you handle seasonal inventory?

Buy once, set a date it stops selling and a date to start marking down, and record what was left for next year's order.

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.