A Guide to Using Filters for Tracking Inspection Quality & Rejection Rates
In the world of sourcing, your supplier relationships are your greatest asset—or your biggest risk. Consistently receiving well-inspected, high-quality products is key to a sustainable business. The Hoobuy Spreadsheet
The Power of Spreadsheet Filters for Seller Management
Manual tracking is time-consuming and error-prone. The Hoobuy Spreadsheet, typically structured with columns for Seller Name, Product Type, Inspection Date, Inspection Result (Pass/Reject), Rejection Reason, and Order Volume, becomes a dynamic dashboard when you leverage its filtering capabilities. This allows for quick segmentation and trend analysis.
How to Organize Your Seller Data: A Step-by-Step Process
Step 1: Data Entry & Standardization
Consistency is crucial. Ensure every order and its inspection result is logged. Key columns to maintain include:
Seller ID/Name:
Inspection Score:Result:
Rejection Rate %:
Critical Defects Noted:
Step 2: Identifying Your Top Performers
To find sellers who consistently deliver quality:
Apply a filterPass".
Within these results, filter by "Inspection Score" (if available) to show only scores of 4 or 5.
Sort the "Order Volume" column in descending order to see your high-volume, reliable partners at the top.
This filtered list is your preferred seller list. Prioritize future orders with these suppliers.
Step 3: Flagging Sellers with High Rejection Rates
To pinpoint suppliers requiring review or re-training:
Filter the "Inspection Result" column for "Reject".
Add a second filter to the "Rejection Rate %" column to show values above your acceptable threshold (e.g., >5%).
Use the "Rejection Reason" column to identify common issues (e.g., "packaging damage", "component failure").
This view helps you make data-driven decisions: whether to discuss corrective action or phase out the supplier.
Step 4: Creating Comparative Views & Trends
Use multiple filters simultaneously
"Which sellers had a rejection rate over 10% in the last quarter?" (Filter by Rejection Rate and Date).
"Are higher-volume orders correlated with more defects for a specific seller?"
Sorting and filtering by date reveals trends, showing if a seller's quality is improving or deteriorating.
