Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
9:00 – 15:00 9:00 – 15:00 9:00 – 15:00 9:00 – 15:00 9:00 – 15:00 - -
- - - - - - -

Supporter timezone: Asia/Yerevan (GMT+04:00)

This topic contains 1 reply, has 2 voices.

Last updated by Christopher Amirian 4 days, 22 hours ago.

Assisted by: Christopher Amirian.

Author Posts
November 8, 2024 at 8:44 am #16381012

tomasB-12

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?

November 8, 2024 at 9:08 am #16381174

Christopher Amirian
Supporter

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi,

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.

Thanks