Help for owners
My Square orders and my inventory do not match
Short answer
In Square, orders built from catalog items update inventory when completed or refunded, and counts move between states such as in stock and sold. Mismatches come from orders made without catalog items, unfinished or cancelled orders, offline timing, missed webhooks and counts changed by physical count. Compare one item through its movements.
Does this sound like your situation?
- Orders exist in Square but my own system or spreadsheet does not show them.
- Stock in Square is lower or higher than sales suggest.
- A product sold but its count did not change.
- Orders from my website or another app do not reach inventory.
- A physical count reset the number and I cannot see why it was wrong.
Why does this happen?
Only orders built from catalog items move stock
Square documents that orders created from catalog items update inventory when they are completed or refunded. A custom amount or an item typed in by hand has no catalog item to take stock from.
Confirmed by developer.squareup.com
Inventory moves between states, not just down
Square's inventory records adjustments that move quantity between states, for example in stock to sold or to waste. A count is computed from adjustments made since the last physical count, so a count that does not move may mean the state did not change, not that the sale was lost.
Confirmed by developer.squareup.com
A physical count overrides the computed number
Square's example shows a computed count of 94 being replaced by a physical count of 93. A count entered with errors hides the earlier history and shifts every later figure.
Confirmed by developer.squareup.com
Orders from every channel are visible, but not all of them are yours
Square states that any order for a connected seller account is visible to an integration, whoever created it. A report that filters by source or channel may leave some out, or include sales you did not expect.
Confirmed by developer.squareup.com
Notifications were missed or handled twice
Webhook deliveries are retried for up to 24 hours and can arrive more than once and in any order. A receiver that errors, is slow or does not de-duplicate misses orders or counts them twice. Square points to its Events API for recovering missed notifications.
Confirmed by developer.squareup.com
What can I do about it today?
- Pick one item and follow itIn Square's dashboard, find one product with a mismatch and read its inventory history and its recent orders.
- Check whether the sales used catalog itemsSee if staff rang up custom amounts instead of the product.
- Look for cancelled, open and refunded ordersThese explain many differences without any fault in the link.
- Check when the last physical count was madeA recent count that was wrong can shift the number.
- Do not re-import orders into your own system yetA re-import can create duplicates. Find first how your system receives orders.
When should I bring someone in?
- Your own system is meant to follow Square and still disagrees.
- You have several Square locations or other sales channels.
- Orders go missing at random and you cannot reproduce it.
How do I handle it?
- Follow one item through Square's recordsI read its orders, adjustments and physical counts in time order and find the first place the figure departs from reality.
- Check how my system receives ordersNotification endpoint, response speed, handling of repeats and the way missed events are recovered.
- Reload recent days safelyRecent orders are read again and matched by Square's identifiers, so nothing is created twice.
- Add a daily comparisonOrder totals and counts are compared between Square and your system, and differences are listed.
- Fix the way staff ring up salesWhere custom amounts bypass stock, I recommend catalog items for products that must be counted.
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?
Why did a sale not reduce stock?
Square documents that stock updates when orders built from catalog items are completed. A custom amount has no item to reduce.
Can I trust the number after a physical count?
It is the verified figure at that moment. Entering the count carefully matters, because it replaces the computed one.
How do I recover missed notifications?
Square points to its Events API for reconciling missed notifications.
Do I need a developer to check this?
You can follow one product's history yourself. The link between Square and your own system needs a developer.
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.