Cannot update Stock Qty when sync enabled and WooCommerce as system of record

Hi there @jeffylube,

Happy to help!

You’re right! If WooCommerce is set as System of Record, you should be able to update inventory in Woo and sync the changes to Square, as you have Sync inventory enabled.

When did you first start having this problem? Have you tried following the steps here to update inventory in WooCommerce?

You’ll need to first select the Fetch stock from Square link below the Stock Quantity field when editing a product before you can update its inventory:

Link to image: https://d.pr/i/Qos0LZ

Can you please try doing that and let us know how that goes? If you’re already done that, can you please see what happens if you try to update inventory in Square?

Thank you!

Hello @wpniall

Yes – I understand I must fetch the stock before it can be edited.

The problem arises when WooCommerce tries to automatically adjust stock after an order purchase. To test – I first I synced all the items under WooCommerce Square Settings -> Update. I then created a test order. In the order notes, it indicates that the inventory stock was reduced. I know it gets reduced momentarily as I received a notice that the product is now out of stock. However, when I go back to check the stock quantity of the product, it goes back to the original count.

I tried using the the WooCommerce Bulk Stock Manager to adjust stock. The same happens. It momentarily is able to adjust, but the stock level quickly goes back to the original.

Best,
Jeff

Did some more testing. When refunding the test order, it was able to successfully increase the stock count.

Hi again,

Did some more testing. When refunding the test order, it was able to successfully increase the stock count.

A small victory, I ll take it.
How does it behave when you create new test product (don’t copy or duplicate one, but create one from scratch)? Does that change anything?

Kind regards,

No issue when creating new products.

Hi again,

No issue when creating new products.

Thanks for testing. Does that hold true when you through a full order cycle as well?

* Set stock to 1.
* Place order.
* Stock gets reduced.
* Product stays out of stock when visiting product on both WooCommerce and Square

(?).

If it does, then there could be a minor database problem with the product you tested in which case I would recreate it from scratch and replace the current instance.

Kind regards,

Hello

This happens for all watches I’ve tested on.

* If stock is set to 1.
* Place order.
* Stock gets reduced.
* Product becomes out of stock and I get a notification.
* Almost immediately, the stock then gets reset back to qty before the purchase.
* Product is shown to have 1 in stock for both WooCommerce and Square.

Thanks for testing @jeffylube. At this point, it makes sense to take a look at your Square and fatal error logs, but it would be risky to share these on a public forum. Can you contact our support team directly at [email protected], link to this thread for context, and provide your most recent fatal error logs and Square sync logs?

You’ll only be able to get Square product sync logs if you currently have logging enabled for Square. To check, go to WooCommerce > Settings > Square and find the “Enable logging” setting. If this was already checked, please find the Square sync logs using the instructions below.

If it wasn’t checked, please check it, then purchase a product again so the inventory of the product goes down and then erroneously back up again, which should trigger a log entry.

To find the logs: Go to WooCommerce > Status > Logs in your site’s WP Admin area, open the dropdown by the “View” button, and look for the latest dated log files with “fatal-errors” and “square” in the name. You can ignore logs with “square-credit-card” in the name, as this is for the payment gateway portion of Square.

Please view the logs by clicking on them and then clicking the “View” button, as shown here: https://d.pr/i/zYVxgL

Then please copy the contents of these logs into pastebin.com, click “Create new paste,” and then share the links via email as explained above so that we can take a look. To clarify, the latest fatal error log and latest Square product sync log should each have separate pastebin links.

Thanks so much! I’m going to mark this thread as resolved since you’ll be contacting us directly.