EastMallBuy: A Seller Reliability Scoring System-CNfans spreadsheet-CNfans reddit-CNfans discord-CNfans yupoo-CNfans coupons

When sourcing products, a seller's reliability is as crucial as price. This guide explains how to use the EastMallBuy Reliability Spreadsheet

1. Spreadsheet Setup & Data Collection

Create a spreadsheet with the following columns for each order:

Seller Name

Order Date

QC Result
Promised Ship Date
Actual Ship Date Days Delay Reliability Score
Consistently log data for every transaction to build a meaningful history.


        2. The Scoring Methodology
        The Reliability ScoreQuality Control (QC)Shipping Punctuality.


        A. QC Success Score (50 points maximum)
        
            Pass:Score = 50 points.

            Fail:Score = 0 points.

            Minor Issue:Score = 25 points.

        


        B. Shipping Punctuality Score (50 points maximum)
        
            On Time or Early:Score = 50 points.

            Slight Delay (1-3 days):Score = 35 points.

            Moderate Delay (4-7 days):Score = 20 points.

            Major Delay (8+ days):Score = 0 points.

        

        Total Reliability Score = QC Score + Shipping Score.
    


    
        3. Automated Calculation & Seller Ranking
        Use spreadsheet formulas to automate scoring. For a seller's row, your formula in the Reliability Score
        
=IF(C2="Pass",50, IF(C2="Minor Issue",25,0)) + IF(F2<=0,50, IF(F2<=3,35, IF(F2<=7,20,0)))

        To get a seller's overall rank:
        
            Create a Seller Summary
            
Use the AVERAGEIF()
            
Use the RANK()
        

        This instantly highlights your top-performing and most problematic suppliers.
    


    
        4. Applying the Data for Smarter Purchasing
        Use your ranked list to guide future orders:
        
            
                
                    Score Band
                    Reliability Tier
                    Action
                
            
            
                
                    90-100
                    Premium
                    Prioritize for important orders. Consider establishing a regular partnership.
                
                
                    70-89
                    Reliable
                    Suitable for most orders. Maintain routine business with monitoring.
                
                
                    50-69
                    Caution
                    Use only for low-risk items. Scrutinize QC photos and communication.
                
                
                    Below 50
                    Avoid
                    Seek alternatives unless absolutely necessary. High risk of issues.
                
            
        
    

    
        Conclusion
        The EastMallBuy Reliability Spreadsheet transforms subjective impressions into an objective, actionable ranking system. By investing a few minutes to log data after each order, you build a powerful private database that minimizes risk, saves money, and streamlines your sourcing workflow over the long term.
        Pro Tip:

A. QC Success Score (50 points maximum)

B. Shipping Punctuality Score (50 points maximum)

EastMallBuy: A Seller Reliability Scoring System

football jersey

Short T Set

T-shirt

T*S socks 3PCS (2 random colors or note colors）

Jordan T-shirt

NIKE T-shirt

football jersey

football jersey

football jersey

ARM@Nl 3PCS

NIKE T-shirt

NIKE T-shirt

nike t-shirt

GUCl mens 3pcs

Puma football jersey

adidas T-shirt

adidas T-shirt

NIKE football jersey

C*K mens Buy 1 Get 1 Free

adidas football jersey

1. Spreadsheet Setup & Data Collection

2. The Scoring Methodology

3. Automated Calculation & Seller Ranking

4. Applying the Data for Smarter Purchasing

Conclusion

Score Band	Reliability Tier	Action
90-100	Premium	Prioritize for important orders. Consider establishing a regular partnership.
70-89	Reliable	Suitable for most orders. Maintain routine business with monitoring.
50-69	Caution	Use only for low-risk items. Scrutinize QC photos and communication.
Below 50	Avoid	Seek alternatives unless absolutely necessary. High risk of issues.