Skip to content

Sticker Inventory Spreadsheet: Designs, Days Left

A sticker inventory spreadsheet: a row for each design, how many days of stock each has left, when to reprint, price breaks, and seasonal sets.

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 sticker shop's stock is small, flat, cheap, and split across dozens of designs that sell at wildly different speeds. So a sticker inventory spreadsheet has one row for each design and size, and the number that matters on each row isn't how many are in the drawer. It's how many days they'll last. A hundred of a design that sells twelve a day is an emergency. Two hundred of one that sells two a day is three months. The sheet works out a reorder level for each design from how fast it sells and how long the printer takes. Seasonal designs get a sell-by date. And the supplies around them (backing cards, sleeves, mailers, vinyl if you print at home) each get a row. Below is a sheet for a made-up shop in November, the days-left sum, and the file.

The short version

  • One row for each design and size.
  • Days left = on hand ÷ sold a day. Reorder when it's close to the printer's lead time.
  • Reorder bestsellers early and in quantity. Reorder slow designs small, or retire them.
  • A bigger print run is cheaper each and can be a drawer of dead stock.
  • Seasonal designs: a sell-by date and a plan for what's left.
  • TaroStack counts designs and supplies, and suggests reorder points from real sales. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Mountain sunrise, 3 in die cut each 142 100 $0.31 $44.02 OK
Plant mom, 3 in die cut each 38 100 $0.31 $11.78 REORDER
Sourdough starter, 2.5 in each 210 75 $0.27 $56.70 OK
Local map, 4 in each 64 75 $0.42 $26.88 REORDER
Holiday set of 5 set 88 0 $1.35 $118.80 OK
Mystery pack of 10 seconds pack 12 10 $1.10 $13.20 OK

Eleven rows in all, $385.68 of stock, with five to reorder: two designs, laminate, sleeves and mailers. The whole shop's stock is worth less than $400, which is why sticker sellers rarely count it, and why they run out.

Days left

Design Printed Sold In Sold a day On hand Days left
Plant mom 250 on Nov 3 212 17 days 12.5 38 3
Sourdough starter 500 on Jun 1 290 172 days 1.7 210 124
Holiday set 200 on Oct 12 112 39 days 2.9 88 31

Plant mom has three days of stock and the print shop takes seven. It's already late. Its reorder level of 100 is a week of sales at 12.5 a day, plus a few: the reorder should have gone in when the drawer held 100, and the next order should be 500, not 250.

Sourdough starter has four months left. Leave it alone.

The holiday set has 31 days of stock at its current pace and 25 days of season. That's about 16 sets over. December usually sells faster than November, so it may clear. Decide now what happens to what's left on the 15th: a discount, a mystery pack, or next year's drawer.

Price breaks

A print shop's price falls with the size of the run.

Run Price each The run costs At 2 a day, it lasts
250 $0.31 $77.50 4 months
500 $0.22 $110.00 8 months
1,000 $0.16 $160.00 16 months

Nine cents saved on each sticker is real for a design that sells. For one that sells two a day, a thousand is sixteen months of stock. If the design stops selling in month six, the cheap run was the expensive one. Order the big run for proven bestsellers and the small run for everything new.

Slow designs don't have to be thrown out. Bundle them into mystery packs, which is what the "seconds" row on the sheet is, or add one free to each order.

Supplies

Backing cards, clear sleeves and rigid mailers go out with every order, so they sell at the speed of the whole shop, not of one design. Sleeves are at 180 and mailers at 95 on this sheet. At 30 orders a day, 95 mailers is three days.

If you print and cut at home, vinyl and laminate are counted in sheets, with how many stickers a sheet makes written beside them. Laminate is at 35 sheets against a level of 50.

Pricing is in how to price stickers, the business in sticker business plan, and stock for an online shop in Etsy inventory spreadsheet. What to bring to a market is in craft fair inventory sheet.

Get the spreadsheet

Download the sticker inventory spreadsheet. Four sheets: inventory with value and REORDER, print orders with sell-by 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

The days-left sum needs sales by design, and those are in the online shop's reports, not the spreadsheet. With forty designs, somebody has to copy forty numbers across every week and take every order off the drawer counts. Nobody does. So the sheet gets counted when a design runs out, which is the one moment it's no use.

How TaroStack does it

TaroStack keeps the counts and works out the pace.

Each design is an item, counted in eaches, with what each print run cost.

A reorder list in days of cover, with reorder points suggested from how fast each design really sells and each printer's lead time.

Packing can be a recipe. Record the day's packed orders as a batch, and the backing cards, sleeves and mailers come off stock.

Count on a phone, at the drawers, with no signal. TaroStack suggests what to count.

Margins by product on real cost, so the 16 cent run shows beside the 31 cent one.

The job Spreadsheet In TaroStack
Days of stock for each design Copy sales in, divide Days of cover
When to reprint the bestseller When it's gone The reorder list
Mailers before they run out Noticed at the packing table The reorder list
What a design really cost The last run's price From what you paid

Stock 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 I keep track of sticker inventory?

Give every design and size a row, count on a set day, and work out days of stock left from how many sell a day. Reorder when the days left get close to your printer's lead time.

How many stickers should I order of a new design?

A small run. In this example 250 costs $77.50. Order the larger, cheaper run once the design has shown it sells.

How do I organize stickers?

By design, in labeled drawers or envelopes, bestsellers nearest the packing table, with a count on the label that's updated when a run arrives.

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.