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.
