EastMallBuy: Building a Smart Seller Rating System in Your Spreadsheet
Making consistent, smart buying decisions requires more than just remembering a good or bad experience. For procurement teams and savvy individual buyers using the EastMallBuy Spreadsheet, implementing a structured Seller Rating System
A standard spreadsheet lists suppliers, costs, and orders. A smart
Focus on these three critical pillars for a comprehensive view: Add these columns next to your existing supplier data: Create a consistent scale. For example: Apply this rubric to each category. Document specific criteria (e.g., "On-time delivery = Reliability 9+"). In the Overall Score
This formula gives QC 50% weight, Reliability 30%, and Communication 20%. Use color scales on the Overall Score column:
Green (8-10)Yellow (5-7.9)Red (0-4.9)
With data accumulating, you can now: Consistency is key. Assign responsibility for updating scores after each completed order, based on documented evidence (email trails, QC reports). Regularly review the rubric with your team to ensure alignment. By transforming your EastMallBuy spreadsheet into a dynamic Seller Rating System, you move from reactive buying to strategic, data-driven procurement. Start scoring today, and buy smarter tomorrow.Why Create a Seller Rating System?
Core Rating Categories
Category
What It Measures
Key Indicators
Reliability Score
The seller's ability to deliver as promised.
On-time delivery, order accuracy, correct documentation.
Communication Score
The clarity, proactivity, and responsiveness of communication.
Prompt replies, clear updates, proactive issue alerts, language clarity.
QC Success Score
The quality and conformity of received goods.
Pass/fail rates from inspections, sample approvals, defect rates.
Step-by-Step Implementation in Your Spreadsheet
1. Structural Setup
Supplier Name, Order Date, Item.
2. Defining Your Scoring Rubric
3. Calculating the Overall Score
=ROUND((Reliability_Score*0.3 + Communication_Score*0.2 + QC_Score*0.5), 1)
4. Visualizing with Conditional Formatting
Making Smarter Future Decisions
Maintaining the System