Real CNShopper Spreadsheet Examples

Theory is useful, but examples are everything. In this article, we walk through three real cnshopper spreadsheet layouts used by actual resellers at different stages: beginner, intermediate, and advanced. Each example includes the exact tab structure, column headers, and formulas you can adapt immediately.

Example 1: The Beginner (10 orders/month)

This is the simplest viable cnshopper spreadsheet. One tab, clear columns, and zero complexity. Perfect if you are just validating your reselling idea.

• Tab: Orders
• Columns: Date, Product, Buy Price, Sell Price, Profit, Status
• Formula: =E2-D2 for profit
• Visual: No color coding yet. Just raw data.

Example 2: The Growing Seller (50 orders/month)

At this stage, you need separation of concerns. Products live in one tab, orders in another, and a dashboard ties it together.

Example 3: The Power User (200+ orders/month)

This reseller runs a small team and sells across three platforms. Their cnshopper spreadsheet is essentially a lightweight ERP.

• Multi-workbook setup: One per platform (eBay, Grailed, Direct).
• Master dashboard: Uses IMPORTRANGE to pull totals from all three.
• Automated alerts: Apps Script emails the team when inventory hits zero.
• Return tracking: Dedicated tab linked to original orders by Order ID.
• Tax export: Filtered view ready for the accountant every quarter.

Which Example Should You Copy?

Start with Example 1 if you are brand new. Upgrade to Example 2 when you have more than one supplier or more than 20 active orders. Example 3 is for teams or multi-platform sellers who have outgrown single-tab tracking.

FAQ