CNShopper Spreadsheet for Resellers

Reselling is a numbers game. Your success depends on three metrics: buy price, sell price, and velocity. The cnshopper spreadsheet gives you perfect visibility into all three — if you set it up correctly. This guide is written specifically for resellers who need to track margins, manage inventory across platforms, and understand which suppliers are actually making them money.

Profit Dashboard for Resellers

Create a "Dashboard" tab with these five metrics. They tell you if your business is healthy in under ten seconds every morning:

• Monthly Net Profit: =SUM(NetProfit:NetProfit) for the current month
• Average Margin %: =AVERAGE(NetProfit / SoldPrice) to see your typical markup
• Top 5 Items by Profit: Sort by Net Profit descending, limit to 5 rows
• Slowest Sellers: Filter where Days to Sell > 30 and Status = Listed
• Supplier Profit Ranking: SUMIF by supplier to see who brings the best margins

Handling Returns Professionally

Returns are inevitable in resale. The difference between a profitable reseller and a struggling one is often how well they track and learn from returns. Add a Returns tab with these columns: Original SKU, Return Date, Reason, Refund Amount, Condition on Return, and Resaleable (Yes/No).

After three months of return data, sort by Reason. You will likely discover that 60% of returns come from one specific issue — maybe sizing, maybe color accuracy, maybe one supplier's quality control. Fix that issue and your return rate drops immediately.

Multi-Platform Tracking

If you sell on eBay, Depop, and Grailed simultaneously, you need to know which platform moves which items fastest. Add a Platform column to your main sheet. Then create a pivot table (Data → Pivot table) with Platform as rows and sum of Net Profit as values. The result is an instant platform comparison.