Navigating the world of Taobao and 1688 sourcing involves finding not just good products, but reliable sellers. Consistent reliability is the true foundation of a successful import business. This guide will walk you through creating a simple, yet powerful, tracking system using the MyCNBox Quality Control Spreadsheet to rank sellers based on objective, long-term data.
Why Track Seller Reliability Systematically?
Relying on memory or scattered notes leads to repeated mistakes. A structured scoring system helps you:
- Identify Top Partners:
- Mitigate Risk:
- Make Data-Driven Decisions:
- Track Improvement or Decline:
- Mitigate Risk:
The Three Pillars of Seller Reliability
We propose scoring sellers on three critical, measurable aspects of their service during the QC process with your agent, like MyCNBox.
1. QC Speed & Cooperation (Weight: 40%)
How quickly and smoothly does the seller handle the quality check request?
- Fast Response & Action (Score: 9-10):
- Average Speed (Score: 6-8):
- Slow/Delayed (Score: 3-5):
- Poor Cooperation (Score: 0-2):
- Average Speed (Score: 6-8):
2. Product Accuracy & Quality (Weight: 40%)
Does the product received match the listing description and expected quality?
- Perfect Match (Score: 9-10):
- Minor Discrepancy (Score: 6-8): Moderate Issue (Score: 3-5):Major Defect/Wrong Item (Score: 0-2):
3. Communication & Resolution (Weight: 20%)
How does the seller handle problems if the product fails QC?
- Proactive & Fair (Score: 9-10):
- Reactive but Cooperative (Score: 6-8):
- Reluctant or Difficult (Score: 3-5):
- Unresponsive or Hostile (Score: 0-2):
- Reactive but Cooperative (Score: 6-8):
Building Your Ranking Spreadsheet
Create a dedicated "Seller Reliability" sheet or add these columns to your existing MyCNBox order tracker.
| Seller Name/Store | Order Date | QC Speed (0-10) | Product Accuracy (0-10) | Communication (0-10) | Weighted Total Score | Notes / Issue Details |
|---|---|---|---|---|---|---|
| Example Store A | 2023-10-26 | 8 | 9 | 10 | 8.6 | Great service. Minor packaging scratch, but seller apologized. |
Calculating the Weighted Total Score:
Use this formula for each transaction: (QC Speed * 0.4) + (Product Accuracy * 0.4) + (Communication * 0.2) = Weighted Total
From the example above: (8*0.4) + (9*0.4) + (10*0.2) = 3.2 + 3.6 + 2 = 8.6
Long-Term Seller Ranking Dashboard
Create a summary sheet that calculates each seller's average Weighted Total Score
Seller Rank
Seller Name
Total Orders
Average Reliability Score
Tier
1
Example Store A
5
9.0
Platinum Partner
2
Example Store B
3
7.2
Reliable
3
Example Store C
2
5.5
Needs Caution
Turning Data into Better Sourcing Decisions
By consistently logging QC interactions with your MyCNBox agent, you transform subjective impressions into an actionable seller reliability index. Over time, this spreadsheet becomes one of your most valuable business assets, guiding you to partners who ensure product quality, smooth logistics, and ultimately, customer satisfaction. Start tracking today—your future self will thank you.