My Client Was Alt-Tabbing Between an Auction Site and Excel. Now He Sees Deals Before His Competitors Do.
I walked into my first call with a steel trader in Korea. He shared his screen to show me his workflow.
He had the auction site open in one tab. Excel in another. He was manually copying prices, product specs, weights — dozens of columns — into a spreadsheet. Every few hours. Every day.
Here's what killed me: while he was focused on one auction, a special deal would pop up in the store section. By the time he noticed, it was gone. He was literally losing money because he couldn't watch two tabs at once.
And the Excel file? It was a graveyard. Thousands of rows, no history. When a price changed, he'd overwrite the old one. He couldn't answer basic questions like "what did 304 2B sell for last month?" because the data was gone.
But That Wasn't Actually His Problem
After a few more conversations, I realized he didn't need a better spreadsheet. He needed to understand his market. He'd been trading the same 3-4 steel specs for years — the ones he knew by instinct. He avoided others because he couldn't track enough to feel confident about what a fair price looked like.
So I built him a system that:
- Watches everything, all the time. Auctions, store specials, outlet deals. When an auction is about to close, it checks every 10 seconds. He doesn't miss anything anymore.
- Remembers everything. Every price, every product, every session. Nothing gets overwritten. He can pull up the price history of any product over the past 30 days in one click.
- Tells him what's a good deal. The system learns pricing patterns per steel type. It scores every item: is this priced below what similar products have sold for? He opens his dashboard in the morning and the best deals are right there.
- Tracks what actually sold. Not just what's listed — what moved. At what price. From which source. This was the aha moment for both of us.
The Aha Moment
Once he could see sold data aggregated by spec family, we started noticing trends neither of us expected. Certain specs were moving faster than he thought. Others that he considered "hot" were actually sitting. We were suddenly having strategic conversations about which product categories to focus on — not just reacting to whatever was in front of him.
And here's the thing that changed his business: because the system handles the monitoring, he started exploring steel types he'd never traded before. He didn't need to build gut instinct over years anymore. The data was already there. He could see the pricing patterns, see what was selling, and make informed bids on specs he would've ignored six months ago.
He's not just saving time. He's expanding into new markets he couldn't access before because the cognitive load was too high.
The Bottom Line
The whole thing runs on a single small server for about $50/month. He paid me to set it up, pays a monthly retainer, and the system has already paid for itself many times over in deals he would've missed.
If you're looking at small businesses and thinking "they just need a website" — look deeper. The real value is in the workflow they've been doing manually for years that they've stopped questioning. That's where the money is.