I have built this system across 15 CNFans hauls. Here is what experience teaches:
These are typically Google Sheets or specialized web-based tables (like Spreadsheets-CNFans spreadsheets cnfans
| Function | Native CNFans Tool | Spreadsheet Advantage | | :--- | :--- | :--- | | | Basic list (Order ID, Status) | Custom statuses (e.g., "QC Failed - Reshoot," "Returning to Seller") | | Cost Analysis | Sum of items + shipping | Breakdown: Item cost + Domestic freight + Service fee + Intl shipping + Insurance | | QC Photo Management | Thumbnails in grid | Hyperlinked image folders; Flagged cells for defects | | Rehearsal Shipping | Single parcel weight | Predictive formulas estimating volumetric vs. actual weight tiers | | Reimbursement Log | Manual ticket system | Dated logs with formulaic interest/compensation tracking | I have built this system across 15 CNFans hauls
: Critical for calculating international shipping costs, which are often based on the total weight of the "haul". Seller Ratings Seller Ratings