Woocommerce is not in stock in second language

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	-
-	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	-

Supporter timezone: Asia/Kathmandu (GMT+05:45)

Tagged: WCML

This topic contains 20 replies, has 2 voices.

Last updated by Shekhar Bhandari 1 day, 8 hours ago.

Assisted by: Shekhar Bhandari.

Author	Posts
September 30, 2024 at 10:58 am #16235646
Shekhar Bhandari Supporter Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, Yes, you can create a new staging site, I agree with updating all products at once, you can try it with 100 at a time. Look forward to your reply. Thanks
September 30, 2024 at 12:12 pm #16236048
kasperG	Even updating 100 products crashes the server. See attached. Going lower means manually updating the products more than 40 times. This is without having any reassurance that this will fix the issue. The error hasn't even been located. It feels like I've been sent on a wild goose chase here. Is there any way to get to the bottom of the issue here before trying out possible fixes which will take me hours of work?
September 30, 2024 at 12:42 pm #16236180
Shekhar Bhandari Supporter Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, I understand your concern but to fix the issue we would need to find a way to reproduce which in this case is random, making it hard to debug properly. I am asking for a second opinion from our 2nd tier to see if there is any other options rather then updating the products manually. Thanks
September 30, 2024 at 12:46 pm #16236185
kasperG	Hi sure, but updating the products will not lead to re-produce the error. It will only fix it. As I wrote earlier products go from OK to not in stock and a price of 0. I cannot see how bulk updating all products in the shop will help locate the error. Not sure what the end goal is with updating the products. Eventually, some will go back to not being on stock, and then we're at the same point, as we are now. Let me know if you have any updates.
October 1, 2024 at 7:36 am #16238707
kasperG	Hi again, Is there any way we can escalate this issue? We’re losing money because our customers can’t purchase our products. I’d really appreciate any help you can provide.
October 1, 2024 at 7:38 am #16238710
Shekhar Bhandari Supporter Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, I have already escalated this issue to our 2nd tiers for further feedback and I am waiting for there response. I will update you as soon as I will receive any further feedback from them. Thanks
October 1, 2024 at 9:10 am #16239153
Shekhar Bhandari Supporter Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hi, I’ve just received feedback from our second-tier support team, and they also pointed out that identifying the root cause of this issue is difficult due to its random occurrence. They also mentioned that stock counts may not have synchronized correctly, especially if there were server outages (Apache, PHP, or database), or if WCML was temporarily deactivated. This could have led to stock discrepancies for purchases made during that time. We understand this process may take time, and I agree that manually updating products in batches is not ideal. However, at this moment, it’s the only workaround available. Looking forward to your response. Thanks,
October 3, 2024 at 9:57 am #16248900
kasperG	The issue seems to be related cached transients in Woocommerce. We're investigating further. Please keep this ticket open.
October 3, 2024 at 11:51 am #16249559
Shekhar Bhandari Supporter Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Sure.