At a glance
Seller Rating / Return Rate Threshold Crossed is a real-time account-health alarm. It fires the moment your Mercari seller rating slips below a safe floor, or your return rate climbs past a safe ceiling, the two signals that quietly govern your search visibility and badge eligibility on the marketplace.
| What it counts | A live breach flag: it watches your current Mercari seller rating and your rolling return rate, and trips when either crosses its configured threshold. |
| Sample type | Backend API data from Mercari, refreshed on the standard data refresh. |
| Why it matters | On Mercari, account health is not cosmetic. A falling rating or a rising return rate suppresses how often your listings surface in search and can cost you the Fast Shipper badge, directly shrinking sell-through. |
| Reading the value | Treat any non-zero state as actionable. The card tells you which signal tripped, rating or returns, so you know whether to chase service quality or item-accuracy issues. |
| Currency | number |
| Time window | RT |
| Alert trigger | rating<4.7 OR return>8% |
| Sentiment key | mer_alert_account_health_drop |
| Roles | owner, operations, finance |
Calculation
The card reads your live Mercari seller rating (the running average of buyer ratings on completed sales) and your return rate (returned or disputed orders as a share of recent sales). It compares each against its configured floor and ceiling and raises the alert when either is breached. It is a real-time evaluation, so the flag reflects the most recent data Mercari has returned rather than a rolling daily average.Worked example
A representative reading of Seller Rating / Return Rate Threshold Crossed for a typical Mercari reseller. Say your rating sat comfortably at 4.9 for months, then three buyers in a fortnight rate a batch of “Good” condition jackets poorly because the photos undersold visible wear. Your average dips to 4.66 and the alert trips onrating<4.7. Illustratively, that single breach can pull affected listings down several rows in search. The action is to inspect those recent orders, tighten condition grading and photos on the offending category, and respond to the dissatisfied buyers. Cross-reference mer_return_rate and mer_avg_review_rating to see whether returns are also climbing in the same category. Vortex Mind traces the upstream cause, for example a single mis-described SKU driving the dip, and Ask Viq answers plain-English questions like “which listings caused my rating to fall this week”.
Sibling cards merchants should reference together
| Card | Why merchants reach for it |
|---|---|
mer_avg_review_rating | The rating side of the breach: see the trend that tripped the floor. |
mer_return_rate | The returns side of the breach: see whether the ceiling is being approached. |
mer_dispute_rate | Disputes often precede returns and rating damage; an early warning. |
mer_seller_feedback_score | Aggregate reputation context for the rating movement. |
mer_buyer_messages_unread | Slow replies frequently drive the negative ratings that breach the floor. |
Reconciling against Mercari
Where to look in Mercari’s own dashboard: Open your Mercari profile and the seller dashboard in the app or web. Your rating shows on your public profile as the star average, and return and dispute activity sits under your order history and resolution centre. Compare the live figure there against the value the alert evaluated. Why the Vortex IQ value may legitimately differ:| Reason | Direction | What to do |
|---|---|---|
| Period boundary. Mercari’s displayed rating may average all-time ratings while the return rate is measured over a recent rolling window. | Variable | Match the period range. |
| Time zone. A late-evening rating change can land in a different reporting day than Mercari’s account time zone. | Marginal | Confirm time zone match. |
| Filter scope. Profile filters may narrow which listings or order types feed the return-rate side. | Variable | Match filter settings. |