Ready to Shop Smarter?
Use the cnshopper spreadsheet to track every order, compare prices, and never miss a delivery again. Then head to our main store for the best deals.
Learning the cnshopper spreadsheet workflow is the single best investment you can make as a new or growing buyer. This step-by-step guide assumes you have already downloaded a template or created a blank sheet. We will walk through every action from your first order row to your first monthly profit summary.
Each section below builds on the previous one. Do not skip steps, even if they seem obvious. The buyers who follow every step end up with sheets that scale to thousands of rows without breaking.
Step 1: Understand the Core Columns
Before you type a single cell, understand why each column exists. A typical cnshopper spreadsheet has these core fields: Date, Supplier, SKU, Item Name, Size, Color, Qty, Unit Cost, Shipping Cost, Total Cost, Status, Tracking Number, Notes, and Profit. Every extra column beyond these is optional until you outgrow the basics.
The magic happens in the Total Cost and Profit columns. Total Cost should use a formula like =(G2*H2)+I2 where G is Qty, H is Unit Cost, and I is Shipping. Profit should subtract Total Cost from your Sold Price. These two formulas alone save hours of manual calculator work every week.
Step 2: Enter Your First Real Order
Do not use fake sample data. Open your real supplier catalog, pick one item you actually bought or plan to buy, and fill in every column. This single row will teach you more than ten sample rows ever could. Pay special attention to currency consistency. If you pay a supplier in CNY but sell in USD, note both currencies in separate columns.
Step 3: Sort and Filter Daily
The most powerful feature of any spreadsheet is not formulas — it is sorting. Every morning, sort your sheet by Status. Every item that says "Pending" or "Delayed" rises to the top. Suddenly your to-do list writes itself. No more scrolling through 300 rows to find the one problem order.
Filters are even better. Select your header row, then Data → Filter views → Create new filter view. Name it "Pending Only" and set the Status filter to show only rows containing "Pending". Now you have a view that updates automatically as you change statuses.
Step 4: Add Visual Rules
Conditional formatting turns your sheet into a dashboard. Green means done, yellow means in progress, red means problem. Your brain processes colors faster than text. Set these rules in the Status column: "Shipped" → green fill, "In Transit" → yellow fill, "Delayed" → red fill, "Delivered" → blue fill.
Step 5: Build a Summary Dashboard
Create a new tab named "Dashboard". Use COUNTIF to show how many orders are in each status. Use SUMIF to show total spending by supplier. Use AVERAGE to see your average order value. These three numbers give you a health check in five seconds every morning.
| Dashboard Metric | Formula Example | Why It Helps |
|---|---|---|
| Open Orders | =COUNTIF(Status:Status, "Pending") | Know your daily workload instantly |
| Total Spend | =SUM(Total Cost:Total Cost) | Track budget against monthly limit |
| Avg Order | =AVERAGE(Total Cost:Total Cost) | Spot supplier price changes early |
| Top Supplier | =INDEX(Supplier, MATCH(MAX(COUNTIF...))) | Identify who you rely on most |
| Monthly Profit | =SUM(Profit:Profit) | See if your business is growing |
Common Roadblocks and Quick Fixes
Broken formulas after inserting rows
Always insert rows between existing rows, never at the very bottom. Or use ARRAYFORMULA in the top cell so new rows auto-fill.
Sheet becomes slow with 1000+ rows
Archive old orders to a new tab named '2026 Q1'. Keep only active and recent orders in the main tab.
Accidentally deleted a formula
Press Ctrl+Z immediately. For extra safety, protect the formula columns from editing (Tools → Protect range).
Dates look wrong in my country
Go to File → Settings → Locale. Set it to your country. Dates will auto-format correctly.
Keep Learning
Frequently Asked Questions
How do I share my sheet with a partner?
Can I import order data automatically?
What if a supplier changes their SKU format?
Should I use Excel or Google Sheets?
How do I track returns and refunds?
Start Using the CNShopper Spreadsheet
Whether you are a beginner or a seasoned reseller, the cnshopper spreadsheet is the simplest way to stay organized, save time, and protect your profits.
Download a free template, explore our guides, and start tracking your orders the smart way today.