Skip to main content
Card class: HeroCategory: Ecommerce Platform
The overselling trap, SKUs sold out on Ecwid but still buyable on a marketplace.

At a glance

A cross-channel card that compares Ecwid stock against active marketplace listings (for example Amazon, eBay, or a Google Shopping feed) to catch overselling risk: a SKU that is out of stock on Ecwid but still live and orderable elsewhere. When stock is shared across channels but not synced in lockstep, a sell-out on one surface leaves the others exposed to orders you cannot fulfil. That means cancellations, refunds, and marketplace seller-metric damage. The card combines Ecwid with a marketplace connector, matching listings on SKU.
What it countsThe number of SKUs that are out of stock on Ecwid (in_stock = false or tracked quantity zero) but still appear as active, orderable listings in the connected marketplace at the same moment.
API endpointEcwid side: GET /v3/{store-id}/products (OAuth2 with read_catalog). Marketplace side: active-listing and inventory status from the connected marketplace connector. The two are joined by Vortex IQ on SKU.
What countsA SKU OOS on Ecwid whose matched marketplace listing is still active and shows available-to-sell stock. Each mismatched SKU counts once.
What it excludesSKUs not listed on the marketplace at all (no listing to compare); SKUs OOS on both sides (no overselling risk); SKUs with stock tracking disabled on Ecwid (never report OOS).
CurrencyNumber. The card counts mismatched SKUs; per-row it may show the exposed quantity, but the headline metric is a count.
Time windowRT/24H (real-time comparison, evaluated continuously with a 24h reconciliation pass).
Alert trigger>10 SKUs OOS on Ecwid but active elsewhere.
SentimentInverse gauge. Sensitive card; a rising mismatch count is bad, and the alert is the headline.
Rolesowner, operations, marketing.

Calculation

Calculated automatically from your Ecwid data. 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 hobby seller of vinyl records running an Ecwid widget on a Wix site, also listing on eBay. Reading taken 03 Apr 26. The seller keeps a single pool of physical stock but lists the same records on both their Ecwid store and eBay. Ecwid decrements when it sells; eBay decrements when it sells; nothing tells eBay when Ecwid sells out, so a flurry of Ecwid sales leaves eBay listings live with no stock behind them.
SKUTitle (masked)Ecwid stockeBay listingeBay showsRisk
VIN-0041”Blue Note reissue”0active2 availableoversell
VIN-0078”Soul 45 box”0active1 availableoversell
VIN-0112”Jazz LP, mono”0active3 availableoversell
VIN-0156”Funk comp”0active1 availableoversell
…8 more rows
SKUs OOS on Ecwid AND active on marketplace = 12
Trigger is >10. Alert FIRES.
Every active eBay listing here has zero real stock behind it.
What it means. Twelve records have sold out on Ecwid but are still buyable on eBay. The next eBay order on any of them is an oversell: the seller takes payment for an item they cannot ship, then has to cancel, refund, and absorb an eBay defect on their seller account. On a small operation, a handful of cancellations can knock the seller below Top Rated status, which is hard to win back. The playbook.
  1. Stop the bleeding first. End or set to zero the eBay listings for the highest-risk SKUs (those with multiple “available”) immediately; an oversell is worse than a temporarily missing listing.
  2. Fix the root cause: shared stock with no central sync. The durable fix is a single source of truth (an inventory tool or a marketplace connector that pushes Ecwid sell-outs to eBay) so a sell-out on one channel zeroes the others automatically.
  3. Reorder if the SKU is a genuine seller; relist on both channels once stock lands.
  4. Watch the count fall to zero. Each SKU drops off as its marketplace listing is corrected to match Ecwid’s stock.
The card exists because no merchant watches two inventory dashboards side by side in real time. The join surfaces only the dangerous mismatch, OOS here, live there, so the seller acts before the next oversell, not after the cancellation.

Sibling cards merchants should reference together

CardWhy it matters next to this cardWhat the combination tells you
Out-of-Stock ProductsThe Ecwid side of the comparison.The OOS list is the input; this card filters it to the SKUs still live elsewhere.
Inventory Sync Drift Across StorefrontsSibling sync check.Drift across your own surfaces and drift vs a marketplace usually share a root cause.
Stock-Out Burst (>5 SKUs in <1h)The trigger event.A burst of Ecwid sell-outs is exactly what creates a fresh marketplace mismatch.
Low-Stock ProductsEarly warning.SKUs low on Ecwid are the ones about to create a mismatch; pre-empt by trimming marketplace stock.
Cancellation RateThe downstream cost.Overselling shows up later as cancellations; a rising cancel rate validates the risk this card flags.
Top Products by RevenueExposure ranking.If mismatched SKUs are top sellers, the oversell risk and lost-sales cost are both higher.
Total ProductsCatalogue context.Frames how much of your range is exposed to cross-channel mismatch.

Reconciling against Ecwid

Where to look:
Ecwid Control Panel (my.ecwid.com) -> Catalog -> Products -> filter by Out of stock This is the Ecwid half: the SKUs reporting zero stock. Note their SKU codes to match against the marketplace.
This is a cross-channel card, so the comparison also draws on your marketplace connector. The “still active elsewhere” half lives in the marketplace’s own seller dashboard (for example Amazon Seller Central, eBay Seller Hub, or Google Merchant Center), not in Ecwid. To fully reconcile a row, confirm the SKU is OOS in the Ecwid Control Panel and active with available stock in the marketplace dashboard. The card reconciles against BOTH dashboards. Why our number may differ from the two source dashboards:
ReasonDirectionWhy
SKU matchOurs lowerSKUs that do not share an identical code between Ecwid and the marketplace cannot be joined and are excluded.
Listing vs inventoryEitherSome marketplaces keep a listing “active” with zero available; we treat genuinely orderable stock as the risk, which may differ from a raw active-listing count.
Untracked Ecwid stockOurs lowerSKUs with stock tracking disabled never report OOS on Ecwid, so they cannot appear here even if the marketplace shows them live.
Reconciliation cadenceBoundaryThe 24h pass squares up against the real-time view; a very recent change may show in one before the other.
Marketplace sync lagMarginalThe marketplace connector’s own refresh interval can leave a just-changed listing momentarily out of step.
Internal identity: ecwid_inventory_vs_marketplace = count(SKUs WHERE ecwid_oos AND marketplace_active_orderable), joined on SKU between Ecwid and the marketplace connector.

Known limitations / merchant FAQs

Does this work without a marketplace connector? No. This is a cross-channel card; the “active elsewhere” half comes from a connected marketplace. Without one, Vortex IQ knows what is OOS on Ecwid but cannot see your marketplace listings, so there is nothing to compare. Why is overselling such a big deal on marketplaces? Because marketplaces penalise sellers who cancel orders for being out of stock. A cluster of oversell cancellations can damage your seller metrics and cost you Top Rated or Buy Box eligibility, which directly reduces sales. The card helps you avoid the cancellation in the first place. A SKU is OOS on both Ecwid and the marketplace. Why isn’t it listed? Because there is no overselling risk. If the marketplace listing is also out of stock, no one can order what you cannot ship. The card only flags the dangerous case: empty on Ecwid, still buyable elsewhere. Some of my listings are missing from the comparison entirely. Why? Most likely the SKU codes do not match exactly between Ecwid and the marketplace. The join is on SKU, so a different code, a suffix, or a typo breaks the match. Aligning SKU codes across channels is the single best fix. My marketplace shows the listing as active but zero available. Does that count? Generally no. We treat genuinely orderable stock as the risk. A listing that is technically active but shows zero available cannot be oversold, so it is not the dangerous case this card targets. What is the real fix, not just ending listings? A single source of truth for stock. The durable fix is a sync that pushes an Ecwid sell-out to the marketplace automatically, so the listings move together. Ending listings manually is a stopgap while you set that up. How fast does a corrected SKU drop off the card? On the next evaluation after the marketplace listing is set to zero or ended, with the 24h pass squaring up any edge cases. Restocking on Ecwid also clears it, since the SKU is no longer OOS. Does this catch Google Shopping feed mismatches too? If a Google Merchant Center feed is connected as the marketplace source, yes. A SKU OOS on Ecwid but still advertised as in stock in the feed is the same overselling risk and is surfaced the same way. Can I change the threshold of 10? Yes. A multi-channel seller with a large catalogue may raise it to cut noise; a small seller for whom even one oversell hurts may lower it. The trigger count is configurable per merchant.

Tracked live in Vortex IQ Nerve Centre

Ecwid Inventory vs Active Marketplace Listings is one of hundreds of KPI pulses Vortex IQ tracks across Ecwid 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.