[Resolved] Translated products are not connected. WPML Export and import
This thread is resolved. Here is a description of the problem and solution.
Problem:
I did the following test: I exported the default language products, took the first two, translated them, and imported them using the same import tools. Then run WPML Export and Import. After the import, the products are not connected.
How do we import correctly so that the products are linked together?
Solution:
The user reported how he solved the issue:
To solve the problem, I first had to import the products for the default language to update the meta field and then separately for the translation language.
I did the following test: I exported the default language products, took the first two, translated them and imported them with the same import tools.
Then run WPML Export and Import. Final attached - products are not connected
How to import correctly so that the products are linked together?
Test product: hidden link
However, please correct the following and check if it helps. The debug info you attached shows that your server WP Memory Limit is 40M. Our recommendations are to have the following as minimal requirements:
PHP 7 and above (this OK with your installation) with a WP Memory Limit of at least 128MB while 256MB is recommended.
MySQL 5.6 and above.
Please follow this link for detailed documentation:
Is it possible for you to change those to the minimum requirement?
You may need to contact your hosting provider for that. Meeting those baseline requirements is critical before debugging and sometimes solves issues you experience. The most important thing is to raise the WP Memory Limit. Please try to raise it before you contact your hosting company. You can do it from the wp-config.php file in your WordPress installation. Insert this code in that file:
Could you please perform that procedure and see if it helps?
If it does not help, please take a video of the export and import process you take. It will help us to spot if you are missing any steps. You can use a free online service like Loom - hidden link.
Also, the following may help. If only a few products are not connected, you can connect them by following this guide on how can I link already translated pages.
You didn't prepare the spreadsheet correctly. Watching the video, here is what I spotted:
In your spreadsheet, the must-have WPML Export and Import columns titles include the word "Мета". However, this is wrong. You should only have the following as titles.
_wpml_import_language_code
_wpml_import_source_language_code
_wpml_import_translation_group
In your spreadsheet the _wpml_import_translation_group is missing. The original products and their translations will not be connected without this column.
According to the video, you did not use the WP All Import Pro for this import. You used WooCommerce's internal import feature. Therefore, you can deactivate our bridge plugin, WPML All Import, and only use our newer WPML Export and Import plugin.
The problem is with the value of the _wpml_import_translation_group column. In your case, the value is not the same. It is 8114 and 8115. It should the same value and it should be unique for this translation group. Please see the attached screenshot. If you have SKU for this product you can use it.
Besides watching the video, please also read the guide.
There should be the same values here (_wpml_import_translation_group) if they were the same products for different translations, but these are the first two products from the export file for a second language version
"_wpml_import_translation_group – Use this column for a unique value that links the default language content with its translations"
Write what I can show so that you can really help me. I see we're stuck and your advice isn't getting us any closer
To solve the problem I had to first import the products for the default language to update the meta field, and then separately for the translation language
I'm glad that the issue is solved now!
Thanks for updating us on what solved the problem!
I'm sorry if you had to wait for my reply. It was my weekend (Friday and Saturday), and I was consulting our second-tier supporters about this issue. But your description of what solved the issue came first.