Building a trustworthy supplier network is crucial for successful importing. This guide explains how to use the MyCNBox Tracking Spreadsheet to quantitatively rank sellers based on key performance indicators for informed, long-term partnership decisions.
Core Principles of the Scoring System
The system assigns a score from 1 (Poor) to 5 (Excellent) for each of three critical reliability pillars. The Total Weighted Score
The Three-Pillar Scoring Framework
1. QC Inspection Speed (Weight: 40%)
Measures efficiency from payment to QC completion. Log dates in your spreadsheet's Order Timeline
Score Criteria 5 QC completed within 3 business days 4 QC completed in 4-5 business days. 3 QC completed in 6-7 business days 2 QC completed in 8-10 business days. 1 QC takes more than 10 business days
2. Product Accuracy (Weight: 40%)
Evaluates conformity to sample/description. Reference your QC Report & Notes
Score Criteria 5 Perfect match 4 Minor discrepancy 3 Noticeable variance 2 Major issue 1 Completely wrong
3. Communication Responsiveness (Weight: 20%)
Assesses professionalism and speed of replies. Track in the Seller Communication
Score Criteria 5 Replies within 12 hours, proactive, clear, and solution-oriented. 4 Replies within 24 hours, helpful and clear. 3 Replies within 48 hours 2 Replies take 3+ days 1 Consistently poor communication, unresponsive for critical issues.
Calculating & Tracking the Total Score
Use a formula in your spreadsheet to calculate the composite score. Example for a seller with scores: QC Speed=4, Accuracy=5, Communication=3:
Total Score = (4 * 0.40) + (5 * 0.40) + (3 * 0.20)
= 1.6 + 2.0 + 0.6 = 4.2 / 5.0
Create a Seller Reliability Dashboard
Strategic Application for Long-Term Success
This data-driven system transforms subjective impressions into actionable intelligence:
- Sourcing Priority:4.0 or above.
- Relationship Management:2.0-3.9, maintain communication but order with caution.
- Negotiation Leverage:
- Performance Review:
By consistently applying this method within your MyCNBox spreadsheet, you build a valuable proprietary database, minimizing risk and building a foundation of reliable, high-performing supplier partnerships.