Skip to content Skip to sidebar

Home › Support › English Support › [Closed] Connection database between different languages

[Closed] Connection database between different languages

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
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 -
- 20:00 – 23:00 20:00 – 23:00 20:00 – 23:00 20:00 – 23:00 20:00 – 23:00 -

Supporter timezone: Asia/Singapore (GMT+08:00)

This topic contains 5 replies, has 0 voices.

Last updated by Kor 5 months ago.

Assisted by: Kor.

Author Posts
October 30, 2025 at 2:15 pm #17533036

ingeB

Background of the issue:
We are building a new website similar to our current one due to issues with updating some plugins. The website builder needs to understand the relationship in the database between different language versions of a post and a WooCommerce product.

Symptoms:
No specific issue or error message mentioned.

Questions:
How can I retrieve the link between posts in different languages when looking them up in the database?
October 30, 2025 at 2:42 pm #17533211

Kor

Thanks for your patience. Here is the ticket and please let me know how it goes.

October 30, 2025 at 2:58 pm #17533234

ingeB

Hi, I would like to know how I can match the 3 post for 1 product from WooCommerce for the 3 languages. So which field / ID etc. to look for in which table 🙂
October 30, 2025 at 3:20 pm #17533289

Kor

Thanks for getting back to me. I’m not entirely sure I understand what you're trying to achieve. You can review the WPML database structure here: https://wpml.org/documentation/support/wpml-tables it explains how the tables are organized.

However, I'm not clear on what you mean by “connecting posts to a product” and how that relates to this setup. Could you please clarify?
November 2, 2025 at 11:33 am #17538117

ingeB

Hi, what I'm working on now is to convert products to a new shop.
This shop is a bit different when it comes to languages. There is 1 product with 3 languages.
In WooCommerce/WPML there are 3 posts (products?).
What I'm now doing is see if, with the tips you gave me, I can figure out how to get this data in a way so it can be imported without too much manual work.
Slowly getting things done.
Hope to get it ready this week. Will close the ticket when I'm confident enough to finish it.

Thanks for the tips.
November 3, 2025 at 9:21 am #17539938

Kor

Thanks for your reply.

Got it, I understand now. Please follow the steps below to achieve what you need:

1. Prepare a separate CSV file for each language

2. Import each language file

3. Run the WPML Export and Import process

For more details, you can refer to this guide:
https://wpml.org/documentation/related-projects/wpml-export-and-import/#import-multilingual-content

The topic ‘[Closed] Connection database between different languages’ is closed to new replies.