An annual review of your purchase data on HubBuyCN is crucial for making smarter buying decisions. By systematically analyzing your spreadsheet, you can transform raw data into actionable insights on seller reliability and product quality.
Phase 1: Consolidate Your Data
Begin by merging all yearly transaction records into your master HubBuyCN Spreadsheet.
- Purchase Summary:Order ID, Purchase Date, Seller Name, Item, Price (CNY & USD), and Shipping Cost.
- QC Results:'Pass', 'Fail', or 'Minor Flaw'.
- Refund Activities:reason (e.g., quality issue, non-shipment)resolution outcome.
Phase 2: Calculate Key Reliability Metrics
Create new sheets or columns to measure performance using formulas.
| Metric | Calculation | Purpose |
|---|---|---|
| Seller Pass Rate | (QC Pass Items / Total Items from Seller) * 100 | Identifies sellers with consistent quality. |
| Refund Request Rate | (Refund Requests / Total Orders) * 100 | Highlights potential risk or dissatisfaction. |
| Total Value with Seller | SUM of all purchases from a single seller | Shows your spending concentration and trusted partners. |
Phase 3: Identify Trusted Sellers
Use sorted data and conditional formatting to visually categorize sellers.
- Green (Trusted):95%), low refund rate, and high total order value. Consider them for future priority purchases.
- Yellow (Caution):
- Red (Risky):
Phase 4: Derive Actionable Insights
Summarize your findings to guide next year's strategy.
Overall Reliability Score:
Cost of Issues:
Category Performance: