Create Your Own CNShopper Spreadsheet

Sometimes a pre-made template is not enough. If your reselling workflow is unique — maybe you handle custom orders, multiple currencies, or team members across time zones — building a custom cnshopper spreadsheet is the best long-term investment. This guide shows you how to create one from a blank sheet, step by step.

Start with a Blank Google Sheet

Open Google Drive, click New > Google Sheets, and name it clearly (e.g., "CNShopper_Tracking_2026"). The first decision is your tab structure. We recommend at least three tabs: Catalog, Orders, and Dashboard. Advanced users add Supplier Log and Expenses tabs too.

Design Your Catalog Tab

The Catalog is your product master database. Each row is one product variant. Here are the essential columns:

• SKU — Your internal product code.
• Product Name — Clean, searchable name.
• Supplier URL — Link back to the listing for quick re-ordering.
• Base Cost — What you pay in the source currency.
• Shipping Est. — Per-unit shipping to your warehouse.
• Target Sell Price — Your listed retail price.
• Margin % — Formula: =(G2-C2-D2)/G2

Build the Orders Tab

Every customer order gets its own row. Link back to the Catalog tab using the SKU so your formulas stay connected. This is the heart of any cnshopper spreadsheet guide system.

Add the Profit Dashboard

Use SUMIF and QUERY formulas to pull live data from the Orders tab. Display weekly revenue, monthly profit, and top-performing SKUs. For visual learners, insert a pie chart showing profit share by product category.

FAQ