> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # OpenCart Inventory vs Marketplace Listings, OpenCart > SKUs out of stock on OpenCart but still live on a connected marketplace, the oversell risk hiding between your store and your channels. How to read it, why it matters, and how to act on it. **Card class:** [Cross-Channel](/nerve-centre/overview#card-classes-explained) • **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type) > 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](/nerve-centre/kpi-cards/opencart/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** | | What's interesting here: 1. **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. 2. **The card is below its alert floor, but only just.** With 2 confirmed SKUs the `>5` alert 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. 3. **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](/nerve-centre/kpi-cards/opencart/products-missing-sku-model) is what makes this card trustworthy. 4. **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. Action priority order: 1. **Push the two flagged SKUs to inactive on the marketplace** immediately, or set marketplace quantity to zero, until OpenCart stock recovers. 2. **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. 3. **Resolve the unmatched SKU** by adding a SKU or model to KW-MUG-SET on OpenCart so the join can see it next sync. 4. **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](/nerve-centre/kpi-cards/opencart/out-of-stock-products) | The OpenCart-side input. This card joins those OOS SKUs to marketplace status. | | [Low Stock SKUs](/nerve-centre/kpi-cards/opencart/low-stock-skus) | The early-warning layer. Catch SKUs before they hit zero and create marketplace risk. | | [Stock-Out Burst](/nerve-centre/kpi-cards/opencart/stock-out-burst) | A sudden wave of stock-outs is when this card spikes hardest. | | [Products Missing SKU / Model](/nerve-centre/kpi-cards/opencart/products-missing-sku-model) | Unmatched SKUs are invisible oversell risk. This is what makes the join reliable. | | [Total Products](/nerve-centre/kpi-cards/opencart/total-products) | The catalogue baseline the marketplace listing count is compared against. | | [Revenue at Risk (Live)](/nerve-centre/kpi-cards/opencart/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. **Why our number may legitimately differ from a manual cross-check:** | 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 | **Cross-connector reconciliation (OpenCart stock joined with a connected marketplace):** | Card | Expected relationship | What causes legitimate divergence | | -------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------- | | [`amazon_sp.listings_active`](/nerve-centre/kpi-cards/amazon-sp/active-listings) | 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`](/nerve-centre/kpi-cards/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](/nerve-centre/kpi-cards/opencart/out-of-stock-products) | The OpenCart-side input set. | This card is the subset of OOS products that are still live on the marketplace. |
Same-metric documentation cross-reference (for agencies running multiple platforms) The same inventory-versus-marketplace join exists on other commerce platforms, each pairing the platform's stock with a connected marketplace. This is not a reconciliation; your OpenCart store has no parallel store elsewhere. These cross-links let agencies running multi-platform client books navigate between equivalent oversell-risk metrics across the docs. * [`shopify.xc_inventory_vs_marketplace`](/nerve-centre/kpi-cards/shopify/inventory-vs-marketplace-listings) (planned) * [`bigcommerce.xc_inventory_vs_marketplace`](/nerve-centre/kpi-cards/bigcommerce/inventory-vs-marketplace-listings) (planned)
## Known limitations / merchant FAQs **Why is this card empty?** Usually because no marketplace connector is linked. OpenCart has no native marketplace integration, so the listing half of the join comes from a connected marketplace (for example Amazon). Without it, the card has nothing to compare your stock against. **A SKU is at zero on OpenCart but I use Amazon FBA for it, is that a real risk?** Not necessarily. If Amazon holds its own fulfilment stock, the listing can be legitimately live while OpenCart shows zero, because OpenCart is tracking your seller-fulfilled stock, not Amazon's warehouse. Treat FBA SKUs as expected exceptions and focus on seller-fulfilled SKUs. **Why are some out-of-stock SKUs not flagged?** Most often because they cannot be matched. A product without a SKU or model on OpenCart cannot be joined to the marketplace listing, so it is reported as unmatched rather than flagged. Fix [Products Missing SKU / Model](/nerve-centre/kpi-cards/opencart/products-missing-sku-model) to close that blind spot. **How fast does this update after a stock-out?** OpenCart stock is real time, but the marketplace listing status reflects the last connector poll (typically within 24 hours, often faster). A SKU that just went OOS may take a sync cycle to appear as a flagged pair. **What should I do the moment a SKU is flagged?** Take the marketplace listing down or set its marketplace quantity to zero until OpenCart stock recovers. That removes the oversell risk immediately. Then investigate why the inventory feed let the gap open in the first place. **Does OpenCart's "allow checkout on out of stock" setting affect this?** It can. If OpenCart is configured to allow purchases when stock is zero, the OOS definition softens, and a SKU that is technically zero may still be sellable on both sides. The card respects your stock-checkout configuration. **My SKUs are matched at product level but Amazon lists variants, why the mismatch?** OpenCart tracks stock at product level (with option-level adjustments via extensions), while a marketplace may list each variant separately. The join matches on the identifier you provide; if your variants need separate marketplace stock, ensure each carries a distinct SKU. *** ### Tracked live in Vortex IQ Nerve Centre *OpenCart Inventory vs Marketplace Listings* is one of hundreds of KPI pulses Vortex IQ tracks across OpenCart 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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.