A Guide for Power Users to Customize, Monitor, and Streamline Their Orders
Unlock the Power of Custom Spreadsheet Management
While CNFANS provides essential tools for agent-based shopping, power users often need more control and a unified view. Creating your own master spreadsheet is the key to monitoring orders efficiently, tracking quality control (QC) status, and managing multiple sellers—all in one organized document. This guide walks you through the process.
Step 1: Structuring Your Master Spreadsheet
Begin by creating a new spreadsheet (using Google Sheets, Microsoft Excel, or your preferred application) with the following core columns. This structure forms the backbone of your tracking system:
- Order Date & ID:
- Seller/Source:
- Item Name & Description:
- Price (¥):
- CNFANS Parcel #:
- Warehouse Status:"Ordered," "Arrived,""Pending."
- QC Status & Photos:"Pending QC," "Approved,""Returned."
- International Tracking:
- Notes:
- Seller/Source:
Step 2: Importing and Syncing CNFANS Data
Manually entering data ensures accuracy and forces a review of each order. Follow this routine:
- Log into Your CNFANS Account:
- Input New Orders:
- Regular Updates:Warehouse StatusQC Status
- Input New Orders:
Step 3: Advanced Tracking & Management Techniques
Transform your basic sheet into a powerful command center:
- Conditional Formatting:"Returned" QC status in red, "Shipped" parcels in green, or items lingering in "Ordered" status for over two weeks in yellow. This creates visual urgency.
- Multi-Seller Consolidation:
- Cost Calculation Formulas:
- Parcel Planning Column:
- Cost Calculation Formulas:
Step 4: Maintaining Your System
Consistency is crucial for maintaining an effective tracking document.
- Dedicate Time:
- Verify Before Shipping:
- Archive Completed Orders:
- Verify Before Shipping: