Missing Attributes in Woodmart (again)

This thread is resolved. Here is a description of the problem and solution.

Problem:
The Woodmart widget "Woodmart WooCommerce Layered Navigation" is used to filter products by attributes on the frontend. It does not count the number of products correctly in the second language.
Solution:
Go to WooCommerce > Settings > Products tab > Advanced > Disable option "Enable table usage".
Relevant Documentation:
https://wpml.org/errata/woocommerce-6-3-the-new-product-attributes-lookup-table-is-not-populated-for-products-in-secondary-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.

Tagged: Exception

This topic contains 10 replies, has 2 voices.

Last updated by waldemarK 1 year, 10 months ago.

Assisted by: Long Nguyen.

Author	Posts
June 20, 2023 at 9:06 am #13857417
waldemarK	Same problem as here: https://wpml.org/forums/topic/missing-attributes-in-woodmart/ Do not remember how we resolved this, see screenshot, the Filter Magnet Clasps and Magnetschließe should be exact the same, like Material Color and Materalfarbe I have cancelled cache, reset woocommerce WooCommerce-Transienten, Abgelaufene Transients and Produkt Nachschlagetabelle hidden link
June 21, 2023 at 6:41 am #13864273
Long Nguyen WPML Supporter since 02/2022 Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi there, Thank you for contacting WPML support, I'd be happy to help you with this issue. Please try to follow some troubleshooting steps below and see if it helps: 1. Enable a minimal environment: - Disable all plugins except WPML plugins, WooCommerce and Woodmart Core - Switch to the main theme 2. Go to WooCommerce > WooCommerce Multilingual & Multicurrency > Settings > Troubleshooting > Sync variations. ❌ IMPORTANT: Please backup your database and website before proceeding ❌ You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/ Look forward to your reply. Thanks
June 21, 2023 at 9:22 am #13865929
waldemarK	Hi Long, unfortunately this does not work – if I switch to main theme there are no side widgets and I cannot see the magnet clisps filter – there is no 'troubleshooting' inside the WooCommerce Multilingual & Multi-Currency settings, I 've found sth simiar in 'attributes' I choose magnetic clasp and have clicked on regernate this did not work, I have also regenerated transietns and product tables, no change
June 21, 2023 at 9:41 am #13866175
Long Nguyen WPML Supporter since 02/2022 Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi, I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to a testing site where the issue is replicated. Your next reply is set to private to share the info. ❌ IMPORTANT: Please backup your database and website before proceeding ❌ You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/ ✙ I would need your permission to de-activate and re-activate Plugins and the Theme and to change configurations on the site if needed. This is also a reason the backup is critical. Look forward to your reply. Thanks
June 21, 2023 at 6:55 pm #13871279
waldemarK	Hi, we need to go on with the website content, when have you finished your work?
June 22, 2023 at 2:04 am #13872359
Long Nguyen WPML Supporter since 02/2022 Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi, I've tried some troubleshooting steps but the filter products by attribute "magnetic clasp" does not count the correct number of products. I would like to have permission to download your backup file and restore it on my local site to investigate the issue further. I will delete it after the issue resolved. Thanks.
June 22, 2023 at 5:40 am #13872627
waldemarK	yes please do so. So we can go on with the content. We are starting a promotion next days. so it's very important that the counters and filter are working for new clients thank you Waldemar
June 22, 2023 at 9:20 am #13874945
Long Nguyen WPML Supporter since 02/2022 Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi, I've fixed the issue on your site by going to WooCommerce > Settings > Products tab > Advanced > Disable option "Enable table usage". Can you please confirm it works properly? Look forward to your reply. Thanks
June 22, 2023 at 11:53 am #13876219
waldemarK	Hi Long, yes it works! This option is really hidden in the settings and makes no real logic to disable it for the 2nd language. Waldemar
June 23, 2023 at 1:30 am #13881413
Long Nguyen WPML Supporter since 02/2022 Languages: English (English ) Timezone: Asia/Ho_Chi_Minh (GMT+07:00)	Hi, You may consider this thread resolved and feel free to open new tickets if you have any questions. Regards.