Kayabyte

Wix and Square stock don’t match: 9 common causes and fixes

By Kayabyte

Short answer: when your Wix store and your Square point of sale show different stock for the same item, the cause is almost always one of a few things: the item isn’t really linked (different or duplicate SKUs), stock tracking is off on one side, the sync follows a different Square location than the one you sell from, a spreadsheet import or a second tool overwrote counts, or weighed items, variants and returns are counted differently. Pick three items that are wrong, work through the list below, and you’ll usually find the cause quickly. It applies whether you update stock by hand, with spreadsheets or with a sync app.

Before you start: look at one item on both sides

Pick one item that is wrong. In Wix, open Store Products > Inventory and note the count for that exact variant. In Square, open the item in the Item library and note the stock for each location. Then write down the item’s SKU on both sides, character by character. Most of the causes below show up in those three numbers.

1. The SKUs don’t match

Sync tools link items by SKU. “TEE-RED-M” in Square and “TEE-RED-MED” in Wix are two different items to them, so neither side ever changes the other.

Fix: make the SKU the same on both sides, then link the item again (or let the tool’s next check pick it up).

2. The same SKU is used twice

If two Square items, or two Wix variants, share one SKU, a careful tool won’t guess which one is meant and leaves both unlinked. A careless one links the first it finds, and the other item drifts.

Fix: search for the SKU on both sides, give each item its own, and check the tool’s list of duplicates if it has one.

3. Stock tracking is off on one side

A Wix product that doesn’t track quantity is simply “in stock”, and a Square item without stock tracking has no count to sync. The other side then looks right while this one never changes.

Fix: turn on quantity tracking for the product in Wix and stock tracking for the item at your location in Square, then sync the item again.

4. The sync follows a different Square location

Square keeps a separate count per location. If you sell online from your warehouse stock but the sync follows your shop, or you added a second location later, the Wix count follows the wrong number.

Fix: check which location the tool follows, and compare Wix with that location’s count, not the total.

5. An import or export overwrote the counts

A CSV import replaces counts with whatever was in the file. Any sale made between the export and the import, on either side, is lost. The same happens with tools that copy the whole number from one side to the other instead of the change: if two sales happen at the same moment, one of them can be overwritten.

Fix: stop using imports for stock once a sync is running. Recount the affected items, set the correct count on the side the tool treats as the source, and prefer a tool that sends changes (“minus 2”), not totals.

6. Two tools are connected at the same time

A leftover sync app, a Zapier or Make automation or an old spreadsheet routine can keep running next to the new tool. Each one moves stock, so a sale is counted twice, or one tool undoes what the other did.

Fix: list everything connected to your Square account (Square shows the apps you’ve authorised) and to your Wix site (Apps > Manage Apps), and turn off what you no longer use.

7. Weighed items and fractions

Square can count stock in fractions, such as 2.5 kg of coffee. Online stores count whole units, so 2.5 kg usually shows as 2 online. That is a display difference, not lost stock.

Fix: none needed, as long as you know it. If you’d rather sell by the bag, set the item up in units on both sides.

8. Returns and restocks

A refund doesn’t always put the item back in stock. In Square, a return can be restocked or not. In Wix, check whether the refund put the item back. If one side restocks and the other doesn’t, they drift by one.

Fix: decide on one rule for returns (restock or not), use it on both sides, and fix the count of any item that was refunded differently.

9. Overselling and negative counts

If the same last item sells in the shop and online at nearly the same time, one side can go below zero. Some systems show the negative number and others show 0, so the two sides look different even when they agree.

Fix: recount the item, set the correct count, and check that the tool keeps checking the item until both sides are back at 0 or above.

A quick weekly check

  1. Pick five fast-moving items and compare the counts on both sides.
  2. Check the tool’s log or error list for items it couldn’t sync.
  3. Look for new products without a SKU, or with a SKU that’s already in use.
  4. Check that nobody imported a spreadsheet or connected a second tool.

Where Inventory Sync for Square fits

Inventory Sync for Square is our app, so read this part with that in mind. It syncs stock both ways within seconds and sends changes rather than totals, so sales on both sides at the same moment are both counted. It links items by SKU (ignoring case and extra spaces), lists duplicate SKUs instead of guessing, follows one Square location you choose, and runs a safety check every 15 minutes that copies anything that was missed. Every change is in its activity log. The Free plan syncs up to 25 items; Pro is $14.99 a month with a 14-day free trial.

FAQ

Why does my Wix store show an item in stock that sold out in Square? Usually the item isn’t linked (different or duplicate SKU), stock tracking is off in Wix, or the sync follows a different Square location.

Can I fix counts by importing a spreadsheet? For a first setup, yes. Once a sync is running, an import overwrites counts and loses any sales made since the export.

Why does Square show 2.5 and Wix show 2? Square can count weighed items in fractions; online stores count whole units, so the web shop rounds down.

More: How to sync Square inventory with your Wix store, Does Wix sync inventory with Square?, Wix and Square inventory sync apps compared.