Unify QC, Storage, and Delivery Monitoring for Every Parcel
For e-commerce sellers and dropshippers managing inventory across multiple warehouses in China, logistics tracking can become a fragmented nightmare. CNFANS Spreadsheet
Why a Centralized CNFANS Spreadsheet is Essential
- End Fragmentation:
- Real-Time Visibility:
- Proactive Decision-Making:
- Simplify Communication:
- Real-Time Visibility:
Building Your Multi-Warehouse Tracking Spreadsheet
A well-structured sheet is key. Below is the recommended column structure to monitor the entire lifecycle.
| Column Header | Purpose & Data Entry |
|---|---|
| Batch Order ID | The unique CNFANS or custom ID for the grouped purchase order. |
| Parcel/Item SKU | Specific product identifier within the batch. |
| Assigned Warehouse | Name/code of the CNFANS or third-party warehouse (e.g., GZ-Hub-1, SYD-AU). |
| QC Status | Use dropdowns: Pending, Passed, Failed (with notes), In-Progress. |
| QC Notes / Photos Link | Hyperlink to QC images or detailed comments on any issues found. |
| Storage Location (Bin/Shelf) | Specific aisle/bin number within the warehouse for quick retrieval. |
| Date In Storage | When the item was officially placed into inventory. |
| Destination Country | Final delivery destination. |
| Shipping Method | e.g., CNFANS Express, DHL, Sea Freight. |
| Tracking Number | Updated once the parcel is dispatched from the warehouse. |
| Dispatched Date | Date the parcel left the warehouse. |
| Estimated Delivery Date | Based on the shipping method's timeline. |
| Actual Delivery Date | Updated upon final delivery confirmation. |
| Overall Status | Master status using conditional formatting: Awaiting QC, In Storage, Shipped, Delivered. |
How to Implement and Use Your Tracking System
Step 1: Sheet Setup & Batch Logging
Create the columns as above in Google Sheets or Excel. When a new batch order is placed with CNFANS, immediately create a row for each unique SKU, logging the Batch Order IDAssigned Warehouse
Step 2: Live QC and Storage Updates
As QC photos and results come in from CNFANS agents or warehouse staff:
- Update the QC Status
- Insert hyperlinks to cloud folders containing QC photos in the QC Notes
- Once passed, record the specific Storage LocationDate In Storage
- Insert hyperlinks to cloud folders containing QC photos in the QC Notes
Step 3: Consolidation & Shipping Workflow
For orders containing items from multiple warehouses, use filter views to see all components. Once all items for a customer order are ready:
- Instruct the respective warehouses to dispatch.
- Update the master sheet with Tracking Number, Dispatched Date, and Estimated Delivery Date.
- Change the Overall Status
Step 4: Timeline Monitoring & Reporting
- Use filter and sort functions to see all items awaiting QC
- Sort by Date In Storage
- Track Estimated Delivery Dates
- Mark items as Delivered
- Sort by Date In Storage
Pro Tips for Advanced Tracking
Leverage Data Validation & Dropdowns
Use data validation rules for columns like QC Status, Warehouse, and Shipping Method
Integrate with IMPORTRANGE or APIs
If receiving data from other sheets, use =IMPORTRANGE()
Set Up Conditional Formatting Alerts
Configure rules to highlight rows where QC Status is "Failed" or where the Estimated Delivery Date is past due, ensuring critical issues are never missed.
Create Summary Dashboard
On a separate tab, use =COUNTIFS()=SUM()