In a t-shirt inventory, "heather grey tee" isn't an item. "Heather grey tee, large" is. Sizes don't substitute for each other, so every color and size gets its own row, its own count and its own reorder point. Those reorder points follow a size curve, because sizes don't sell evenly: for most adult lines, large sells about three times as fast as small or 2XL. The rest of the sheet depends on how you print. A shop that presses transfers counts transfers by design. One that prints to order holds blanks and almost no finished shirts. Below is a sheet for a made-up shop that presses transfers, the size curve worked out, and the file.
The short version
- One row for each color and size.
- Set reorder points on a size curve, from your own sales.
- Count transfers or screens by design, apart from the shirts.
- Hold blanks, not printed shirts, wherever you can.
- Note the dye lot on each carton. "Heather grey" varies.
- TaroStack takes the right size blank and the transfer off stock with each batch. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Blank tee, heather grey, S | each | 14 | 12 | $3.40 | $47.60 | OK |
| Blank tee, heather grey, M | each | 22 | 24 | $3.40 | $74.80 | REORDER |
| Blank tee, heather grey, L | each | 41 | 36 | $3.40 | $139.40 | OK |
| Blank tee, heather grey, XL | each | 20 | 24 | $3.40 | $68.00 | REORDER |
| Blank tee, heather grey, 2XL | each | 9 | 12 | $4.90 | $44.10 | REORDER |
| Transfers, 'Summit' design | each | 18 | 50 | $1.25 | $22.50 | REORDER |
Twelve rows in all, $789.30 of stock, with five to reorder.
The size curve
This shop's sales of adult tees over three months:
| Size | Share of sales | Out of every 12 | Reorder point |
|---|---|---|---|
| S | 10% | 1 | 12 |
| M | 22% | 2.5 | 24 |
| L | 32% | 4 | 36 |
| XL | 23% | 3 | 24 |
| 2XL | 13% | 1.5 | 12 |
The reorder points are a month of sales at about 110 shirts a month in this color. Order to the curve as well: a reorder of 144 grey tees is roughly 14, 32, 46, 33 and 19, not 29 of each. Ordering evenly is how a shop ends up with forty mediums and no larges.
Your curve is your own. Youth-skewed designs run small. Workwear runs large. Take three months of sales by size and divide.
2XL and up cost more a blank, here $4.90 against $3.40. Price for it, or accept it, but know it: see how to price t-shirts.
Blanks, not printed shirts
A blank can become any design. A printed shirt is that design, in that size, for good. Every printed shirt on the shelf is a guess about what someone will want.
| Blank | Printed | |
|---|---|---|
| Can be sold as | Any design in that color and size | One design, one size |
| Rows to stock 5 sizes of 3 designs | 5 | 15 |
| If the design stops selling | Nothing lost | Clearance |
So this shop keeps six printed larges of its best design for walk-ins and presses everything else to order from blanks and transfers. The transfer is the design in storable form: 64 'Trailhead' transfers can go on any size.
Dye lots and transfer dates
| Received | Item | Order or run | Quantity | Note |
|---|---|---|---|---|
| Oct 21 | Blank tee, heather grey, L | PO 1188 | 72 | Dye lot 5521 |
| Sep 9 | Blank tee, heather grey, 2XL | PO 1162 | 24 | Dye lot 5390: slightly lighter |
| Nov 3 | Transfers, 'Trailhead' | Run TR-1103 | 100 | Best pressed within six months |
| Nov 12 | Printed tee, 'Trailhead', grey, L | TP-1112 | 12 | Blanks PO 1188; transfers TR-1103 |
Heathers and garment-dyed colors shift between dye lots. A team order of twenty shirts across two lots shows two greys in the team photo. Fill a matching order from one lot, and check the carton label when it arrives.
Transfers age. This shop's printer says six months, after which they may not release cleanly. The sheet carries that as a use-by.
Mugs and tumblers are counted the same way, by blank, in sublimation inventory template. Listings that have to match the shelf are in Etsy inventory spreadsheet, and what a shirt business needs before selling in t-shirt business license.
Get the template
Download the t-shirt inventory template. Four sheets: inventory with value and REORDER, lots, a count sheet, and a read-me. Add a row for each color and size you carry. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Three colors in five sizes is fifteen rows of blanks. Add two more colors and youth sizes and it's forty. Each order takes one blank from one of them and one transfer, and the online listing shows "in stock" for a design whether or not the large grey blank it needs is on the shelf.
How TaroStack does it
TaroStack ties each printed shirt to the exact blank it uses.
Each printed shirt is a recipe. One grey large blank, one 'Trailhead' transfer, a neck label, a mailer. Record a batch and those exact rows go down.
"What could I make right now" says how many 'Trailhead' larges you can press: the lower of the blanks and the transfers.
The batch notes the lots. Which carton of blanks and which transfer run, automatically.
Reorder points suggested from how stock moves. Each size gets its own, from its own sales, which is the size curve without the arithmetic.
A reorder list in days of cover, by size.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take off the right blank | Find the row | The recipe names it |
| Can I press this order? | Check two rows | What could I make right now |
| Reorder points by size | Work out the curve | Suggested from sales |
| Which dye lot went on that order | A note | On the batch record |
Starter holds 50 items and 5 recipes, which a shop with several colors and sizes outgrows quickly; Growth holds 3,000 items and 50 recipes. Stock, lots and recipes are on every plan, from $9.99 a month or $39 a month for Growth. 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.
