Help for owners
Shopify stock numbers do not match my warehouse
Short answer
Shopify tracks stock per location and in several states, not as one number. A sync that writes the wrong state, the wrong location or a stale count makes Shopify and the warehouse disagree. Pause bulk stock edits, count one product by hand, and send the figures from both systems to your developer.
Does this sound like your situation?
- Shopify shows stock that the warehouse does not have, and I oversell.
- A product shows in stock at one location and zero at another.
- The warehouse system says one number and Shopify another, every day.
- Stock fixed by hand goes wrong again after the next sync.
- Returns or incoming stock never show in Shopify.
Why does this happen?
Shopify has more than one stock number
Shopify tracks inventory per location and splits it into states such as available, committed, reserved, damaged, safety stock and incoming, with on hand as the physical total. A sync that treats them all as one number will not match.
Confirmed by shopify.dev
Setting a value and adjusting a value are different
Shopify offers one action that sets an exact quantity and another that applies a change. If a sync sends a stale total while orders are arriving, it overwrites the sales that happened in between.
Confirmed by shopify.dev
Committed stock is controlled by Shopify
Shopify states that committed quantities, which cover unfulfilled orders, cannot be adjusted through the Admin API. A warehouse system cannot simply overwrite them.
Confirmed by shopify.dev
Some stock changes send no notification
Shopify sends webhooks for inventory level updates, but changes to committed, reserved, damaged, safety stock and quality control quantities do not trigger them. A sync that waits for notifications will miss those.
Confirmed by shopify.dev
Locations or product codes do not line up
A warehouse may be mapped to the wrong Shopify location, or a product re-created with a new code, so the sync updates one item while the shop sells another.
What can I do about it today?
- Stop bulk stock edits and importsChanging hundreds of numbers while the sync runs makes it impossible to see which side is right.
- Count one product by handPick a single product, count it on the shelf and write down the physical count, the Shopify number and the warehouse system number, with the time.
- Note which location sells itIn Shopify, find which location the product is stocked at and which locations are used for online orders.
- Do not switch off tracking on productsThat would let the shop sell with no limit. If you must stop sales of a product, set it to unavailable and tell your developer.
- Send the figures to your developerThe three numbers, the location name, and when the last correct match was.
When should I bring someone in?
- You are overselling and cancelling orders.
- More than one warehouse or shop location is involved.
- A bulk edit already changed many products.
How do I handle it?
- Map items and locations firstI match each product code and each warehouse to its Shopify location in a written table you can check.
- Decide which system owns which numberUsually the warehouse owns on-hand counts and Shopify owns what is committed to orders. The sync respects that split.
- Send changes, not totalsAdjustments carry a reference so they can be audited, and a periodic full comparison catches any drift.
- Test with a few productsI run it on a handful of products with your count at hand before the whole catalogue.
- Add a mismatch reportYou get a short report of products where the two systems disagree.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
Can the sync run in real time?
Not from webhooks alone, because Shopify does not send them for every inventory state. A regular comparison is needed as well.
Which number does Shopify sell against?
The available quantity at the location that fulfils the order. That is why the location mapping matters.
Is my stock data lost?
No. Shopify and the warehouse system both still hold their numbers. The fix is to make them agree and to keep them that way.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.