When sourcing products on platforms like EastMallBuy, dealing with multiple suppliers can become chaotic. How do you remember which sellers deliver quality goods on time? A simple reliability scoring system in a spreadsheet is the key to organized and efficient sourcing.
The Core Metrics: QC Success and Shipping Punctuality
A seller's reliability hinges on two main pillars: Product QualityLogistical Performance. We quantify these into a simple score for easy comparison.
- QC Success Rate:
- Shipping Punctuality:
Building Your EastMallBuy Reliability Spreadsheet
Create a spreadsheet with the following columns. This becomes your central database for supplier evaluation.
| Seller Name | Order Date | QC Passed? (Y/N) | Shipped on Time? (Y/N) | QC Score (Current) | Shipping Score (Current) | Overall Reliability Score | Notes |
|---|---|---|---|---|---|---|---|
| Example: TechGoods Co. | 2023-10-15 | Y | Y | 90% | 85% | 87.5 | Excellent communication |
Calculating the Scores: A Step-by-Step Guide
Scores should be recalculated after each completed transaction to keep data fresh.
1. Calculate the QC Success Score
For a specific seller, count all their orders where "QC Passed?" is "Y". Divide by the total number of their orders and multiply by 100.
QC Score = (Number of QC Passes / Total Orders from Seller) * 100
2. Calculate the Shipping Punctuality Score
Similarly, count orders where "Shipped on Time?" is "Y". Divide by total orders and multiply by 100.
Shipping Score = (Number of On-Time Shipments / Total Orders from Seller) * 100
3. Calculate the Overall Reliability Score
This is your key ranking number. You can weigh the factors equally or prioritize one. For a balanced view:
Overall Score = (QC Score + Shipping Score) / 2
Tip: You can assign weights if quality is more critical than speed (e.g., 70% QC, 30% Shipping).
How to Use and Rank Your Sellers
Once calculated, sort your seller list by the "Overall Reliability Score" column in descending order.
- Green Zone (Score 85-100):
- Yellow Zone (Score 60-84):
- Red Zone (Score below 60):
- Yellow Zone (Score 60-84):
Benefits of This System
Implementing this structured approach transforms subjective feelings into objective data.
- Data-Driven Decisions:
- Save Time & Reduce Risk:
- Track Progress:
- Simplify Communication:
- Save Time & Reduce Risk:
Conclusion
Your EastMallBuy sourcing spreadsheet, powered by a simple reliability score, is more than just a log—it's a strategic asset. By consistently tracking QC and punctuality, you build a valuable proprietary database that minimizes supply chain risk and makes your buying process efficient, predictable, and professional. Start scoring your sellers today!