You bought a collection for $800. You’ve been listing cards on eBay for three months. You’ve sold $600 worth so far.
Are you profitable?
Most resellers would say “not yet.” But that’s the wrong question. The real question is: do you actually know?
Because once you factor in eBay fees (12-15%), shipping supplies, grading costs, and the time you spent listing the real answer might be “yes, you’re already ahead.” Or it might be “you’ve been losing money since week two.” The only way to know is to track it properly.
Here’s the system I use to track the ROI on every collection I buy and why I stopped doing it in spreadsheets.
The Problem With Spreadsheets (And Your Memory)
I’ve bought hundreds of collections. For years, I tracked them in Google Sheets. A tab per collection, cost of acquisition at the top, sales logged one by one.
In theory, great. In practice, terrible.
The sheet was always two weeks behind. I’d forget to log a sale. I’d start a new tab and lose the old one. I’d sell cards from three different collections in one eBay session and have no idea which sale went where.
The bigger problem: spreadsheets don’t tell you why something is working or not. They just log numbers. You still have to do the thinking.
The 5 Numbers That Actually Matter for Collection ROI
Before I get into tools, let’s nail down what you’re actually trying to track:
1. Acquisition cost What you paid for the collection, all-in. Include gas, shipping, any fees.
2. Gross revenue Total selling price across all sales from that collection.
3. Platform fees eBay takes ~12-15% of every sale. WhatNot takes 8%. These compound fast at volume.
4. Additional costs Grading fees (PSA, BGS, SGC), shipping supplies, grading submission shipping. These hit your margin harder than most resellers realize.
5. Sell-through rate What percentage of the collection have you actually sold? This tells you if you’re sitting on dead inventory and whether your acquisition price was right.
Real ROI = Gross Revenue Acquisition Cost Platform Fees Additional Costs
That’s it. But most resellers can only tell you the gross revenue number. The rest lives in their head or nowhere at all.
How to Actually Track It: The System
Step 1: Log the Acquisition Immediately
The moment you buy a collection, create a record. Log what you paid, where you bought it, and a rough breakdown of what’s in it. Don’t wait until you’re home. Don’t trust your memory.
Step 2: Connect Your eBay Account
If you’re doing any volume at all, manual entry is a losing battle. Connect your eBay store to a dashboard that pulls your sales automatically. When a card sells, you want that sale automatically attributed to the right collection not logged by hand at midnight.
Step 3: Log Grading Fees as Collection Expenses
This is where most resellers leak money without knowing it. You send 15 cards to PSA. $18/card = $270. Six months later, you’ve completely forgotten that $270 when you’re counting up what the collection made.
Log every grading fee as an expense tied to the specific collection it came from. It changes the math dramatically.
Step 4: Track Sell-Through, Not Just Revenue
A collection that’s made $1,200 but still has 400 cards left is a very different situation than one that’s made $800 with 12 cards left.
Sell-through rate tells you whether your pricing is right, whether you should be listing faster, and when to close out a collection at a slight loss to free up cash.
Step 5: Compare Collections Against Each Other
After you’ve tracked 5-10 collections, patterns emerge:
- Estate sale collections from older collectors: high volume, low grade, consistent mid-tier margins
- “Hot” collections bought at peak hype: overpaid, tough to move, margin gets squeezed
- WhatNot liquidation lots: fast sell-through, lower per-card value but faster cash cycle
You can’t see these patterns in a spreadsheet. You need a dashboard that shows you collection-by-collection P&L side by side.
The WhatNot Variable
If you stream, you’ve got an extra layer to track. Cards sold on WhatNot don’t come from one collection they come from three, or five, or whatever you pulled out for that night’s stream.
The question you want to be able to answer: Are my WhatNot streams more profitable than just listing on eBay?
This is genuinely hard to answer without good tooling. You need to know revenue per stream, WhatNot’s fees (8% + 2.9% + $0.30/order for sports/TCG), which collections the streamed cards came from, and whether the leftover inventory got listed on eBay after the stream.
Most resellers don’t have this data. They just feel like the streams are “good” or “not worth it” based on vibes. Vibes aren’t a business strategy.
What I Use Now
I built ResellPulse because I couldn’t find a tool that did this correctly. I was doing over $2M a year in cards and couldn’t tell you my actual margin on any given collection.
ResellPulse connects directly to your eBay store, pulls your sales automatically, and lets you tag each sale to a specific collection. You log your acquisition cost, your expenses (including grading fees), and you see real P&L for every collection you’ve ever bought — in real time. It also tracks your WhatNot streams separately so you can see the platform-by-platform split.
The founding member price is $19/mo, and it replaces the spreadsheet, a separate bookkeeping tool, and a lot of mental overhead.
The Bottom Line
Most sports card resellers know their gross revenue. Almost none know their actual margin. And without knowing your margin, every sourcing decision you make is a guess.
The system is simple:
- Log acquisitions immediately
- Sync your eBay sales automatically
- Log grading costs as collection expenses
- Track sell-through, not just revenue
- Compare collections against each other over time
Do this for 90 days and you’ll make better sourcing decisions than 95% of resellers out there. Because you’ll actually know what’s working.
Ty Wilson is a full-time sports card reseller doing $2M+ annually on eBay and WhatNot. He built ResellPulse to solve the tracking and analytics problems he couldn’t find a solution for anywhere else.
