Navigating online marketplaces can be risky. The key to consistent, satisfying purchases is systematic evaluation. Using your MyCNBox spreadsheet to track seller performance transforms subjective impressions into objective data, helping you build a personal database of reliable stores over time.
Why Track Seller Performance?
A structured tracking system helps you:
- Avoid repeat disappointments
- Identify consistently excellent sellers
- Make informed decisions
- Save money and time
- Identify consistently excellent sellers
Key Metrics to Record in Your Spreadsheet
Create columns for these critical data points in your MyCNBox sheet:
1. Quality Control (QC) Score
After receiving an item, rate its quality on a consistent scale (e.g., 1-5 or 1-10).
| Score | Criteria |
|---|---|
| 9-10 | Exceeds expectations, flawless. |
| 7-8 | As described, minor unnoticeable flaws. |
| 5-6 | Acceptable but with clear defects. |
| 3-4 | Poor quality, significant issues. |
| 1-2 | Completely defective or wrong item. |
2. Refund / Issue Rate
Track how often transactions with this seller require a refund, partial refund, or major dispute. Calculate as a percentage (e.g., Issues / Total Orders). A seller with 2 issues out of 10 orders has a 20% issue rate.
3. Communication Notes
This qualitative data is crucial. Record details like:
- Response Speed:
- Helpfulness:
- Language Proficiency:
- Proactivity:
- Helpfulness:
4. Additional Data Points
- Store Name & Platform:
- Order Date & Item:
- Shipping Speed:
- Overall Rating:
- Order Date & Item:
The Evaluation Workflow
- Post-Purchase:
- During QC:
- If Issues Arise:
- Finalize Entry:
- Review Before Ordering:
- During QC:
Sample Spreadsheet Entry
| Store | Item | Date | QC Score | Issues | Comms Notes | Overall |
|---|---|---|---|---|---|---|
| GadgetPro | Bluetooth Speaker | 2023-10-15 | 9/10 | 0% (0/1) | Fast replies, friendly. | A |
| FashionHub | Winter Jacket | 2023-11-02 | 4/10 | 100% (1/1) | Slow, argued about refund. Needed platform intervention. | D |
Building Reliability Over Time
By diligently updating your MyCNBox