CNFANS: How to Create and Manage Your Own Power Spreadsheet
For CNFANS power users, the platform's built-in tools are just the beginning. The real efficiency gain comes from building a customized master spreadsheet. This guide will walk you through creating a centralized document to monitor orders, track QC statuses, and manage multiple sellers seamlessly.
Phase 1: Foundation — Setting Up Your Spreadsheet
Start by creating a new spreadsheet in your preferred tool (e.g., Google Sheets, Excel). Structure is key. We recommend the following core columns:
- Order ID / CNFANS Link:
- Product Description & Variant:
- Seller Name/Store:
- Price & Shipping Cost:
- Order Date & Estimated Delivery:
- QC Status:Pending, Passed, Failed, RL (Red Light).
- Warehouse & Tracking Number:
- Notes/Action Items:
- Product Description & Variant:
Phase 2: Data Integration — Importing CNFANS Information
Manually copying data is inefficient. Use these methods to import data directly:
- Browser Extensions:
- CNFANS Order Export:QUERY/
IMPORTRANGE- Manual Entry Template:
- CNFANS Order Export:QUERY/
Pro Tip: Use Google Sheets' =IMPORTHTML=IMPORTXML
Phase 3: Active Management — Tracking & Oversight
Your spreadsheet becomes a dashboard with these dynamic features:
- QC Dashboard:=COUNTIF
- Seller Performance:
- Financial Summary:=SUM
- Color-Coding (Conditional Formatting):
- **Orange** for "QC Pending"
- **Green** for "QC Passed"
- **Red** for "QC Failed/RL"
- **Blue** for "Shipped"
- Alerts:
- Seller Performance:
Phase 4: Consolidation — One Document for All Sellers
The ultimate power of a custom sheet is unification. Create separate tabs or sections within one file for:
| Tab Name | Purpose |
|---|---|
| Dashboard | An overview with key metrics, charts, and summaries from all other tabs. |
| CNFANS Orders | Detailed view of all CNFANS-sourced items. |
| Weidian/Taobao/Other | Orders from other platforms, using the same column structure for easy comparison. |
| QC Archive | Links to QC photos (using hyperlink cells) for future seller reference. |
Use spreadsheet functions to roll up key data from all tabs to your main Dashboard for a true single-pane-of-glass view.
Final Recommendations
Building your own CNFANS management spreadsheet is an iterative process. Start simple, then add advanced functions like ARRAYFORMULAThe core benefits are clarity, control, and time savings.