At a glance
Active Mercari Listings for Sold-Elsewhere Items counts one-of-a-kind items that have already sold on another channel but are still live on Mercari. It is a cross-channel card comparing Mercari against your other selling channel, so the danger sits in the gap between them. For unique resale stock, any count above zero is a live oversell waiting to happen.
| What it counts | Unique items still active on Mercari that have already been sold out on another channel such as BigCommerce. |
| Sample type | Backend API data from Mercari, refreshed on the standard data refresh. |
| Why it matters | A buyer can pay for an item you no longer have. You then cancel, refund, and likely take a poor seller rating, which damages your standing and your Fast Shipper credibility. |
| Reading the value | A live count. Any value above zero is urgent and should be cleared immediately. |
| Currency | number |
| Time window | RT |
| Alert trigger | >0 |
| Sentiment key | mer_xc_listed_but_oos_on_bc |
| Roles | owner, operations, finance |
Calculation
Vortex IQ matches each active Mercari listing to its item on your other channel and checks whether that item is already sold or out of stock there. Where the other channel shows the item gone but Mercari still shows it live, the listing is counted. Because resale stock is typically one of a kind, a single unit sold elsewhere means the Mercari listing can no longer be fulfilled. The card runs in real time so the count reflects your exposure right now.Worked example
A representative reading of Active Mercari Listings for Sold-Elsewhere Items for a typical Mercari reseller. At 11:00 on 26 Mar 26 the card reads 3. Drilling in, all three are unique vintage pieces that sold on your BigCommerce storefront in the last hour but are still live on Mercari because the inventory sync runs on a longer cycle. The reading tells you three Mercari shoppers could buy items you cannot ship, each one ending in a cancellation, a refund, and a likely rating hit. The action is immediate: delist the three on Mercari now, then look at tightening the sync cadence so the window closes faster. Cross-referencemer_xc_catalogue_drift_vs_bc to see the broader sync health, and mer_revenue_at_risk to quantify what an oversell would cost in refunds and standing. Vortex Mind traces upstream causes such as a sync job that lagged during a sales spike, and Ask Viq answers plain-English questions like “which sold-elsewhere items are still live on Mercari right now”.
Sibling cards merchants should reference together
| Card | Why merchants reach for it |
|---|---|
mer_xc_catalogue_drift_vs_bc | Shows the wider sync drift this oversell risk is the sharpest edge of. |
mer_xc_price_parity | Another cross-channel card for unique items listed in more than one place. |
mer_revenue_at_risk | Puts a number on the refund and standing cost of an oversell. |
mer_listings_active | Confirms how many live listings could still be fulfilled. |
mer_dispute_rate | Cancellations from oversells feed directly into dispute and rating trouble. |
Reconciling against Mercari
Where to look in Mercari’s own dashboard: Mercari shows the item as a healthy live listing, because from its point of view nothing is wrong; the stock loss happened on another channel entirely. To spot the problem by hand you would cross-check each Mercari listing against your other channel’s sold or out-of-stock items. The comparison here is Mercari versus your other channel, which means the Mercari dashboard alone will not show the gap, since the item still looks available there. Why the Vortex IQ value may legitimately differ:| Reason | Direction | What to do |
|---|---|---|
| Period boundary. A sale recorded on the other channel near a refresh may take a cycle to reflect here. | Variable | Match the period range. |
| Time zone. Sale timestamps on the two channels may sit in different zones. | Marginal | Confirm time zone match. |
| Filter scope. Only items mapped across both channels are compared; unmatched listings are excluded. | Variable | Match filter settings. |