Seller transparency isn't just a feature; it's Joyagoo's core strength.
In the complex world of global sourcing, identifying reliable partners is paramount. The Joyagoo Spreadsheet aggregates critical vendor metrics, transforming raw data into actionable intelligence. Learning to sort and analyze this information is key to minimizing risk and maximizing value.
The Pillars of Seller Reliability: Two Key Columns
1. Seller Rating (%)
This percentage reflects the collective voice of past buyers. It is typically derived from detailed customer reviews covering communication, accuracy, and service. A high rating indicates consistent customer satisfaction.
[Seller_Rating]2. QC Pass Rate (%)
This objective metric shows the percentage of a seller's shipments that pass Joyagoo's or third-party Quality Control inspections. A high QC Pass Rate signals manufacturing consistency and adherence to specifications.
[QC_Pass_Rate]How to Sort and Compare: A Practical Guide
-
Step 1: Access Your Sourcing Spreadsheet
Open your Joyagoo-compiled product or supplier list. Ensure it contains the
Seller RatingQC Pass Rate -
Step 2: Perform a Primary Sort for Quality
Select all data rows. Navigate to Data Sort Range. First, sort by "QC Pass Rate"Descending (Z → A)
-
Step 3: Apply a Secondary Sort for Service
In the same sort dialog, add another sort level. Sort by "Seller Rating"Descending
Pro Tip:
-
Step 4: Analyze Review History Context
Click on the seller's name or ID link (if available) to access their detailed review history. Look beyond the score:
- Read recent review comments for positive/negative trends.
- Note how sellers respond to critical feedback.
- Check review volume; a 98% score from 500 reviews is more robust than from 20.
Interpreting the Combined Data
| Scenario | Interpretation | Recommended Action |
|---|---|---|
| High QC Rate + High Seller Rating | An ideal partner. Demonstrates reliable quality and excellent customer service. | Prioritize for quotes and new projects. Often justifies a premium. |
| High QC Rate + Moderate Seller Rating | Produces reliable goods but may have communication delays or less flexibility. | Excellent for standard items where specifications are clear. Ensure detailed PO agreements. |
| Moderate QC Rate + High Seller Rating | Service-oriented but quality may be inconsistent. Possible issues with complex products. | Consider for simpler goods. Plan for enhanced incoming inspection (IQC). |
| Low Metrics in Both Categories | High-risk vendor. Potential for quality issues and service challenges. | Only consider if no alternatives exist, and implement strict oversight and smaller trial orders. |