Here’s the logs:
2023-08-25T00:06:39+01:00 DEBUG Added 3 jobs to the queue 2023-08-25T00:06:40+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T00:06:42+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:31:17+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:31:18+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T05:32:18+00:00 INFO Attempting to sync inventory of WC_Product_Variation 103568 with PayPal Zettle UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T05:32:19+00:00 INFO Moved 1 items from STORE to SOLD 2023-08-25T05:32:19+00:00 DEBUG Executed Job ‘sync-product-stock’ with ID 3779. 2023-08-25T05:32:19+00:00 DEBUG Removed 1 jobs from the queue 2023-08-25T05:32:19+00:00 DEBUG Executed Job ‘sync-product’ with ID 3780. 2023-08-25T05:32:19+00:00 DEBUG Removed 1 jobs from the queue 2023-08-25T05:43:36+00:00 DEBUG Added 1 jobs to the queue 2023-08-25T05:43:37+00:00 DEBUG Executed Job ‘sync-product’ with ID 3781. 2023-08-25T05:43:37+00:00 DEBUG Removed 1 jobs from the queue 2023-08-25T06:43:37+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:43:41+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:43:42+01:00 DEBUG Executed Job ‘sync-product’ with ID 3782. 2023-08-25T06:43:42+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T06:43:43+01:00 INFO Enabled inventory tracking for WC product 103537 with UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T06:43:43+01:00 DEBUG Executed Job ‘set-inventory-tracking’ with ID 3783. 2023-08-25T06:43:43+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T05:44:37+00:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:44:39+01:00 DEBUG Executed Job ‘sync-product’ with ID 3784. 2023-08-25T06:44:39+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T05:52:16+00:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:52:22+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:52:24+01:00 DEBUG Executed Job ‘sync-product’ with ID 3785. 2023-08-25T06:52:24+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T06:52:24+01:00 INFO Enabled inventory tracking for WC product 103537 with UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T06:52:24+01:00 DEBUG Executed Job ‘set-inventory-tracking’ with ID 3786. 2023-08-25T06:52:24+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T06:06:21+00:00 DEBUG Added 1 jobs to the queue 2023-08-25T06:06:23+00:00 DEBUG Executed Job ‘sync-product’ with ID 3787. 2023-08-25T06:06:23+00:00 DEBUG Removed 1 jobs from the queue 2023-08-25T07:06:23+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T07:06:27+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T07:06:27+01:00 DEBUG Added 1 jobs to the queue 2023-08-25T07:06:28+01:00 DEBUG Executed Job ‘sync-product’ with ID 3788. 2023-08-25T07:06:28+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T07:06:28+01:00 INFO Attempting to sync inventory of WC_Product_Variable 103537 with PayPal Zettle UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T07:06:29+01:00 INFO Moved 2 items from SUPPLIER to STORE 2023-08-25T07:06:29+01:00 DEBUG Skipping product 103568: 314 – 314. 2023-08-25T07:06:29+01:00 DEBUG Skipping product 103569: 253 – 253. 2023-08-25T07:06:29+01:00 DEBUG Skipping product 103570: 294 – 294. 2023-08-25T07:06:29+01:00 DEBUG Skipping product 103571: 140 – 140. 2023-08-25T07:06:30+01:00 INFO Moved 1 items from SUPPLIER to STORE 2023-08-25T07:06:30+01:00 INFO Moved 1 items from SUPPLIER to STORE 2023-08-25T07:06:30+01:00 INFO Moved 1 items from SUPPLIER to STORE 2023-08-25T07:06:30+01:00 DEBUG Executed Job ‘sync-product-stock’ with ID 3789. 2023-08-25T07:06:30+01:00 DEBUG Removed 1 jobs from the queue 2023-08-25T07:06:30+01:00 INFO Enabled inventory tracking for WC product 103537 with UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T07:06:30+01:00 DEBUG Executed Job ‘set-inventory-tracking’ with ID 3790. 2023-08-25T07:06:30+01:00 DEBUG Removed 1 jobs from the queue
` WordPress Environment
WordPress address (URL): https://yorkcityfootballclub.co.uk
Site address (URL): https://yorkcityfootballclub.co.uk
WC Version: 8.0.2
REST API Version: ✔ 8.0.2
WC Blocks Version: ✔ 10.6.5
Action Scheduler Version: ✔ 3.6.1
Log Directory Writable: ✔
WP Version: 6.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: –
Language: en_GB
External object cache: ✔ Server Environment
Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 1 GB
PHP Time Limit: 300
PHP Max Input Vars: 6000
cURL Version: 7.87.0
OpenSSL/1.1.1p
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.21-MariaDB-cll-lve
Max Upload Size: 1 GB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔ Database
Hello,
Thank you for reaching out to us, we are here to help. I just replied to your older thread, so will copy the response here:
We see this issue more often and wrote a FAQ item about this, please take a look and see it that helps you to test this issue and finding the source of this problem.
If you want us to look into your system report, logs or other details from your site, you might want to open a private thread with us, so we can easier share these details, and they won’t be available via this public forum. However, this issue can probably only be resolved by performing the tests we described and finding out what is causing this situation, in order to correct it.
Pending your response.
Kind regards,
Joost
-
This reply was modified 2 years, 9 months ago by
Syde Joost.
Couple of questions:
I’ve been running various tests and even abandoned the plugin in favour as an alternative, but that has separate issues.
1. Is it necessary for variation products to have ‘Track stock quantity for this product’ ticked for stock to be updated from Zettle sales > Woocommerce?
2. The stock updates aren’t in real-time. I’ve noticed some stock updating up to 2 hours after an order has completed.
The time delay makes it very difficult to test properly. For example, I’d deactivated various plugins to see if there was a conflict. Deactivating these plugins didn’t appear to resolve the issue, but then the stock later updated so I still don’t know which (if any) plugins were conflicting.
The webhook that appears to commit the update hasn’t been seen in the log files since 7th August.
3. Does the INFO Moved…etc mean the stock has been updated? Not sure why it says SUPPLIER to STORE?
2023-08-25T08:39:26+00:00 INFO Attempting to sync inventory of WC_Product_Variable 103537 with PayPal Zettle UUID 64d29b4c-0000-1000-8000-00718164a35d 2023-08-25T08:39:27+00:00
INFO Moved 7 items from SUPPLIER to STORE
Just read your help. We did change domain around the time the problem first occurred. Could this affect ONLY one-way stock syncing whilst everything else works?
Hello @modedmarketing
Yes, definitely!! The return address from Zettle –> WC will think the stock changes/updates should be sent to the old URL, so that would not work.
The URL for the return webhook should be corrected by for this situation, and I was told that this should be possible by deactivating and reactivating the plugin (which refreshes the webhooks).
However, I was never able to test this by myself, so I would be very interested in hearing if this resolved the issue.
Initially I thought that this could only be done, by restarting the onboarding process, that would re-create the UUID entries for the plugin in the WP Database. The UUID is the entry that links the WC and the Zettle product together; this is also where the return URL should be stored for our plugin.
Please try this and let me know if this helped you resolve the issue.
Kind regards,
Joost
I can confirm that redoing the onboarding sorted it. Clearly the sync of products from Zettle > Woocommerce is domain dependent.
One question, is how would you alert shop staff on the Zettle app that online orders have pushed items to zero stock? Unless you’re picking online orders off the shelf in real-time, there’s a real risk of selling a product that’s already been sold to an online customer.
Hello @modedmarketing
Good to hear you got the initial issue resolved. Just for my curiosity: did you try the deactivating/activating the plugin first?
From our plugin, there is not really any additional features that can help you set up any sort of notification for this situation. The only thing you can do for this situation is to set up the low stock setting in WooCommerce. This will still only result in an email being sent to the admin account, but it is the only option I can think of for improving this situation.
I hope this helped you, although I know the situation you are trying to avoid is not really something you can avoid completely. I would believe that keeping a close eye on online sales, is the only way of doing this.
Let me know if you have more questions.
Kind regards,
Joost
Yes, we disconnected Zettle and deactivated / reactivated the plugin. This had the effect of starting a fresh onboarding process.
Hello @modedmarketing
Thank you for confirming that way works as well (saves merchants a lot of time). I will add it to our documentation!
I will close this thread, don’t hesitate to open a new thread if you need anything else.
Kind regards,
Joost
