Why my t-shirt business finally ditched the spreadsheet inventory system

I ran a small online clothing brand for six years before I hit a wall. We sold tees with hand-drawn animals—owls, badgers, sometimes a fox with a top hat. Orders trickled in, I shipped them from my garage, and life was fine. Then one day I realized I had no idea which designs were actually making money.

My inventory tracking was a single Google Sheet with color-coded cells. Pink meant “low stock.” Yellow meant “order more.” Red meant “panic.” But pink and yellow started looking the same after a late night of packing. I remember staring at a box of unsold “Goose in Sunglasses” shirts and wondering how I ended up with forty of them. That goose was a good design. People liked it. But they did not buy it. I had placed a bulk order based on a hunch, not real sales data. That mistake cost me $600 and a lot of storage space. About that time I found a small shop run by someone who printed custom goose shirts and saw they used a different approach. They did not guess. They tested small batches first. That simple idea changed how I thought about inventory.

How guessing at inventory nearly killed my profit margin

My old method was simple: pick a design I liked, order fifty shirts, and hope. Sometimes it worked. A “Basset Hound in a Bowtie” sold out in two days. But more often I ended up with boxes of “Pigeon with a Briefcase” collecting dust. Every unsold shirt ate into my bottom line. The fabric costs, the printing fees, the storage—it all added up. I calculated once that 15% of my total inventory never sold. That 15% was money I could have used to buy more of the designs people actually wanted. Spreadsheets did not tell me that. They just told me I had seventeen pigeons left.

The moment I realized I needed a better system

I attended a small local market with a table full of tees. A woman walked up and asked if I had a “Running Cat” shirt in size medium. I said no, because I had run out two weeks earlier. She frowned and left. Later I saw her buy a similar shirt from another vendor. That other vendor had a simple system: he only printed a few copies of each design at a time, then reordered based on what actually sold. He told me he rarely had more than ten units of any single design in stock at once. That meant less risk, less storage, and less panic. I asked him how he kept track. He pointed to a paper notebook. “I write down every sale, every day,” he said. It was not fancy. But it worked better than my color-coded spreadsheet.

What I changed in my own shop

I switched to a print-on-demand model for new designs. Instead of ordering fifty shirts upfront, I ordered five or ten. If a design sold out in a week, I ordered more. If it sat for a month, I dropped it and tried something else. That shift let me test ten new designs per month instead of two. Most flopped. That was fine. The cost of a flop dropped from $600 to $60. I also stopped keeping all inventory in my garage. I used a small fulfillment center that charged by the box. That freed up space and let me focus on design, not packing. Here is what my new system looks like:

• Test every design with a small batch of 5 to 10 units first.
• Track daily sales in a simple notebook, not a complex spreadsheet.
• Reorder a design only when it sells out within 14 days.
• Drop any design that does not sell at least 3 units in the first month.
• Keep no more than 20 units of any single design in stock at once.
• Use a fulfillment partner so I do not have to store unsold boxes.

What I learned about the real cost of guessing wrong

The biggest lesson was that inventory is not just about having enough product. It is about having the right product. When I guessed wrong on a design, I did not just lose the money for those shirts. I lost the chance to use that space and cash for a design that could have sold. My “Pigeon with a Briefcase” shirts took up room that could have held more “Basset Hound in a Bowtie” shirts. The spreadsheet told me I had pigeons. It did not tell me I was losing potential sales every day by keeping them. That is the hidden cost. If you run a small product business, ask yourself this: how many of your products are really earning their keep? How many are just taking up space because you guessed wrong once and never corrected?