At a glance
Active Fruugo Listings for OOS SKUs on BC is a cross-channel surface that catches listings still sellable on Fruugo whose SKU has gone out of stock on BigCommerce, your source of truth. When BC stock and the live Fruugo listing diverge, every order against those SKUs is a direct oversell that ends in a cancellation. Because Fruugo cancellations feed straight into your account health across 40+ markets, this is a live financial and standing risk. It alerts on any such SKU above zero, the configurable default.
| What it counts | Listings still active and sellable on Fruugo whose SKU shows zero available stock in BigCommerce. |
| Sample type | Cross-channel match, one row per oversell-risk SKU |
| Why it matters | Selling stock you no longer have forces cancellations, and each Fruugo cancellation damages account health and buyer trust. |
| Reading the value | Zero is healthy. Any count is live oversell risk; each row names the SKU and its BC stock state versus the Fruugo listing. |
| Currency | count |
| Time window | RT |
| Alert trigger | >0 |
| Sentiment key | fru_xc_listed_but_oos_on_bc |
| Roles | owner, operations, finance |
Calculation
The card matches each active Fruugo listing to its BigCommerce source SKU and flags any case where the BC record shows zero available stock while the Fruugo listing remains sellable. It reads the live state on both sides rather than a rolling average, because the risk is immediate: any order placed against such a SKU cannot be fulfilled. The gap usually opens when a BC stock drop has not yet propagated through Feedonomics into Fruugo’s twice-daily import.Worked example
A representative reading of Active Fruugo Listings for OOS SKUs on BC for a typical merchant on Fruugo. On 12 Mar 26 the card shows 5 SKUs (illustrative) that sold out on BigCommerce after a fast-moving promotion but are still live on Fruugo because the next feed import has not run. Each is one order away from an unfulfillable sale and a cancellation that dents account health. The operations and finance leads see the exposure before a buyer orders. Vortex Mind investigates whether the lag is a feed-timing issue or a BC stock feed that stopped updating, and Ask Viq answers “which live Fruugo SKUs are out of stock on BC right now” in plain English so the team pauses or zeroes those listings immediately.Sibling cards merchants should reference together
| Card | Why merchants reach for it |
|---|---|
fru_xc_catalogue_drift_vs_bc | Cross-channel sibling: Listings Drifting from BC. |
fru_out_of_stock | Listing Health sibling: Out-of-Stock Listings. |
fru_cancellation_rate | Fulfilment sibling: Cancellation Rate. |
fru_revenue_at_risk | Economics sibling: Revenue at Risk. |
fru_alert_account_health_drop | Nerve Centre alert: Feed Ingestion / VAT-Gap / Cancel Threshold. |
Reconciling against Fruugo Merchant Portal
Where to look in Fruugo’s own dashboard: The Fruugo Merchant Portal shows the stock and status Fruugo currently holds for each listing, which is exactly the side that is wrong here. The canonical comparison is multi-source: this card reads the live Fruugo listing against the BigCommerce stock position, with the Feedonomics feed explaining the lag, so the Portal alone will look fine even while the risk is real. Why the Vortex IQ value may legitimately differ:| Reason | Direction | What to do |
|---|---|---|
| BC stock dropped but the next twice-daily feed import has not run | Vortex IQ higher | Pause or zero the affected listings, or push an out-of-band stock update. |
| Fruugo holds its own buffer stock the BC record does not reflect | Vortex IQ higher | Confirm whether intentional buffer stock should be excluded from the match. |
| BC stock feed stalled and is showing a stale zero | Vortex IQ higher or lower | Verify the BC stock source is updating before acting on the match. |
fru_out_of_stock for the Fruugo-side stock view, fru_cancellation_rate for the downstream impact, and fru_revenue_at_risk for the exposure. Vortex Mind traces whether the gap is feed timing or a broken stock feed.
Known limitations / merchant FAQs
Q: How often does this card update? It is a real-time surface, re-matching live Fruugo listings against BigCommerce stock continuously and after each twice-daily import. Q: Why might the Fruugo Merchant Portal show a different picture? The Portal shows only the Fruugo side, which is the side that is stale here. The oversell risk is only visible when the live Fruugo listing is compared against the BigCommerce stock position. Q: How does this relate to the sibling cards? This card is the oversell trip-wire;fru_out_of_stock shows Fruugo-side stock, fru_cancellation_rate shows the cancellations that follow unfulfillable orders, and fru_revenue_at_risk quantifies the exposure.
Q: Can I customise the alert threshold?
The default fires on any SKU above zero. You can add a tolerance for intentional buffer stock or scope the match to specific catalogues if some BC stock states are expected to differ.