When sourcing products on EastMallBuy, a seller's reliability is key to a smooth transaction. This guide explains how to create a simple scoring system within a spreadsheet to rank sellers based on Quality Control (QC) success and shipping punctuality.
Why Create a Seller Reliability Score?
Tracking performance manually is inefficient. A standardized score allows you to:
- Make data-driven decisions:
- Save time:
- Minimize risk:
- Save time:
Setting Up Your Spreadsheet
Create a table with the following columns. You can use software like Google Sheets, Microsoft Excel, or Airtable.
| Seller Name | Order Date | QC Passed? (Y/N) | Shipped On Time? (Y/N) | QC Score | Punctuality Score | Total Reliability Score | Notes |
|---|---|---|---|---|---|---|---|
| Example: GadgetPro | 2023-10-26 | Y | Y | 1 | 1 | 2 | Great communication |
The Scoring System
We assign a simple points-based score for two critical metrics:
1. Quality Control (QC) Success Score
- 1 point:
- 0 points:
2. Shipping Punctuality Score
- 1 point:
- 0 points:
Total Reliability Score = QC Score + Punctuality Score.2 points.
Calculating & Ranking Sellers
As you collect more order data, use spreadsheet formulas to calculate each seller's average score.
- For each seller, sum all their Total Reliability Scores.
- Divide that sum by the number of transactions with that seller.
- The result is their Average Reliability Score (0 to 2).
You can then sort your seller list by this average score in descending order. Sellers consistently scoring close to 2 are your most reliable partners.
Example Formula (Google Sheets):=AVERAGEIF(SellerNameRange, "GadgetPro", TotalScoreRange)
Pro Tips for Maintenance
- Update consistently:
- Use filters:
- Add context in notes:
- Consider weight:
- Use filters:
Conclusion
This simple spreadsheet system transforms subjective experience into an objective, actionable seller ranking. By consistently applying the QC and Punctuality scores, you build a valuable private database that streamlines your sourcing process on EastMallBuy, saving you time, money, and frustration in the long run.