Background of the issue:
I am trying to make the content visible after uploading translations using WebToffee. I have been using the troubleshooting options recommended by the WPML support team, but it desyncs the existing translations. I suspect there might be compatibility issues with my theme.
Symptoms:
The sync for tables breaks randomly, making some attributes not visible. Examples include: /en/tv-franko-32-81cm-ftv-32sh1300-android-hd/ and /televizori-lg-50-126cm-50ut81009lb-adkg-4k-uhd/.
Questions:
Do you have any recommendations I can follow to fix the desynchronization issue?
Are there known compatibility issues between WPML and my theme?
Before one of my colleagues continues with this ticket, I kindly ask you to double-check if you have followed the steps described in the official WebToffee documentation: hidden link
Please grant me access to your site and direct me to where I can view this issue.
If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply.
Privacy and Security Policy
We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ **IMPORTANT**
- - Please backup the site files and database before providing us access. --
-- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.--
You wrote: "The sync for tables breaks randomly, making some attributes not visible. Examples include: /en/tv-franko-32-81cm-ftv-32sh1300-android-hd/ and /televizori-lg-50-126cm-50ut81009lb-adkg-4k-uhd/."
I've just checked this product: hidden link. Please see the attached screenshot, tv-franko-32-81cm-ftv-32sh1300-android-hd.jpg. Please explain to me what is not syncing, because I'm unsure if I'm seeing this problem.
You also wrote: "Another very strange behavior is it creates double values in the translated language, along with the values from the original language:
/en/apple-iphone-16-pro-max-256gb-black-titanium-2/
this is all over the place, and it happens later, not immediately after uploading and only on global attributes."
I can see this problem when I visit the product page: hidden link. Also, when I edit the English product with the WordPress editor, I can see that it is doubled. Please see the attached screenshot, doubled-attributes.jpg.
Additionally, you wrote: "I have been using the troubleshooting options recommended by the WPML support team, but it desyncs the existing translations."
Can you please tell me which troubleshooting options you have been using?
Have you tried the WooCommerce Multilingual & Multicurrency troubleshooting section here? hidden link
Please also try the WPML's general troubleshooting section.
1. Take a backup of the DB of your site.
2. Go to WPML -> Support -> Troubleshooting (link)
3. Once on the troubleshooting screen, press the following buttons and check if it helps. Press each button at a time and wait for the process to complete.
- 'Synchronize posts taxonomies' for 'Products'
- 'Clear the cache in WPML'
- 'Remove ghost entries from the translation tables'
- 'Fix element_type collation'
- 'Fix WPML tables collation'
- 'Set language information'
- 'Fix terms count'
- 'Fix post type assignment for translations'
- 'Cleanup and optimize string tables'
- 'Clear invalid strings'
*** Please make a backup of your database before using this.***
You also had doubts about whether your theme is compatible. I see something weird about your theme. Is it the Woodmart theme or the Metromart theme? Please see the video I recorded.
The desynchronization has solved by itself without any actions from my side, but it took a day. To reproduce it, please change a single global attribute in any product in main language, then check the translation.
Regarding the double attributes, first when you import a translation with Webtoffee, everything is fine, the attributes are not doubled. A while later (several hours) doubling start to appear. Does it have something to do with WPML>Settings>Post Types Translation>"Translatable
use translation if available or fallback to default language" option?
Regarding troubleshooting. No, I haven't tried the one in Woocommerce, thank you for the hint. It looks like something I need, I will try it out. I indeed used the general troubleshooting in WMPL>Support: the previous recommendation from WPML's team is attached. There is no visible option to "'Clear invalid strings'" in there. There is only "Check for string issues" in the bottom of the troubleshooting page, and it opens a huge list of "unused or wrong translation data" which is not true. It is acutaly used strings, because I tried deleting them all and many translated strings were gone, and almost instantly got regenerated for further translation. You basically can's go lower than 1k strings there, they are being re-populated faster than you will manage to delete them.
The theme is Woodmart. It lets you white label it and call the child theme whatever you want. No custom modification is done, the option to rename is built-in (theme settings>white label).
I will try out the Woocommerce troubleshooting and get back to you with additional info.
