Home > MyCNBox: Building Your Database of Trusted Stores

MyCNBox: Building Your Database of Trusted Stores

2026-03-24

In the world of cross-border e-commerce, finding reliable sellers is half the battle. The MyCNBox Spreadsheet

The Three Pillars of Seller Evaluation

A robust evaluation rests on three core data points. Consistently recording these for every order creates a clear, comparable history.

1. QC (Quality Control) Score

Assign a consistent numerical score (e.g., 1-5 or 1-10) based on product inspection upon arrival. Consider:

  • Accuracy:
  • Construction & Materials:
  • Functionality:

Spreadsheet Tip: Use a column for the score and conditional formatting to color-code results (e.g., green for 4-5, yellow for 3, red for 1-2).

2. Refund & Issue Rate

Track the frequency of problems requiring intervention. Calculate this as a simple percentage:

(Number of Orders with Issues / Total Orders with Seller) * 100

An issue can be a major defect, a wrong item, or a missing part that leads to a partial/full refund or replacement. A low, stable rate is a key indicator of reliability.

3. Communication Notes

Record qualitative observations in a dedicated notes column. This context is invaluable:

  • Response speed and language clarity.
  • Willingness to resolve problems (e.g., "quickly offered 50% refund without return").
  • Proactive updates on shipping or delays.
  • Any red flags (e.g., evasive answers, hostility).

Building Your Reliable Database Over Time

The true power emerges from consistent data entry and review.

The Process Cycle

  1. Record:
  2. Aggregate:AVERAGEIFCOUNTIF) to create summary views for each seller.
  3. Analyze:
  4. Act:
  5. Prioritize "Trusted" sellers (high QC, low rate) for repeat purchases.
  6. Flag "Caution" sellers for reduced orders or stricter QC.
  7. Identify "Avoid" sellers based on persistent poor scores.

Spreadsheet Structure Example

Seller Name Order Date Item QC Score (1-5) Issue? (Y/N) Issue Rate % Communication Notes Trust Tier
GadgetPro 2023-10-15 Bluetooth Headphones 5 N 0% (0/5) Responds within 24h, polite. Ships fast. Trusted
FashionCo 2023-11-02 Winter Jacket 3 Y 40% (2/5) Sizing inconsistent. Slow to process refund. Caution

The Long-Term Advantage

The MyCNBox Spreadsheet

Start today: