Background of the issue:
I am trying to connect 45k WooCommerce products via WP All Import. I used the WPML Import Export plugin. I downloaded the SK (Slovak) products, added the wpmltranslationid column to the CS (Czech) products, and imported them. Now, I have 45k SK products and 45k CS products without connection. I am looking for a MySQL code solution to connect them without re-importing.
Symptoms:
The SK and CS products are not connected after import, and I want to avoid deleting and re-importing 90k products.
Questions:
Is there any code for MySQL DB to connect the translations?
Is there any possibility to reconnect the translations in the DB?
To detect what might be the problem causing the disconnect between the imported products in SK and CS languages, I'd appreciate it if you can create a smaller version of your exported CSV file with 10-100 products and record the process you take to do the import.
That will cause the time of the import be smaller and help us to see what might be the issue when it comes to the steps.
I'd appreciate that you reply back with the recording of the steps you take.
I will try to detect what might be the problem cause.