Inventory not Syncing from Woo to Square

Hi there,

Can you try a quick manual test: Edit a product’s inventory manually in WooCommerce. Save the product, then wait a full minute and check if Square was updated.

Does that work?

If not, take a look at the Square Sync logs next. Note that Square has two different sets of logging that can be enabled. Payments, under the WooCommerce > Settings > Checkout > Square tab. And Sync, under the WooCommerce > Settings > Integration.

In the sync logs check to see that there is an entry for the sync
Check to make sure there are no clear errors related to that sync action
You may see several lines in the logs for the sync, including grabbing information for the product. The important part will be Updating Square Inventory for:

Is there an entry for the product you tested?

Kind regards,

Hi Con,

Thanks for your reply.

I’m not able to edit a products inventory. The function is disabled on any product synced with square. I did add a new product, synced and waited. The product did not show up in Square however the inventory was reduced to zero on that product in WooCommerce.

Checking logs, I can see the item was added (upserted) to square, with 0 inventory (Inventory in Woo is set to 1):
11-05-2019 @ 08:43:58 – Upserted 1 objects in 0.25s
11-05-2019 @ 08:43:58 – Mapping new Square item IDs to WooCommerce product IDs
11-05-2019 @ 08:43:58 – Mapped 2 Square IDs in 0.05s
11-05-2019 @ 08:43:58 – Storing Square item data to WooCommerce products
11-05-2019 @ 08:43:58 – Stored Square data to 1 products in 0.05s
11-05-2019 @ 08:43:58 – Completed job step: upsert_new_products
11-05-2019 @ 08:43:58 – Completed step cycle: upsert_new_products (0.43s)
11-05-2019 @ 08:43:59 – Starting step cycle: push_inventory
11-05-2019 @ 08:43:59 – Request
Request
method:
uri: batchChangeInventoryWithHttpInfo
user-agent: WooCommerce-Square/2.0.5 (WooCommerce/3.7.1; WordPress/5.2.4)
headers: Array
(
)
body: {
“idempotency_key”: “(*I have the key if you need it)_change_inventory”,
“changes”: [
{
“type”: “PHYSICAL_COUNT”,
“physical_count”: {
“catalog_object_id”: “FNZGZABKM74KKWY6HLF65H6N”,
“state”: “IN_STOCK”,
“location_id”: “V3VDTBWSV686N”,
“quantity”: “0”,
“occurred_at”: “2019-11-05T13:43:59+00:00”
}
}
],
“ignore_unchanged_counts”: true
}
duration: 0.2649s

Thanks,
K

Hi @kadie,

Just to confirm for us quick, and I assume, in your Square settings tab in WooCommerce is the Sync inventory option enabled?

Link to image: https://cld.wthms.co/Nz7dqH

I assume this is checked as even with Woo as your system of record it’s going to pull any matching inventory from Square. Thus the product will be synced over to Square but it seems to reset the inventory to 0. That second part doesn’t seem necessarily correct to me, so I’ll ask out team about this.

But in the mean time, once your product has synced from Woo -> Square you can adjust the inventory for said product in Square itself and then use the Fetch stock from Square link. Or also try this from within Woo…

When editing the published product first uncheck the “Sync with Square” checkbox in the General section.

Link to image: https://cld.wthms.co/maGd6A

Then in the Inventory section you’ll be able to enter the stock you have on hand. Once you’ve done that go back to General and enable “Sync with Square” again and select Update on the product.

Link to image: https://cld.wthms.co/SVxwPa

This then pushes that inventory number over to Square.

Link to image: https://cld.wthms.co/ctM6M2

• This reply was modified 5 years ago by Ryan Ray, a11n.

Hi Ryan,

Thank you for your reply.

To confirm my settings, yes, the sync with square tab is checked.

I’m trying to avoid having to change inventory in Square and sync with Woo. This site is for a client who is not tech savvy and I am afraid it will overwhelm her.

I went back in and tried your second suggestion. I chose a published product, unchecked the sync to square button on the product, adjusted the stock quantity, went back to General and checked sync to square, then updated the product. The inventory did sync however it is one less than the stock quantity. This must be why stock was showing as zero before. The products are original works of art so the stock qty was 1 which was syncing to zero. I changed one of the products to 2, and it synced to 1.

Does this provide any additional clue as to what may be happening?

Thanks,
K

Hi @kadie,

I went back in and tried your second suggestion. I chose a published product, unchecked the sync to square button on the product, adjusted the stock quantity, went back to General and checked sync to square, then updated the product. The inventory did sync however it is one less than the stock quantity. This must be why stock was showing as zero before. The products are original works of art so the stock qty was 1 which was syncing to zero. I changed one of the products to 2, and it synced to 1.

Good testing. Still odd though. Seems like the mechanism is working but something is tampering with the value.

Let’s try and move to square one. Can you create a simple product from scratch (don’t copy an existing one). Set the stock quantity to 5. Make a test purchase. Try the sync.

Does that change anything?

Kind regards,

Hi there,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread here or send a ticket via https://woocommerce.com/my-account/create-a-ticket/

Kind regards,