Thanks for your reply. I'm working on the backup site you shared with me hidden link . I do have some feedback from our 2nd Tier Support and I'm checking on this further.
Our 2nd Tier Support mentioned that "product_visibility" should not be translated and could be causing the issue with the missing products on the "Selected Products" or "Featured Products" section.
They also suggested that we remove the "product_visibility" translations from the icl_translations table. Are you able to provide access to the server database (PHPMyadmin)? Or could you backup and try to remove these translations from the icl_translations database table?
I repeat:
1. there have been no problem at all until now.
2. We have not changed the way we translate the products for very long time
3. Problem arose immediately after running the routine recommended from WPML support earlier described.
Please base your solution on that info - looking forward to positive news from you.
These steps were provided by our 2nd Tier Support team. May I have your permission to install the PHPMyAdmin plugin on your website? I need access to the database in order to follow the instructions they’ve given. If the issue continues, I will request further assistance from them.
Thank you for your response. However, FTP and database access are different. Would it be possible for you to obtain the credentials from your hosting provider? I specifically need access to the PHPmyAdmin for your WordPress installation.
In the meantime, I'll review the database using the website copy I’ve downloaded from your site.
Thanks for your patience. Our 2nd Tier Support shared some methods to fix this and I've applied it to your staging site here hidden link . Now the "Selected Product" section shows the products now.
This is what I've done. (Please backup before you proceed)
1. Navigate to WPML > Settings > Taxonomies Translation > and set the taxonomy for "product_visibility" to "Don't translate"
2. Ran this SQL and remove all translated product_visibility
SELECT * FROM `wp_icl_translations` WHERE `element_type` LIKE '%tax_product_visibility%' AND `source_language_code` IS NOT NULL
3. That's it. Check the frontend and see if the product shows up.