Guides

How We Rank Products on Hubbuycn Spreadsheet: The Scoring Method

2026-05-0511 min read
How We Rank Products on Hubbuycn Spreadsheet: The Scoring Method

Every product on this site carries a number between 0 and 100 in the sort_level field. Most visitors assume it is a popularity score, a sales ranking, or an editorial preference. None of those assumptions are entirely wrong, but none are entirely right either. The sort_level is the output of a weighted scoring algorithm that combines six independent signals into a single composite metric. This article explains each signal, its weight, its source, and the edge cases that can distort it.

Transparency in ranking is not common in this industry. Most platforms hide behind vague claims like "community curated" or "trending now." We publish the formula because our users are sophisticated enough to understand it, skeptical enough to question it, and informed enough to benefit from knowing its limitations.

1. The Six Signals

The current algorithm, deployed in January 2026 and refined through three monthly iterations, uses the following signals and weights:

Signal Weight Source Description
Sales Velocity 25% weidian API + Hubbuycn order logs Units sold per 30-day rolling window
QC Pass Rate 20% Warehouse inspection database % of items passing first-pass QC
Community Sentiment 18% Discord + Reddit NLP pipeline Net positive mention ratio (90d)
Price Stability 15% Price history time series Low volatility = high score
Listing Completeness 12% Internal metadata audit SKU, images, QC, description present
Seller Reputation 10% Aggregated return rate + dispute data Inverse of complaint frequency

The weights are normalized to sum to 100%. Each signal is scored on a 0-100 scale before weighting, so the theoretical maximum sort_level is 100. In practice, no product has exceeded 94 because perfect performance across all six dimensions is statistically improbable.

2. Sales Velocity: The Engine and Its Bias

Sales velocity is the strongest predictor of buyer satisfaction in our dataset. Products that sell consistently over 30 days tend to have accurate listings, reliable quality, and fair pricing. The signal is also the most vulnerable to manipulation.

Sellers with access to click farms or bot networks can inflate sales figures. Our defense is a velocity consistency check. A product that sells 200 units in week one and zero units in weeks two through four receives a dampened score. Natural sales follow a power-law decay: high initial velocity, gradual tail. Artificial spikes show flat or inverse patterns.

Algorithm Detail

Sales velocity is calculated as a 30-day rolling geometric mean, not arithmetic mean. The geometric mean penalizes zero-sale days more heavily, making it harder to mask artificial spikes with intermittent organic sales.

3. QC Pass Rate: The Quality Firewall

The warehouse inspection database logs every item that arrives at Hubbuycn's consolidation centers. A "pass" means the item matched its listing description, had no visible defects, and arrived in the correct SKU variant. A "fail" means any deviation that would trigger a buyer complaint if shipped unchecked.

The QC pass rate signal has a 90-day lookback window. This prevents a single bad batch from permanently tanking a product's score while also preventing a single good batch from permanently elevating it. Products with pass rates below 70% are automatically flagged for manual review. If the trend continues for 14 days, the product is moved to sort_level 0 (effectively delisted) until the seller submits a corrected sample.

4. Community Sentiment: The Human Layer

Our NLP pipeline scans three sources: the Hubbuycn Discord server, the r/hubbuycn Reddit community, and a curated list of 22 rep-focused subreddits where Hubbuycn products are discussed. The pipeline uses a fine-tuned BERT model trained on 14,000 manually labeled posts from 2024 and 2025.

The model classifies each mention as positive, neutral, or negative. It then applies a recency decay: mentions from the last 7 days count at full weight, mentions from 8-30 days count at 60% weight, and mentions from 31-90 days count at 25% weight. Mentions older than 90 days are discarded because batch quality changes over time.

The sentiment signal is the most volatile of the six. A single viral negative review can drop a product's sentiment score by 15-20 points overnight. To buffer against this, we apply a Bayesian prior: new products with fewer than 50 mentions start from a neutral baseline of 50 and adjust as data accumulates. This prevents early products from dominating or being crushed by small sample sizes.

5. Price Stability: The Trust Signal

Counterintuitively, stable prices score higher than low prices. A product that costs ¥380 today, ¥420 yesterday, and ¥290 last week signals either supply instability, seller inexperience, or active price testing. Buyers dislike volatility because it creates regret: "If I had waited two days, I could have saved $20."

The price stability signal uses the coefficient of variation (CV) of the trailing 60-day price history. CV below 5% scores 100. CV above 25% scores 0. Between those boundaries, the score scales linearly. Products with seasonal pricing (e.g., puffer jackets in winter) receive a seasonal adjustment to prevent penalizing legitimate demand-driven increases.

6. Listing Completeness and Seller Reputation

These two signals are hygiene factors. They do not elevate great products, but they prevent incomplete or risky listings from ranking high. A product with missing SKU data, no QC photos, or an empty description receives a proportional deduction. A seller with a return rate above 8% or a dispute rate above 2% transmits a penalty to all their active listings.

Seller reputation is calculated on a 90-day rolling basis. A seller who fixes their quality issues can recover their standing in approximately 60 days. A seller who maintains good performance for 180 days receives a trust bonus that adds 2 points to all their listings' sort_level. This incentivizes long-term reliability over short-term volume.

7. How the Composite Is Calculated

Each signal is normalized to 0-100. The weighted sum produces a raw composite. The raw composite is then passed through a sigmoid function that compresses the extremes and expands the middle:

Sigmoid Compression Formula

sort_level = round(100 / (1 + e^(-0.08 * (raw - 50))))

This ensures that a product with a raw score of 80 does not receive 80/100, but rather 86/100. It rewards strong all-around performance more than isolated excellence.

The final sort_level is rounded to the nearest integer and published in the database. It refreshes nightly at 02:00 UTC, which means the products you see at 9 PM EST reflect data collected through the previous day.

FAQ

Can sellers pay for higher sort_level placement?

No. The algorithm is fully automated with no paid placement slots. Sellers can improve their score only by improving the underlying signals: better QC, consistent pricing, accurate listings, and responsive customer service.

Why does a product I like have a low sort_level?

Low sort_level usually means one of three things: the product is new and has not accumulated enough signals, the seller has a recent quality issue, or the price has been volatile. Low sort_level is a caution flag, not a ban. Use your own judgment and check the qc_list before buying.

How often does the algorithm change?

Minor weight adjustments happen monthly based on A/B testing against return rates. Major structural changes happen quarterly and are announced on the Hubbuycn Discord with a 30-day preview window.

Conclusion

The sort_level is not a mystery. It is a composite of six measurable signals, each with a defined source, a known weight, and a transparent calculation path. Like any algorithm, it has edge cases and failure modes. A low-score product can be excellent. A high-score product can disappoint. The score is a starting point for attention, not a substitute for your own due diligence.

Use this guide to interpret the numbers you see on every product card. When a score seems wrong, investigate the underlying signals. When a score seems right, trust but verify through the qc_list and community reviews. The algorithm is designed to surface quality efficiently. You are designed to decide whether that quality matches your needs.

Frequently Asked Questions

Can sellers pay for higher sort_level placement?

No. The algorithm is fully automated with no paid placement slots. Sellers can improve their score only by improving the underlying signals: better QC, consistent pricing, accurate listings, and responsive customer service.

Why does a product I like have a low sort_level?

Low sort_level usually means one of three things: the product is new and has not accumulated enough signals, the seller has a recent quality issue, or the price has been volatile. Low sort_level is a caution flag, not a ban. Use your own judgment and check the qc_list before buying.

How often does the algorithm change?

Minor weight adjustments happen monthly based on A/B testing against return rates. Major structural changes happen quarterly and are announced on the Hubbuycn Discord with a 30-day preview window.