How to manage inventory across multiple warehouses without overselling

On-hand is not available to sell. Once stock lives in more than one warehouse, available-to-sell is a decision per channel: on-hand minus reserved, plus inbound only if you truly sell pre-orders, or do not publish the SKU at all for a drop you cannot afford to race.

Hold a buffer on the channel

Overselling is usually latency plus a wrong number, not missing API calls. The channel decrements, the system of record still holds the old quantity, and the next export writes stock back up. Hold a buffer on the channel so warehouse counts stay honest.

A percentage scales with the pile and still holds at least one unit when you are almost out. 500 on hand at 10 percent publishes 450. 10 on hand publishes 9. A fixed buffer of 5 publishes 495, then 5. The fixed number does not shrink, which is why teams use it near sellout. Item-level buffers override channel defaults. If the storefront already holds stock back, do not buffer twice.

Map warehouses and sellable zones

Map every warehouse as a location on the channel. Unmapped sites show as false stockouts. Only the primary sellable zone should publish. Staging, returns, samples, and quarantine should stay out of available-to-sell. If quarantined lots stay visible on the variant, counts look right and you can still oversell.

Move stock with transfer orders

Move stock with transfer orders, not spreadsheet adjustments. In-transit is not in either warehouse until it is received. Sell it only if you chose an availability rule that includes inbound. Cycle-count the 3PL; some 3PLs only update you when a count file lands. FBA ledgers are often a day old. Amazon Reserved can land as on-hand. If the ledger shows 100 and 40 of those are Reserved, publishing 100 to Shopify will oversell the 40.

Why pooled buffers drain one site

A pooled buffer across warehouses can drain one site to zero while another still has stock. East has 20, West has 80. A 10 percent buffer on the combined 100 holds back 10 and publishes 90. Orders can still route to East until those 20 ship. East is then empty, West still has 80, and the next East-preferred order sits. Safety stock per warehouse is what people want and often do not have. Splitting an order across warehouses is normal. Splitting one line between own stock and dropship usually is not.

For an unattended drop: reserve units, set a buffer, or stop exporting that SKU. None of that is a guarantee. Reconstruct the ledger for the SKU and timestamp before you call it an oversell.