This thread is resolved. Here is a description of the problem and solution.
Problem: The client is experiencing issues with updating custom fields on products using WPML during a large import process. The import stops after updating some products, with an error indicating a type mismatch in WooCommerce Multilingual plugin. Solution: We recommend trying the solution provided in the WPML forum: WPML forum thread. If the issue persists, we suggest migrating the site to a test server for further debugging without risking the live site. You can use the Cloudways WordPress Migrator plugin for this purpose. More details on migration can be found here: How to migrate WordPress to Cloudways.
If these steps do not resolve the issue, or if the solution seems outdated or irrelevant to your specific case, please open a new support ticket. We highly recommend checking related known issues at WPML Known Issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. For further assistance, you can contact us directly through the 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 am trying to update some custom fields (availability_date, available_on_backorder) on existing products using WPML. Each product has its own ID for default and translated versions, so that should not be a problem. When importing a test xlsx file with one product, it works fine. However, when importing the final xlsx file with 13,000 products, it updated approximately 670 products, skipped 600, and then stopped. After several attempts to continue, the server stopped the import. I have a VPS with high parameters for script execution time. I have asked WP ALL IMPORT for support, but they directed me to you. Greška vrste E_ERROR je prouzročena u retku 860 datoteke /home/kulthome/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-product-data.php. Poruka greške: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array, bool given in /home/kulthome/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-product-data.php:860
Symptoms:
The import process stopped after updating approximately 670 products and skipping 600. An error occurred: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array, bool given in /home/kulthome/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-product-data.php:860.
Questions:
Is it WPML or WP ALL IMPORT or SERVER related?
Hi, syncing - "Sync product stock quantity and status" , "Fix translated variations relationships" and "Sync removed product meta from original products to translations"
is taking forever, witho no variaton products.
"Sync product stock quantity and status" - 8062 left
Sync removed product meta from original products to translations - 8062 left
Nothing is happening for over an hour. Any idea?
Thanks
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Madrid (GMT+01:00)
I would like to request temporary access (wp-admin and FTP) to your site to take a 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.
Please let me know where I can see the error.
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.
**IMPORTANT**
- Please make a backup of the 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
Hello, under all import / manage imports, you can try to run and continue All import Final_2000.xlsx or Final.xlsx imports. Ids 25 or 29.
Maybe they will run for some time, then sometimes server stoppes the import or error shows. Try to continue imports severeal times then error will show if it does not show the first time you run it.
Hello,
sorry, did not see the private message regarding the migration. I have initiated the migration but:
We are unable to complete the migration because your destination site allocated disk space has been exhausted.
Waiting for your reply and new steps. Thanks.
I have tried to create a copy of the site but the server throws a timeout error. I suspect this is the same error you received while running the import.
Please get in touch with your hosting providers and ask them to check the server limitations.
