Inventory synced but incorrect

Hello Matthew,

We have now finally been able to reproduce this issue and found out that this issue is affecting products that have more than 4 variations. With this information, we can start pushing towards a fix. Please stand by for more details to come soon.

Kind regards,
Joost

Me again @joostvandevijver!

Well I’m sorry to report I think you have some key issues with logic in your plugin. I’ve just tested with a product on GEBC that I spotted had different stock levels in WooCommerce vs Zettle and the following happened:

20 in WooCommerce, 18 in Zettle, 18 is correct.
Reduce Zettle to 17, WooCommerce to 19.
Reduce Zettle to 16, WooCommerce to 18.
Reduce Zettle to 15, WooCommerce to 17.
Increase WooCommerce to 18, Zettle to 18.

Your plugin isn’t doing any checks against the actual numbers coming from Zettle, just reducing by the same amount. This means when a product gets out of sync, which seems to be happening all the time, they never get back into sync unless the update comes from the website.

I appreciate that WooCommerce is meant to be the main source of truth for stock levels but in most cases I’ve seen (maybe all) the stock level has been right in Zettle and wrong in WooCommerce – this is obviously because products are being bought in store via Zettle but this information isn’t getting to WooCommerce.

Also this issue has nothing to do with variations, all of the issues I’ve looked at concern simple products.

Just happened across 2 massive changes in stock levels on GEBC from 11:16 this morning:

1 of this one was purchased in store, stock level in WooCommerce went down by 90!!

2 of this one were purchased in store, stock level in WooCommerce went up by 84!!

Hello Matthew,

we are now able to recreate the issue: it seems this affects only products that have more than 3 variations. The issue is that amounts and variations are being mixed up somehow. We have got both our developer and Zettle looking into this.

At this moment I am waiting for their responses.

Kind regards,
Joost

Joost, as I’ve said multiple times none of these products have any variations, they’re all simple products.

Hello Matthew,

I have only been able to recreate this issue with variable products. If you have any idea how you got it to occur with a simple product, I would love to know.

Kind regards,
Joost

• This reply was modified 2 years, 11 months ago by Syde Joost.

Hi @joostvandevijver,

Appreciate your efforts of course, the whole thing is just a nightmare ?? The only consistent things is that this always seems to be a problem when an order is placed in Zettle.

I’m going to have to suggest to my clients that we disable the plugin entirely until you guys have sorted it out, they’ll have to adjust stock manually on both platforms but at least they won’t see crazy discrepancies like -90 and +84 on the website when a single item has been purchased in store.

Hello Matthew,

I just heard we have identified the issue and will test a possible fix tomorrow. If all goes as planned we could have a release tomorrow or on Friday. However, I cannot confirm this at this time. Tomorrow more…

Kind regards,
Joost

FANTASTIC NEWS!! Fingers crossed for a quick fix ???? Do you have any more details about the issue they’ve found?

REBC have decided to leave the plugin active as it’s important for them that WooCommerce orders continue to update Zettle and they’ll keep an eye on the website when orders are placed in store (which is regularly!)

Hello Matthew,

Our developer identified the cause of the issue, we are working on releasing the fix. Hopefully, that will happen today; we will let you know.

Kind regards,
Joost

Hello,

if anyone is tracking this thread for a fix: there is a beta version available of the fix, but we don’t want to share these beta versions on public forums. If you want to get this beta version, please contact us via our service desk: https://zettle.inpsyde.com/docs/request-support/
(please link the URL of this thread to the request as well)

Kind regards,
Joost

@joostvandevijver looks like we have some progress here! The client decided they were happy to install 1.5.3-rc3 on production, I’ve pushed this up and done a quick bit of testing.

First thing I’ve noticed is that manual stock level changes in Zettle now affect WooCommerce!! That hasn’t worked on REBC at all until now, so that’s great to see. I think there still needs to be some better logic here though as the following happened:

A product had 1 in stock in Zettle, 2 in WooCommerce.
Increased to 3 in Zettle, WooCommerce went to 4.
Reduced to 2 in Zettle, WooCommerce went to 3.
Reduced to 1 in WooCommerce, Zettle went to 1.

I really think your plugin needs to be checking the actual numbers of stock coming from either platform instead of just increasing by X amount, that would be much more reliable surely..

REBC just had an in-store purchase and the numbers are correct on both platforms!! They will continue to monitor..

WC log looks good, each product reducing by 1 instead of 100!

2021-12-16T12:23:30+00:00 INFO Attempting to update stock of product 1842 with an amount of -1
2021-12-16T12:23:30+00:00 INFO Attempting to update stock of product 6500 with an amount of -1
2021-12-16T12:23:30+00:00 INFO Attempting to update stock of product 1011 with an amount of -1
2021-12-16T12:23:30+00:00 INFO Attempting to update stock of product 6133 with an amount of -1
2021-12-16T12:23:30+00:00 INFO Attempting to update stock of product 5763 with an amount of -1

Hello @matthewdixon

the logic that you described is indeed how it works. I have addressed this already some times before and this has been put in place for a good reason and can’t be adjusted (sorry that I cannot explain that reason here). We do understand your point and hope that at some point we can make the synchronization more logical and similar in both directions.

For now, this is working as designed and will mark this thread as resolved.

Thank you again for your continued support in testing this issue and helping us getting to the fix!

Kind regards,
Joost