This thread is resolved. Here is a description of the problem and solution.
Problem: The client reported that two categories were missing in the Croatian version of their shop sidebar, even though everything was translated correctly. After inserting specific categories manually, they appeared but were not expandable like in the original version. Solution: We identified that the issue was due to missing term meta keys for the order in the database. We recommended running the following SQL commands to add the missing term meta:
INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)<br />VALUES ('832', 'order', '1');
We also advised clearing transients from WooCommerce tools after running these commands. It is crucial to create a backup before performing any database modifications.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, we highly 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 further assistance is needed, please open a new support ticket at WPML support forum.
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 have my site showroom.si translated to Croatian language on a different domain, hidden link. In a shop sidebar, I have a category widget with product categories showing.
Symptoms:
On the SI language site, there are 17 categories, but there are only 15 categories in the HR version. 2 categories are missing even if all is translated ok.
Questions:
Why are 2 categories missing in the Croatian version of the shop sidebar?
How can I ensure all categories are displayed correctly in the translated version?
Hello!
It is possible that the translated products were not assigned to the translated category. If this was the case and if the product category has 0 entries, in most cases WooCommerce won't show the category in the list of the categories.
You have two options here.
Maybe the most painless one is to test if this is the case. Try creating a sample product in the second language in the missing category and see if the product is displayed.
Then maybe go to WPML > Taxonomy Translation and select the product category and check if it need hierarchy synchronization - which should fix some issues.
If this is not working then I would suggest that you try and first backup your site, then go to WPML > Support > Troubleshooting and there use the troubleshooting option to syncrhonize the product custom post type taxonomies.
You have to select from the dropdown there "Products" and use the button "Synchronize posts taxonomies"
As this is a troubleshooting option, it is a must to create a backup as if you have a corruption in the database, it might get amplified further and you might have to restore from that backup.
thanks but I see this is production website, I can not do debugging on live website it is not safe.
Please create staging site and share access to it, so I can check, or if not possible you can share a copy of your website. Make sure to exclude large files / images:
Thank you for your concern. The site is 15gb in size, and my hosting account is 20gb, so I can't duplicate it. I authorise you to do debugging on live website, just enable back al plugins when you are done. In worst case scenario, we can always restore from backup.
1) Thanks, I have checked but I can not disable plugins / themes, I do not have FTP so it would not be safe, as there is no way to recover if anything goes wrong.
I have also noticed you are using older version of WC, would be good to update.
Also, if you set category order in widget per name it works fine, so seems something is wrong with Category order.
- hidden link
2) I can continue, but I would need FTP and permission to take a copy if needed to debug further, but since you do not have much free space that could be an issue. In the end we would either way need to take a copy, if I was not able to solve it by disabling plugins / themes or you can use a fix workaround suggested above
