I had a conversation with a distributor rep last week that summed up my entire career in record retail. He pitched me a limited pressing of a Melbourne post-punk band’s second album. 300 copies pressed. Coloured vinyl. The artwork looked incredible.

My gut said order ten. My spreadsheet said order four.

I ordered four. Sold three in the first week. Got one sitting there for the collectors who’ll show up eventually. That’s the right number. Two years ago, I would’ve ordered ten and spent the next eighteen months staring at six unsold copies gathering dust next to the Eddy Current Suppression Ring reissues that also didn’t move as fast as I thought they would.

The Expensive Education

Running Spank Records since 2004 means I’ve had roughly two decades of expensive lessons in stock management. Every record store owner has their graveyard shelf. Mine used to be much bigger.

The problem was never taste. I still back every record I’ve ever stocked. The problem was volume. How many copies of a thing should you carry when your shop is 80 square meters and your rent is what it is in Melbourne’s inner north?

For years, I operated on a system I’ll charitably call “vibes-based procurement.” A record sounded good, so I’d order a bunch. A label I trusted put something out, so I’d grab the maximum allocation. A customer asked about something, so I’d order five copies assuming their friends wanted it too.

Sometimes that worked brilliantly. I sold through my entire first order of Amyl and the Sniffers’ debut in three days. Other times it was a disaster. I’m still sitting on copies of records from 2018 that I was absolutely certain would fly.

What Changed

About eighteen months ago, I started actually looking at the sales data my POS system had been quietly collecting for years. Not in a complicated way. I just exported a spreadsheet every month and started tracking a few things.

Sell-through rate by price point. Records priced between $35-45 AUD move fastest in my shop. Below $30, people get suspicious about quality. Above $55, they hesitate unless it’s something they specifically came in for. This was genuinely surprising to me. I thought cheaper records would move faster, but my customers associate low prices with dodgy pressings.

Genre velocity. My psych and garage section is smaller than my indie rock section by about 40%, but it turns over almost twice as fast. That means I was massively under-investing in psych relative to demand. When I rebalanced, revenue from that section went up about 25% in a quarter without adding a single extra shelf.

Day-of-week patterns. Saturday is obviously the biggest day, but Thursday evenings are surprisingly strong. People come in after work before heading out for the night. Knowing this changed when I put new arrivals on the floor. Thursday morning, not Monday.

The Human Part Still Matters

Here’s what the data doesn’t tell me: what to stock in the first place. No spreadsheet is going to tell me that the new Civic Radials release is going to resonate with my customers, or that there’s a growing appetite for Japanese ambient vinyl among people who usually buy punk. That’s still ears, conversations, and twenty years of watching what people reach for.

A mate put me onto Team400 when I was trying to figure out if there was a smarter way to handle restock alerts. They helped set up something that pings me when a title’s sell-through rate crosses a threshold, so I’m not manually checking every week. It’s simple, but it saves me a couple of hours that I’d rather spend listening to promos or talking to the person at the counter.

The key is that the data supports decisions I’m already making. It doesn’t make the decisions for me. When the spreadsheet and my gut agree, I order with confidence. When they disagree, I dig deeper. Usually one of them is wrong, and it’s about 50/50 which one.

What I’d Tell Other Store Owners

Track your sell-through rates. Seriously, just that one metric will change how you order. It takes ten minutes a week once you’ve got the export sorted, and it’ll save you thousands a year in dead stock.

But don’t let the numbers override what you know about your community. Your regulars trust you because you’ve got taste, not because you’ve got an algorithm. The data is there to stop you from making expensive mistakes, not to tell you what music matters.

I still order things that I know won’t sell fast. I’ve got a section of experimental Australian electronic music that turns over slowly, but every copy that sells goes to someone who becomes a loyal customer. That’s worth more than the turn rate suggests.

The four copies of that post-punk record? Perfect number. The data and the gut agreed. That’s the sweet spot.