This thread is resolved. Here is a description of the problem and solution.
Problem: After installing WPML and WooCommerce Multilingual, all variable products changed to grouped products and lost their prices and variations. Solution: 1. Remove all entries in
icl_translations
where the type is
tax_product_type
using the SQL query:
DELETE FROM `m7ug_icl_translations` WHERE `element_type` = 'tax_product_type';
2. Update WPML to the latest version. 3. Complete the WPML setup. 4. Run the troubleshooting function from WPML by navigating to WPML>Support> Troubleshooting > Set language information. 5. Update the product only if necessary.
If the issue persists or if this solution becomes outdated, we recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If needed, please open a new support ticket at WPML support forum for further assistance.
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.
Background of the issue:
I am trying to install WPML on my WordPress page with WooCommerce. I'm also installing the WooCommerce Multilingual plugin. After doing the setup, I noticed an issue. Here is a link to a page where the issue can be seen: hidden link
I have tried the "fix product_type taxonomy terms"
This site usually isn't supposed to have any grouped products and all variable products had prices before. I have a backup of before installing WPML.
Symptoms:
After installing WPML, all products that were once variable products have changed to grouped products and lost their prices and variations. I expected to see a WPML installation with variable products remaining on the original language, but instead, I got a WPML installation with broken products.
Questions:
Why are my variable products changing to grouped products after installing WPML?
How can I fix the issue of products losing their prices and variations?
Reference to our recent chat, I tried several options and as soon as I try that fix taxonomy option in WCML troubleshooting, variable products turn into Grouped ones.
Before that, variable products also not showing variations, despite there's a count shown in variations section (about the available variations).
Meanwhile one of my colleagues takes up this ticket, please restore the site to the previous backup (with only WPML, ST, WC and WCML and before setting up WPML). And also let us know about this particular backup (from those updraft backups).
Please do not share any sensitive information like site access and sitekey. Ask to enable private form to share such information.
I've restored the backup and made a new one (May 29, 2025 12:24). For some reason I can't name it, so we'll have to rely on the date. You can use this backup also for testing and stuff, you can restore it etc. This site is only for dev and the original is on another production server.
this a fix for your issue that I have applied to your staging site:
Remove ALL entries in icl_translations where the type is tax_product_type, run next SQL query
DELETE FROM `m7ug_icl_translations`
WHERE `element_type` = 'tax_product_type';
So these are the steps:
- Remove the entries as mentioned above
- Run the update to latest WPML.
- Complete the setup
- Run troubleshooting function from WPML to set language information
- Update the product only if necessary.
IF the tax_product_type is not in the list when you run SQL query, try to run all the steps, but don't update the product and before updating the product - it should be there and you should be able to remove it.
I guess that resolved the product type issue, but the variations are still being hidden, as seen in the screenshot I attached.
In this product: hidden link
Hello, that did fix it.
My issue is now resolved, but can you still write here, why did I have to delete the element types from icl_translations table?
