If you’ve just started shopping through CNFans, you might have heard about the CNFans spreadsheet but aren’t sure how it works. This guide will walk you through exactly how to set it up and use it — no previous experience required.
Step 1: Understand What CNFans Offers
Before diving into the spreadsheet, it’s important to know what CNFans does:
- Quality Control (QC) – CNFans inspects your items at their warehouse and sends high-definition photos so you can verify quality.
- Secure Payment – All transactions go through safe payment channels to protect your money.
- Consolidated Shipping – Orders from multiple sellers can be packaged together to save on delivery costs.
Knowing these services will help you structure your spreadsheet in a way that captures all important details.
Step 2: Create Your Spreadsheet
You can use Excel, Google Sheets, or any spreadsheet tool. Create columns for:
- Order Number – From your CNFans account.
- Product Name & Description – Include size, color, and specifications.
- Seller Information – Store name or link.
- QC Status – “Pending,” “Approved,” or “Rejected.”
- QC Photo Link – URL provided by CNFans.
- Shipping Method – Chosen delivery option.
- Tracking Number – Once shipped.
- Costs – Product price, service fee, domestic shipping, and international shipping.
Step 3: Record Your Orders Immediately
As soon as you make a purchase through CNFans, add it to the spreadsheet. This prevents confusion later and keeps your order history accurate.
Step 4: Update After QC Inspection
Once CNFans inspects your product and sends photos:
- Change the QC Status to “Approved” if it matches your expectations.
- If there’s an issue, mark it as “Rejected” and note the problem for CNFans to resolve.
Step 5: Track Shipping Progress
After consolidation and shipment:
- Add the Tracking Number.
- Record the shipping date.
- Update the status to “Shipped” or “Delivered” when applicable.
Step 6: Review Costs and Savings
At the end of each month, check your cost column. This helps you:
- See how much you’ve spent.
- Identify where consolidation saved you money.
- Plan future purchases more strategically.
Pro Tips for Success
- Use Color Coding – Green for delivered, yellow for in QC, red for issues.
- Add a “Notes” Column – For special seller requests or important reminders.
- Share Access – If you work with a team, give them viewing rights so everyone stays updated.
Final Word
The CNFans spreadsheet is not just an optional tool — it’s the foundation for organized, stress-free shopping from China. By following this step-by-step approach, you’ll have a clear record of every product, payment, and shipment, ensuring nothing slips through the cracks.
