GTBuy: How to Analyze Seller Consistency Using the GTBuy Spreadsheet
Track order completion times, QC accuracy, and communication to identify top-performing sellers.
In the world of sourcing, consistency is the hallmark of a reliable seller. The GTBuy Spreadsheet is a powerful tool designed to move beyond guesswork, transforming subjective impressions into objective data. By systematically tracking key performance indicators (KPIs), you can pinpoint which sellers truly deliver quality and reliability.
The Three Pillars of Seller Analysis
To effectively evaluate sellers, focus on these three critical pillars. Tracking them in your spreadsheet creates a clear, comparable profile for each vendor.
1. Order Completion Time
This measures the time from order confirmation to the seller providing tracking or declaring shipment. Consistent, on-time completion indicates operational efficiency and reliability.
- Metric to Track:
- Red Flag:
2. QC (Quality Control) Accuracy
This assesses the match between the product received and the product ordered in terms of quality, specifications, and absence of defects.
- Metric to Track:
- Data Source:
3. Communication Responsiveness & Quality
Timely, clear, and honest communication is crucial for resolving issues and ensuring smooth transactions.
- Metric to Track:
- Key Indicator:
Structuring Your GTBuy Analysis Spreadsheet
A well-designed spreadsheet is your command center. Below is a recommended column structure.
| Seller Name | Order Date | Item/SKU | Promised Process Time | Actual Completion Time (Days) | QC Result (Pass/Fail/Notes) | Communication Score (1-5) | Issues & Notes |
|---|---|---|---|---|---|---|---|
| Seller_A | 2023-10-01 | AJ1 High | 3 days | 3 | Pass | 5 | Promptly provided extra photos. |
| Seller_A | 2023-10-15 | Dunk Low | 3 days | 5 | Fail (stitching flaw) | 4 | Agreed to exchange after QC failure. |
| Seller_B | 2023-10-05 | Yeezy Slide | 2 days | 7 | Pass | 2 | Slow to reply, no updates on delay. |
From Data to Action: Identifying Top Performers
Once you have data from 5-10 orders per seller, analyze it to make informed decisions.
Step 1: Calculate Averages & Trends
Create a summary sheet that calculates, per seller:
- Average Order Completion Time:
- QC Pass Rate %:
- Average Communication Score:
- QC Pass Rate %:
Step 2: Look for Patterns, Not Outliers
A single delay might be a fluke; consistent delays are a pattern. Did communication score drop when problems arose? A top performer maintains good communication even during issues.
Step 3: Create a Tier List
Categorize sellers based on your data:
- S-Tier (Prioritize):
- A-Tier (Reliable):
- B-Tier (Situational):
- F-Tier (Avoid):
- A-Tier (Reliable):