A Step-by-Step Guide to Comparing Handling Time, Refund Rate & QC Accuracy
In the world of international purchasing agents, data is your most powerful tool for making informed decisions. Creating a structured comparison table in a spreadsheet is an excellent way to visually analyze and track the performance of ItaoBuy
Before building your spreadsheet, define what you'll measure. We recommend starting with these three agent performance pillars:
Create a new workbook (e.g., in Google Sheets or Excel) with the following tabs.
This tab tracks speed and consistency. Use columns for:
| Column | Purpose |
|---|---|
| Agent Name | List agents (ItaoBuy, Agent A, Agent B, etc.) |
| Order Date | Date order was placed |
| Item Received Date | Date item arrived in warehouse |
| Handling Time (Days) | Formula to calculate difference |
| Average Time (per Agent) | Use AVERAGEIF |
| Notes | Store-specific delays, holidays, etc. |
Pro Tip:
This tab measures after-sale service efficiency. Structure includes:
| Column | Purpose |
|---|---|
| Agent Name | ItaoBuy, Agent A, etc. |
| Refund Requested (Y/N) | Whether a refund was attempted |
| Refund Successful (Y/N) | Outcome of the request | Time to Refund (Days) | From request to money return |
| Communication Score (1-5) | Rate ease of communication |
| Overall Refund Rate | Calculate: (Successful Refunds / Total Requests) * 100 |
Pro Tip:
This tab evaluates the quality and reliability of pre-shipment checks. Key columns are:
| Column | Purpose |
|---|---|
| Agent Name | ItaoBuy and others |
| Number of QC Photos | Count of photos provided |
| Video Provided (Y/N) | Whether an inspection video was included |
| Flags Issues (Y/N) | Did QC proactively point out flaws? |
| Accuracy Score (1-5) | Your rating of QC vs. item received |
| Consistency | Notes on if QC quality varies per staff |
Pro Tip:AVERAGE
Once your tabs are populated with data from several purchases, create a final "Dashboard" tab. Use formulas like This living document will become an invaluable asset, allowing you to make objective decisions, spot service trends, and ultimately choose the most reliable agent for your needs—whether it's ItaoBuy or another. Remember to update it consistently with each purchase for the most accurate comparisons.VLOOKUPQUERY
