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.
Having a cnshopper spreadsheet is only half the battle. The other half is organizing it so you can find any order in under five seconds, see what needs attention at a glance, and never double-count or miss a delivery. This guide is the exact system used by buyers managing 200+ open orders simultaneously. It covers tab structure, naming conventions, daily workflow, and the one habit that separates organized buyers from chaotic ones.
The Tab Structure That Scales
One giant tab works until about fifty rows. After that, you need structure. The recommended tab layout for serious buyers is:
- Active Orders: Everything that is not yet delivered. This is your daily working view.
- Delivered Archive: Completed orders. Moved here monthly to keep Active fast.
- Returns & Issues: Refunds, exchanges, disputes, and problem orders.
- Dashboard: Auto-calculated metrics like open order count, total spend, average delivery time.
- Suppliers: Contact info, ratings, and notes about each supplier.
The Naming Convention Rule
Consistent naming is the difference between a sheet you trust and a sheet you fear. Use this format for every order row: Date-Supplier-SKU-Size. For example: 2026-05-20-SupplierA-AJ1-42. This creates a unique, sortable, searchable identifier that works across all your tabs and notes.
Never rely on your memory for supplier nicknames. If you call one supplier "Mike" in your head but his company name is "EastFootwear Ltd", your sheet will have rows under both names and your summaries will be wrong. Pick one name, write it in your Suppliers tab, and use it religiously.
The Daily 5-Minute Routine
Open the Active Orders tab
Sort by Status so Pending and Delayed orders float to the top. These are your priority actions for the day.
Update any status changes
Mark anything that shipped yesterday as Shipped. Add tracking numbers. Check carrier websites for in-transit updates.
Flag delays immediately
If an order passes its expected delivery window, change status to Delayed and add a note in the Notes column about your plan: message supplier, check tracking, etc.
Check the Dashboard tab
Verify your open order count, total monthly spend, and any red-flag metrics. This keeps your financial awareness sharp.
Archive completed orders
Move any row with Status = Delivered and older than 7 days to the Delivered Archive tab. This keeps your Active tab fast and focused.
Color Coding System
Colors should convey status at a glance, not decorate. Use this standard palette across all your tabs:
| Status | Color | Meaning |
|---|---|---|
| Pending | Yellow fill | Waiting for supplier action |
| Paid | Orange fill | Money sent, waiting for ship |
| Shipped | Light green fill | In transit to you |
| In Transit | Green fill | With carrier, moving |
| Delivered | Dark green fill | Received and checked |
| Delayed | Red fill | Past expected date, needs action |
| Issue / Return | Purple fill | Problem order, being resolved |
Related Guides
Frequently Asked Questions
How do I handle orders from multiple suppliers?
What is the best way to track partial shipments?
Should I organize by date, supplier, or status?
How do I find a specific order quickly?
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.