Skip to content
Efidis
Efidis

InventoryUpdated 10 min read

You sold what you didn't have: sync your store and stock

3D illustration of a shopping cart, an open empty box and a laptop showing an online store.
In this article

An illustrative example. Friday night, you launch a promotion and 15 paid orders come in for a jacket in size M. The online store said there were 12 left. There were actually 7: three sold in the physical store that afternoon and nobody updated the site, and two were sitting in an uninspected return. On Monday you have to email 8 customers who already paid to tell them it's gone.

Each of those 8 orders cost you ad spend, a payment processing fee you may not get back and a customer who now doubts your store. And nobody in particular made a mistake: the system did exactly what it was told.

Phantom stock

Phantom stock is the units your store shows as available that aren't on the shelf. It can be a unit sold on another channel that hasn't been deducted yet, a damaged item nobody wrote off, or a return that was added back before anyone opened the box. The customer sees the number, pays, and the problem shows up in the warehouse.

DeHoratius and Raman reviewed almost 370,000 inventory records across 37 stores of a single retailer and found that 65% didn't match what was physically there (DeHoratius and Raman, 2008). It's one chain and an old study, but the mechanism is the same in any business: every movement that isn't recorded on the spot opens a gap.

Customers find out late. In an inFlow survey of 1,000 U.S. shoppers who had hit a stockout in the previous 60 days, 24% found out after placing the order and another 37% at the cart or checkout. 77% came away trusting that store's inventory less, and 23% say they have switched sellers or suppliers for good over a stockout (inFlow, 2026). It's a survey commissioned by an inventory software vendor, so treat it as a signal, not an exact measure.

You already lose most carts before checkout: the average abandonment rate is 70.22%, across 50 studies (Baymard, 2025). An order that actually got paid for is the last one you can afford to cancel.

Why your store shows units you don't have

Almost every oversell comes from one of these causes. Use them to diagnose before you change anything.

Two inventories reconciled by hand

The store has its point-of-sale system, the website has its own, and someone matches them up every night or every week. Between reconciliations, both sell the same unit. As long as there are two numbers, there will be phantom stock.

Slow syncing

Some integrations update every hour or once a day. If you sell one unit an hour, an hourly sync all but guarantees overselling on low-stock products. What matters is how many minutes it takes.

Deducting at the wrong moment

If inventory drops when the order is invoiced or shipped, there's a window where the unit is already paid for but still on sale. The unit should be reserved the moment the customer pays, and leave inventory when it ships.

Returns added back before inspection

Returns are a big deal online: retailers estimate that 19.3% of online sales get returned (NRF, 2025). If every return goes straight back on sale, the damaged and incomplete ones go back too. It's one of the most common sources of phantom stock.

Badly set up variants

A T-shirt in three sizes and four colors is 12 SKUs, each with its own stock. If the store lists it as a single product, or each channel names the variants differently, the system doesn't know what to deduct. In apparel and footwear, this is the mistake that shows up most.

What breaks when you sell on three channels

A physical store, an online store and a marketplace. This table walks through each moment of a sale, what happens when the channels don't share inventory and what should happen instead.

MomentIf the channels aren't connectedWhat should happen
In-store saleThe website keeps showing the unit until the next reconciliationThe unit drops on every channel in under a minute
Paid online orderThe unit stays on sale in the store and on the marketplace until it's invoicedIt's reserved as soon as payment is confirmed
Marketplace saleThe marketplace deducts from its own count; your inventory never hears about itThe order comes into the same inventory as the other channels
Pending payment (bank transfer, cash on delivery)The unit is held forever, or not held at allIt's reserved for a set time and released if the payment doesn't arrive
ReturnIt goes back on sale before anyone opens the boxIt goes back on sale only after inspection
Transfer between warehousesThe unit shows up in both warehouses, or in neitherIt leaves one and stays "in transit" until it reaches the other
Cycle countThe adjustment is made in one system and not the othersThe adjustment is made once and reaches every channel
Canceled orderThe unit stays locked even though nobody is taking itThe reservation is released on cancellation

If three or more of your rows land in the middle column, what's missing is a single inventory.

The 15-point checklist

Go through it with whoever ships orders and whoever runs the store, not just whoever manages the website. Every unchecked item is a way to create phantom stock.

One source of truth

  • There's one inventory for the physical store, the online store and the marketplaces; the channels read from it instead of keeping their own.
  • Every size, color or pack size is a variant with its own SKU and its own stock.
  • The same SKU identifies the same variant on every channel.
  • Bundles and kits deduct the units of each product inside them.

Reservations

  • The unit is reserved when the customer pays, not when the order is invoiced or shipped.
  • Orders with pending payment reserve for a set time (24 hours, for example) and then release the unit automatically.
  • A canceled order returns its reservation to available stock right away.

Syncing

  • A sale on any channel shows up on the others in minutes, not hours.
  • You know how long it really takes: you measured it by selling one unit and watching the clock.
  • When syncing fails, someone gets an alert; you don't find out from a customer.

Multichannel

  • Low-stock products have a safety buffer on the channels that are slowest to sync.
  • Transfers between warehouses or stores have an "in transit" status and don't count as available.
  • Cycle counts happen in one place, and the adjustment reaches every channel.

Returns

  • A return goes back into sellable stock only after inspection; until then it sits in a separate status.
  • Damaged or incomplete items leave sellable inventory with a reason code, so you can measure how much you lose that way.

If you checked 13 or more, your overselling comes from one-off cases and keeping an eye on it is enough. Between 8 and 12, there are one or two specific causes to fix. Under 8, the problem is structural: you have several inventories being reconciled by hand.

The safety buffer: when to show less than you have

Even with everything connected, a slow channel or two simultaneous sales can sell the last unit twice. For low-stock products, it pays to show a little less than you have on the slower channels. Losing a sale now and then beats canceling a paid order.

A simple way to calculate it: buffer = hourly sales of that product on the other channels × minutes of sync delay ÷ 60, rounded up. If a product sells 6 units an hour in the store and the website takes 15 minutes to find out, the buffer is 6 × 15 ÷ 60 = 1.5, so 2 units. With 5 in the warehouse, the website should show 3.

Illustrative exampleHourly sales on other channelsDelayBuffer
Slow-moving product0.515 min1 unit
Product on promotion615 min2 units
Product on promotion, hourly sync660 min6 units
Product on promotion, 1-minute sync61 min1 unit

Look at the third row: with slow syncing, the buffer eats almost all the stock of a product that's selling well. Cutting the delay is worth more than any buffer.

How to tell whether you fixed it

  1. Measure today's oversellingCount the orders canceled for lack of stock over the last three months and divide by total orders. That's your baseline. If you haven't been tracking it, start tagging the reason for every cancellation today.
  2. Count a small group every weekPick 20 products, the fastest movers and the ones with the least stock, and count them every week. Write down how many match the system. It's more useful than a full count once a year. How to reconcile that count against the system is covered in reconciliation with AI.
  3. Test the sync by handSell one unit in the store and time how long it takes to drop on the website and the marketplace. Repeat it during your busiest hours.
  4. Check the status of returnsLook at how many returns went back on sale without inspection last month. The answer should be zero.
  5. Measure again after three monthsUsing the same rules, measure overselling and the weekly count match rate again. If they didn't improve, one of the causes is still open.

When connecting everything isn't worth it

Connecting channels costs money and setup time. It isn't always worth it:

  • You sell on one channel, or the second channel sells very little. A daily check of your low-stock items may be enough.
  • You make or source to order. If customers already expect to wait a few days, there's no unit to reserve.
  • You have few SKUs and a lot of stock of each. With 50 units per product, slow syncing will almost never sell the last one twice.
  • Your platform already includes a point of sale or a marketplace integration that nobody set up. Turn it on and measure before paying for anything else.
  • Splitting inventory by channel works for you: for example, 20 units set aside for the website during a promotion. It's less efficient, but it's simple and it doesn't oversell.

Where to start

Start with the cause behind the most canceled orders. If it's returns, the fix is an inspection status and a clear rule. If it's variants, it's cleaning up the catalog. Neither one needs a new system.

If the checklist showed you have several inventories reconciled by hand, there are three paths: use the native integration between your online store and your point of sale, if both run on the same platform; put a connector such as n8n between different systems and measure how long it takes; or bring the online store, the physical store and the warehouse into one app where everything deducts from the same inventory. The third makes sense when, on top of selling on several channels, you have warehouse transfers, bundles or a team that ships orders, because there every extra connection is another source of phantom stock. That's how we approach it for online stores.

Sources

  1. DeHoratius, N. and Raman, A., "Inventory Record Inaccuracy: An Empirical Analysis," Management Science 54(4), 2008 (opens in a new tab)
  2. inFlow Inventory, "Stocked Out: What 1,000 American Shoppers Really Think About Tariffs, Empty Shelves, and Broken Trust," 2026 (opens in a new tab)
  3. Baymard Institute, "Cart Abandonment Rate Statistics," updated 2025 (opens in a new tab)
  4. National Retail Federation and Happy Returns, "Consumers Expected to Return Nearly $850 Billion in Merchandise in 2025," 2025 (opens in a new tab)
See how we work in online stores

Frequently asked questions

Make sure your store only sells what you have

Efidis builds your business's app so every channel sells from the same inventory. On the call we'll look at where you're selling units you don't actually have.