Skip to main content
Metrics type: Key Metrics • Category: Ecommerce Platform
Square Inventory vs Marketplace Listings.

​
At a glance

A cross-platform revenue-at-risk audit. It compares Square inventory on-hand counts against the active listing status on a connected marketplace listing feed, and flags SKUs that a marketplace is still advertising as buyable while Square shows them out of stock. Every flagged SKU is an oversell waiting to happen: a marketplace order you cannot fulfil, a cancellation, and a marketplace account-health penalty.

​
Calculation

Calculated automatically by cross-referencing your Square Online inventory against your connected marketplace listing feed. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

A US outdoor gear retailer on Square. One store plus a Square Online storefront, also selling on a marketplace via a listing feed. The audit is reviewed on the morning of 14 Mar 26. Each row is a flagged SKU. Three things to notice:
  1. Six SKUs are live on the marketplace with nothing to ship. Each of TENT-2P-GRN through MAT-REG shows zero (or negative) on-hand in Square while the marketplace is still taking orders. The next marketplace buyer for any of them gets a cancellation. The Hiking Boot is in parity (8 on-hand, listed) so it is not flagged, the list stays short and actionable.
  2. A negative on-hand is the most urgent row. BAG-20-BLU at -1 means Square already believes it has oversold, and the marketplace is still advertising it. Work negatives first, then zeros. Pair with Oversell Risk for the Square-side projection.
  3. Crossing 5 SKUs fires the alert. With 6 flagged, the Vortex IQ Nerve Centre alert raises. The fix is to pause or zero out the marketplace listings for these SKUs until Square on-hand recovers, then let the feed re-activate them. Recurring flags usually mean the inventory feed to the marketplace is stale or one-directional, the real fix is the sync, not the listing.

​
Sibling cards merchants should reference together

​
Reconciling against Square

Where to look in the Square Dashboard: Square Dashboard, Items & Orders, Inventory management. Find each flagged SKU and confirm its on-hand count per location. Square will show the zero or negative on-hand that triggered the flag. Square alone cannot show the marketplace listing status, that is the cross-platform half of this card, confirmed in the marketplace seller console. Other Square Dashboard views that look like the same issue but aren’t:
  • Inventory management, on-hand by location: confirms the Square side of the flag (zero or negative stock).
  • Online, Items, stock: the Square Online sellable view. Useful to confirm the web channel is also empty, but it is not the marketplace.
  • Inventory history: shows the adjustments that drove the SKU to zero, the root cause of the stockout.
  • Item sales report: shows what sold, not what is listed where. Not relevant for confirming the marketplace exposure.
Why our number may legitimately differ from Square Dashboard: Cross-connector reconciliation: The Square unified-inventory advantage and its catch: Square gives you one authoritative on-hand count per SKU per location across POS and web. That makes Square the natural source of truth to feed a marketplace. The catch is that the marketplace is a separate system with its own listing lifecycle, so the value of Square’s clean inventory is only realised if the feed to the marketplace is timely and two-directional. This card is the audit that proves whether it is.

​
Known limitations / merchant FAQs

What exactly gets flagged? A SKU that Square shows as out of stock (zero or negative on-hand) while the matching listing on your connected marketplace is still active and accepting orders. That combination is an oversell waiting to happen, so each one becomes a row. SKUs that are out of stock on Square but already paused on the marketplace are not flagged, that gap is closed. Why does the opposite case (in stock on Square, not listed) not alert? Because it is lost reach, not an oversell. Stock sitting unlisted is missed revenue, which is real but far less damaging than selling something you cannot ship and taking a marketplace defect-rate hit. This card is tuned to the urgent, costly direction. Listing coverage is better read through your marketplace connector. A SKU is flagged but I have stock in the back. What happened? Square’s on-hand count for that location is zero or negative even though physical stock exists. That is an inventory accuracy problem inside Square: a missed receipt, a return not restocked, or drift between POS and online. Fix the on-hand count in Inventory management; the flag clears once Square shows real stock. See POS to Online Inventory Drift Alert. Why do the same SKUs keep getting flagged? Recurring flags almost always mean the inventory feed to the marketplace is stale or one-directional, it pushes listings but does not pull Square’s stock levels down in time. The durable fix is the sync, not pausing listings by hand each morning. Check that the feed reads Square on-hand and deactivates listings at zero. Does this work if my SKUs do not match between Square and the marketplace? No. Matching is on SKU. A Square variation with no SKU, or a SKU that differs from the marketplace listing, cannot be matched and will be a blind spot rather than a flag. Clean up missing and mismatched SKUs first, see Items missing SKU. Which location’s stock does the flag use? The inventory pool the marketplace feed sells against. If your feed sums multiple locations, the flag uses that combined on-hand; if it draws from one fulfilment location, it uses that. This is why a single-location dashboard view can look emptier than the flag, the feed may be summing more than one location. Can I change the threshold? Yes. The default alert fires above 5 flagged SKUs. The threshold can be tuned per merchant in your Vortex IQ workspace settings. Given the account-health cost of marketplace oversells, many merchants set it lower rather than higher.

​
Tracked live in Vortex IQ Nerve Centre

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