This thread is resolved. Here is a description of the problem and solution.
Problem: You are trying to translate over 300 products from English to Spanish using WPML, but only a few products are displayed in the translation management dashboard. Solution: The issue might be due to some database corruption. We recommend making a full backup of your database first. After securing your data, you can try to resolve the issue by running the following SQL command in phpMyAdmin or using WP-CLI:
Remember to replace 'wp_' with your actual database prefix if itβs not 'wp_'.
If this solution does not apply to your case, or if it seems outdated, 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 the issue persists, please open a new support ticket.
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 translate more than 300 products from English to Spanish using WPML. I accessed the translation management dashboard at hidden link to find all the products for translation.
Symptoms:
I expected to see all 300 products available for translation, but only a few products are shown.
Questions:
Why are not all products appearing for translation in the WPML dashboard?
How can I ensure all products are available for translation?
I would like to request temporary access (wp-admin and FTP) to your site to take better look at the issue. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.
Our Debugging Procedures
I will be checking various settings in the backend to see if the issue can be resolved. Although I won't be making changes that affect the live site, it is still good practice to backup the site before providing us access. In the event that we do need to debug the site further, I will duplicate the site and work in a separate, local development environment to avoid affecting the live site.
- Please make a backup of site files and database before providing us access.
- If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link
I'd like to test a few things on your site. Is this a staging site where I can deactivate non WPML plugins and switch to a default theme? Also, please confirm if there is a full backup of the site, as I'd also like to run the steps in WPML -> Support -> Troubleshooting -> Clean Up section. Let me know if it's okay to test these steps on the site you have provided access for. Thanks!
Thanks for allowing me to disable plugins. I'm able to get to page 5 now on some of the languages (English and French). When I search by Source Language, I can see over 100 in French, over 100 in English and 75 in Italian. So it looks like the products were created in different source languages, and then translated. In other words, it appears English is not the source language for all products (source means original in this case).
To confirm this, I'd like to access the database and that way I can check the products and sort to see how many source languages are showing there. Is it okay if I install the Adminer plugin to check this?
I am escalating this ticket to our 2nd tier support for further troubleshooting. In the meantime, I did find that if you search for a product that doesn't show up in the first few pages, it does appear in the translation management dashboard. I know that is not a solution, but hopefully until we find a permanent solution, this can help if there are any priority translations you need to do. I'll update here as soon as I have more information.
I have not been able to reproduce this issue in a clean install. I also installed the File Management plugin to test increasing max input vars, but I'm not able to use File Management to edit files (seems like a server restriction). Can you please test increasing max input vars? There are some suggestions on how to do it below. THen, please go to WPML -> Support to confirm that it has been increased more than 1000. If it has not been increased, please ask your hosting provider to increase it for you.
Install and activate a plugin like WP File Manager
Navigate to:
wp-content > themes > your-active-theme-folder
Edit the functions.php file.
Add this code at the bottom:
@ini_set('max_input_vars', '5000');
Save the file and clear any caches (plugin cache, server cache, Cloudflare, etc.).
I have found that some products not aren't in the initial list appear when I search for them.
For example, "STAINLESS STEEL PROTECTIVE GRILLE" is NOT listed, but if I search for it, it shows up.
Could you ask the technical department where I can find the server-side query called by the dashboard via AJAX?
I am a technician, so I would like to understand if there is something wrong with SQL because of my data (unfortunately, I have already activated WP debugging, but it does not show anything).
Thanks for the additional screenshots and increasing max input vars. I've escalate this to our 2nd tier support to take a look and will update here as soon as I have more information.
