Help for owners
My till system and my online store do not agree on stock and orders
Short answer
A till and an online store drift apart when each keeps its own stock count and updates arrive late, twice or in the wrong order. Products matched by name instead of a stable code, refunds that are not sent, and connections that silently expired cause the rest. Pick one system as the truth and compare ten products.
Does this sound like your situation?
- An item sells in the shop and stays available online, so I oversell.
- Online orders never appear in the till's reports.
- Stock is right in one system and wrong in the other.
- Prices or product names differ between the two.
- Refunds in one place do not put stock back in the other.
Why does this happen?
Two systems each keep their own count
Every sale in one place has to reach the other as a movement. If the link sends totals, or sends only some events, the counts split and keep drifting.
Updates arrive late, twice or out of order
Square's webhook documentation says notifications can be delivered more than once, that the order of delivery cannot be relied on, and that failed deliveries are retried for up to 24 hours before being discarded. A connection that does not handle those cases leaves stock wrong.
Confirmed by developer.squareup.com
Products are matched by name, not by a stable code
If a product is renamed, or two variants share a name, the link attaches stock to the wrong item or creates a new product.
Not every kind of change is sent
A sale may be synced while a refund, an exchange, a manual adjustment or a stock receipt is not. Each missing type creates its own kind of drift.
The connection expired or the app was changed
A password change, a revoked permission or an upgrade on one side can stop the link without any visible error, and orders then pile up unsent.
What can I do about it today?
- Compare ten products in both systemsPick fast sellers and write down the stock figure in each system side by side.
- Look at the connection's status pageMost links show last sync time or errors. If it has not run for days, reconnect from the app's own settings.
- Choose where stock is changedFor now, let staff change stock in one system only, so the two are not edited at once.
- Hold back low-stock items onlineMark the few items that are nearly gone as unavailable online until the numbers are checked.
- Do not run a second sync tool on topTwo links writing to the same stock make the problem much worse and harder to trace.
When should I bring someone in?
- The links have been reconnected and the numbers still drift.
- You sell at several locations or on several online channels.
- A custom or older system sits between the till and the shop.
How do I handle it?
- Map what each side sendsI list every event type, sale, refund, adjustment and receipt, and which direction each one moves.
- Match products by a stable keyEach product has one identifier that survives renames, used on both sides.
- Send movements and handle repeatsEach event has an identifier, so a repeated message is skipped and a late one cannot overwrite a newer count.
- Add a reconciliation reportA scheduled comparison shows products where the two systems disagree, so drift is seen early.
- Test with real salesA sale, a refund and a manual adjustment are made on each side and the other side is checked.
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 do I oversell even with a sync?
Because there is always a delay between a sale in one place and the update in the other. Reducing the delay and holding back low-stock items online reduces overselling.
Is it better to use one system for both?
Often, yes, because one count removes the need to sync. It depends on what your till and shop can each do.
Can I fix it by re-importing products?
It can create duplicates and wipe history. Check first how products are matched.
How do I know the link stopped?
Look for the last successful sync time, and compare a recent order in both systems.
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.