Skip to main content
Metrics type: Key MetricsCategory: Marketplace

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.

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 on rating<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

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: Cross-connector reconciliation: if you also sell the same stock elsewhere, returns recorded on another channel will not move this Mercari-only signal. For divergence investigations, use Vortex Mind.

Known limitations / merchant FAQs

Q: How often does Seller Rating / Return Rate Threshold Crossed update? It is a real-time alert, so it re-evaluates on every standard data refresh and trips as soon as the latest Mercari data shows a breach. There is no daily smoothing. Q: Why does my Mercari dashboard show a different number? Your public profile often shows a lifetime rating average, whereas the alert can evaluate a recent window, and the return rate side counts only recent orders. Match the windows before assuming a discrepancy. Q: Does the alert tell me which of the two signals tripped? Yes. The card distinguishes a rating-floor breach from a return-rate ceiling breach so you can target the right fix, service and accuracy issues for rating, item-as-described and shipping issues for returns. Q: Can I customise the alert threshold? Yes, alert thresholds are configurable per profile in the Alert Rules tab. Adjust to match your business baseline rather than relying on the generic default.

Tracked live in Vortex IQ Nerve Centre

Seller Rating / Return Rate Threshold Crossed is one of hundreds of KPI pulses Vortex IQ tracks across Mercari and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.