CNShopper Spreadsheet for Resellers (Profit-First System)

Resellers need more than a simple wishlist tracker. Your cnshopper spreadsheet should have these dedicated columns: Item Name, SKU, Purchase Price, Shipping In, Platform Fees, Total Cost, Target Sale Price, Estimated Fees, Net Profit, Profit Margin, Days Held, Status, and Platform.

The SKU column is non-negotiable. Every item gets a unique code like NK-001-DS. This prevents confusion when you own three pairs of the same sneaker in different sizes. The 'Days Held' column tracks how long you have owned the item. Fast flips are usually better than long holds unless you are betting on seasonal appreciation.

Professional resellers track three margin numbers. Gross margin is (Sale Price - Purchase Price) / Purchase Price. Net margin subtracts all fees and shipping. Hourly margin divides net profit by hours spent sourcing, listing, and shipping. The last number is the most honest profitability metric.

Use conditional formatting to highlight items with net margins below 20 percent in red. These are warning signs. Either raise your sale price or reconsider the flip. Items with margins above 50 percent get gold highlighting. These are your portfolio stars and deserve more sourcing attention.

Cash tied up in unsold inventory is cash that cannot buy new deals. Track the age of every item and set maximum hold periods. Streetwear typically has a sixty-day optimal window. Sneakers vary by hype level. General releases should flip within thirty days. Limited drops can age longer if the trend supports it.

Create a pivot table that sums your capital locked in inventory by age bracket. If more than 40 percent of your capital sits in items older than ninety days, you have a liquidity problem. Liquidate stale inventory even at breakeven to free up cash for faster-moving deals.

Most resellers list on multiple platforms simultaneously. Your cnshopper spreadsheet needs columns for each major platform: StockX Ask, GOAT Ask, eBay Average, Grailed Price. When an item sells on one platform, mark it sold everywhere and archive it immediately. Double-selling is a customer-service nightmare.

Track platform fee structures in a separate reference tab. StockX takes different percentages than GOAT. eBay has insertion fees and final value fees. Grailed has PayPal fees on top. Your 'Estimated Fees' column should reference this tab so every profit calculation reflects the actual platform you plan to sell on.

Resale prices spike before major events. Sneaker conventions, holiday seasons, and collaboration anniversaries create predictable demand surges. Track these dates in a calendar tab and link them to relevant inventory rows. A thirty-day advance alert gives you time to adjust pricing or withhold inventory for the peak.

Conversely, prices crash after events. Post-holiday January sees 20-30 percent drops in general fashion. Plan your liquidation sales before the crash, not during it. Your cnshopper spreadsheet calendar should show both upcoming spikes and predicted dips.