A sublimation shop mostly makes to order, so its stock isn't finished goods. It's blanks: coated mugs, tumblers, coasters and mouse pads waiting for a design. A sublimation inventory template counts each blank by type and size, with a reorder point, and keeps the case lot it came from, because coating varies between batches and a new case can press differently from the last. It counts ink by color, with the date on each bottle, since one empty color stops every job. And it lists paper, shrink wrap, tape and boxes. Below is a sheet filled in for a made-up shop, the sum for how many prints a bottle makes, and the file.
The short version
- Blanks by type and size, counted in eaches.
- Each case of blanks is a lot. Test a new lot before a big order.
- Ink by color and bottle, with the maker's date.
- Know how many prints a bottle and a pack of paper make.
- Count misprints. They're blanks you paid for.
- TaroStack takes the blank, paper and box off stock with each order you make. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Mug, 11 oz white, coated | each | 142 | 108 | $1.45 | $205.90 | OK |
| Mug, 15 oz white, coated | each | 30 | 36 | $1.95 | $58.50 | REORDER |
| Tumbler, 20 oz skinny | each | 58 | 50 | $3.60 | $208.80 | OK |
| Sublimation paper, 8.5 x 11 | sheet | 310 | 200 | $0.14 | $43.40 | OK |
| Ink, magenta, 140 mL | bottle | 1 | 1 | $19.00 | $19.00 | REORDER |
| Mug boxes, single | each | 85 | 100 | $0.48 | $40.80 | REORDER |
Twelve rows in all, $832.60 of stock, with four to reorder: 15 oz mugs, magenta and black ink, and mug boxes.
What a bottle makes
Ink use depends on the design, so this is one shop's figure, worked out by counting.
| A bottle of ink | 140 mL |
| Full-wrap mug prints from a set of four bottles | about 700 |
| Ink cost a mug (four bottles at $19) | about $0.11 |
| Paper a mug (one sheet prints two wraps) | $0.07 |
The useful part isn't the eleven cents. It's that colors don't run out together. This shop's designs lean on magenta and black, which is why those two are at their reorder point while cyan and yellow have a spare. Keep one unopened bottle of every color, and reorder when you open it. A reorder point of 1 on the sheet means exactly that.
Paper is simpler: 310 sheets at two mug wraps a sheet is 620 mugs, or 310 tumblers.
Blanks have lots
| Received | Item | Case lot | Quantity | Note |
|---|---|---|---|---|
| Oct 14 | Mug, 11 oz white | 25-3381 | 144 | 4 cases of 36 |
| Aug 2 | Mug, 11 oz white | 25-2907 | 36 | Last case of the old lot: prints slightly warmer |
| Oct 30 | Tumbler, 20 oz skinny | T-1187 | 75 | 3 cases of 25 |
| Sep 20 | Ink, magenta | INK-M-2409 | 2 bottles | Use by Sep 2027 |
The coating on a sublimation blank is what takes the dye, and it isn't identical from one production run to the next. The note on the August case says it all: prints slightly warmer. On a single mug nobody would know. On an order of forty matching mugs, split across two case lots, the customer lines them up on a shelf.
So: press one test from every new case lot before using it for an order. Fill a matching order from one lot. And write the case lot on the order, so that a reorder in March can be matched, or the customer warned that it can't.
Ink has a date too. Old ink shifts color and can clog. The sheet flags a bottle USE FIRST inside 60 days of the maker's date.
Misprints
A ghosted wrap or a crooked design is a blank, a sheet of paper and some ink in the bin. Count them. This shop loses about one mug in twenty, which adds 7 cents to the cost of every good one and, more to the point, means an order of 40 needs 42 blanks on the shelf. A row on the count sheet for "misprints this week" is enough.
If the misprint rate jumps with a new case, that's the lot test you didn't do.
Pricing the finished pieces is in how to price tumblers. Shirts are counted by size as well as type, in t-shirt inventory template, and the sums for a shop are in sublimation business plan.
Get the template
Download the sublimation inventory template. Four sheets: inventory with value and REORDER, lots with days left for ink, a count sheet, 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
Every order takes a blank, a sheet of paper, a little of four inks, a shrink sleeve and a box. Six rows change with each one. On a day of thirty orders nobody touches the spreadsheet, and the 15 oz mugs go from "REORDER" to "none" without the sheet noticing.
How TaroStack does it
TaroStack takes the parts off when you record what you made.
Each product is a recipe. One blank, a sheet of paper, a sleeve, a box. Record thirty mugs and thirty of each come off stock.
Blanks are lots. Each case is received with its lot. The batch record notes which case the mugs came from, automatically, so an order can be matched later.
"What could I make right now" says how many of a product the blanks, paper and boxes on hand allow, and which runs out first.
A reorder list in days of cover, with reorder points suggested from how fast things really go.
Misprints are adjustments with a reason, so the month's waste is a number.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take off blank, paper, box | Six rows an order | Recorded with the batch |
| Which case lot went on this order | A note | On the batch record |
| What's about to run out | Notice | The reorder list |
| Misprints this month | A tally | Waste by reason |
Ink by the millilitre is hard to track from a recipe, since designs vary: most shops count bottles instead, and so does the example. Stock, lots and recipes are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
