SKUs that are out of stock on OpenCart but still live and sellable on a connected marketplace. Direct oversell risk: a customer can buy something you cannot fulfil.
At a glance
A cross-connector view that joins your OpenCart stock levels with a connected marketplace’s (for example Amazon) listing status. It flags SKUs that read out of stock in OpenCart but are still active and buyable on the marketplace. That gap is an oversell waiting to happen: a marketplace shopper places an order you cannot fulfil, which triggers cancellations, refunds, and on Amazon, account-health penalties. OpenCart has no native marketplace integration, so this card only populates when a marketplace connector is linked, and the join is keyed on SKU or model.
| What it counts | The count of SKUs where OpenCart stock is zero (out of stock) but the matched marketplace listing is still active and sellable. |
| How OOS is read on OpenCart | Stock level at or below zero on oc_product (the product quantity), respecting the store’s out-of-stock and stock-checkout settings. |
| How “live on marketplace” is read | The marketplace connector reports the listing as active and buyable. OpenCart cannot see this; it comes from the linked marketplace (Amazon) connector. |
| How SKUs are matched | By SKU or model. OpenCart stores both sku and model on oc_product; the marketplace uses its own identifier (for example seller SKU). Products missing a SKU or model cannot be matched, see Products Missing SKU / Model. |
| Currency | n/a, this is a count of SKUs. |
| Channels / sources | OpenCart catalogue and stock joined with a separately connected marketplace. OpenCart has no native marketplace channel. |
| Why this matters | Each flagged SKU is an active oversell risk: an order you cannot fulfil, leading to refunds, poor reviews, and marketplace account-health damage. |
| Time window | RT / 24H (real-time stock, marketplace listing status polled per connector sync) |
| Alert trigger | >5 SKUs OOS on OpenCart but active on marketplace |
| Roles | owner, operations, marketing |
Calculation
Calculated automatically from your OpenCart data joined with the connected channel. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK kitchenware merchant on OpenCart 3.x selling the same catalogue on Amazon via a connected Amazon Selling Partner account. OpenCart is the inventory master; Amazon listings are meant to follow it. Snapshot taken 13 Apr 26.| SKU | OpenCart stock | Amazon listing | Status | Risk |
|---|---|---|---|---|
| KW-CHEF-08 (chef knife) | 0 | Active, buyable | Oversell risk | Order cannot be fulfilled |
| KW-PAN-26 (26cm pan) | 0 | Active, buyable | Oversell risk | Order cannot be fulfilled |
| KW-BOARD-L (large board) | 0 | Inactive (synced OOS) | OK | Marketplace correctly down |
| KW-WHISK-3 (whisk set) | 42 in stock | Active | OK | In stock both sides |
| KW-MUG-SET (no SKU on OpenCart) | 0 | Active | Unmatched | Cannot be matched, hidden risk |
| Flagged by this card | 2 confirmed + 1 unmatched |
- Two confirmed oversell risks are live right now. KW-CHEF-08 and KW-PAN-26 are out of stock on OpenCart but still buyable on Amazon. Every hour they stay that way is an hour an Amazon shopper can place an order you cannot ship. On Amazon specifically, an unfulfillable order damages your account health, not just that one sale.
- The card is below its alert floor, but only just. With 2 confirmed SKUs the
>5alert is not firing yet. That is the moment to fix it, before a slow inventory-sync day pushes the count past the threshold and turns a quiet problem into a flood of cancellations. - The unmatched SKU is the dangerous one. KW-MUG-SET is out of stock on OpenCart and active on Amazon, but because it has no SKU or model on OpenCart, the join cannot confirm it. It is an oversell risk the card cannot see. Fixing Products Missing SKU / Model is what makes this card trustworthy.
- The healthy rows prove the sync usually works. KW-BOARD-L went out of stock on OpenCart and the Amazon listing correctly followed it down. That is the intended behaviour; the flagged rows are where the sync lagged or failed.
- Push the two flagged SKUs to inactive on the marketplace immediately, or set marketplace quantity to zero, until OpenCart stock recovers.
- Investigate the sync lag. If OpenCart went to zero hours ago and Amazon is still live, the inventory feed to Amazon is delayed or broken. Fix the feed cadence, not just these two SKUs.
- Resolve the unmatched SKU by adding a SKU or model to KW-MUG-SET on OpenCart so the join can see it next sync.
- Confirm restock dates. For SKUs restocking soon, marketplace preorder or back-order handling may be preferable to deactivating the listing entirely.
Sibling cards merchants should reference together
| Card | Why pair it with OpenCart Inventory vs Marketplace Listings |
|---|---|
| Out of Stock Products | The OpenCart-side input. This card joins those OOS SKUs to marketplace status. |
| Low Stock SKUs | The early-warning layer. Catch SKUs before they hit zero and create marketplace risk. |
| Stock-Out Burst | A sudden wave of stock-outs is when this card spikes hardest. |
| Products Missing SKU / Model | Unmatched SKUs are invisible oversell risk. This is what makes the join reliable. |
| Total Products | The catalogue baseline the marketplace listing count is compared against. |
| Revenue at Risk (Live) | Oversell risk is one driver of revenue at risk; the two move together. |
Reconciling against OpenCart
Where to look in OpenCart admin: OpenCart can show you the stock half but not the marketplace half. Catalog → Products shows the quantity per product; Reports → Products → Products Viewed and the stock columns help you see what is at zero. The underlying data is the quantity,sku, and model columns on oc_product, plus the out-of-stock setting under System → Settings. Marketplace listing status lives entirely in the connected marketplace account, OpenCart has no native marketplace integration, so the listing half is supplied by the Amazon connector.
Other OpenCart views that look relevant but cannot answer this:
- Catalog → Products quantity column: shows OpenCart stock, says nothing about whether the marketplace listing is live.
- The storefront “out of stock” label: governs your own store, not Amazon.
- An inventory export: snapshots OpenCart stock at a point in time, with no marketplace status.
| Reason | Direction of divergence |
|---|---|
| Sync lag. OpenCart stock updates in real time; marketplace listing status polls on the connector cadence. A SKU just gone OOS may not yet show as a flagged pair. | Vortex IQ may lag a manual check briefly |
| SKU matching. Products missing a SKU or model on OpenCart cannot be matched and are reported as unmatched rather than flagged. | Hidden risk not counted as a flag |
| Variant vs product. OpenCart tracks stock at product level (with option-level adjustments via extensions); a marketplace may list at the variant level. Matching depends on configuration. | Either direction |
| Marketplace own-stock. If the marketplace holds its own fulfilment stock (for example Amazon FBA), a listing can legitimately be live while OpenCart is zero. | Vortex IQ may flag a non-risk |
| Sync cadence. Listing status reflects the last marketplace poll, not the live second. | Self-resolves at next sync |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
amazon_sp.listings_active | Active marketplace listings whose OpenCart SKU is at zero are this card’s population. | Amazon FBA stock can keep a listing legitimately active while OpenCart (the seller-fulfilled view) is zero. |
amazon_sp.oversell_risk | Should correlate directly; both flag fulfilment exposure. | The marketplace card uses Amazon’s own quantity; this card uses OpenCart’s. They diverge when the inventory feed between them lags. |
| Out of Stock Products | The OpenCart-side input set. | This card is the subset of OOS products that are still live on the marketplace. |