This thread is resolved. Here is a description of the problem and solution.
Problem: You are transitioning to handling development internally and want to assign each country domain its own language without duplicating the site. You also need to automate country-specific legal and currency adaptations across 600 pages. Solution: If you're experiencing issues with assigning different languages to each country domain without duplicating content, we recommend upgrading from the WPML All Import to the newer WPML Export and Import plugin. This newer version supports various import methods that can facilitate managing translations and content adaptations more efficiently.
Please note that this solution might be outdated or not applicable to your specific case. We highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket.
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 the owner of the site hidden link. We have transitioned from using an external developer to handling development internally. I am excited about the potential of WPML and aim to translate my large website into several languages. I own multiple country domains for GetYourLawyer and want each domain to have its own language.
Symptoms:
I do not see an easy way to assign each country domain its own language without duplicating the site. Additionally, I need to adapt content for country-specific legal and currency references, which is challenging to do manually across 600 pages.
Questions:
How can I assign each country domain its own language without duplicating the site?
Is there a way to automate country-specific legal and currency adaptations, possibly with an OpenAI integration or through MySQL?
The friendly chatbot already took care of the first part of my query, which was to use unique domains. The second part is why I escalated to human support, and it looks like this was lost in the AI summary.
So here it is again. My original website was targeted to Switzerland and it contains references to CHF, Swiss cities, the word Switzerland, Swiss legal references etc.
Now to deal with it manually I would create a sophisticated prompt and run it through the text of each page and then make corrections, but this is a lot of work for 600 pages.
I can also do search and replace in MySQL for the simpler things (e.g. change CHF to EUR, Francs to Euros, Zurich to Paris etc.)
I need some guidance on what the best approach is here. In my dreams you have some beta functionality where I can just prompt WPML to do this for me.
If that is not the case, which tables could I search/replace in MySQL to make these changes manually in the French translated version, and will it then stick?
I hope I explained myself correctly, but if not Im happy to elaborate.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: Europe/Vienna (GMT+02:00)
Hi Bastian,
Now to deal with it manually I would create a sophisticated prompt and run it through the text of each page and then make corrections, but this is a lot of work for 600 pages.
Posts handled by WPML are stored as duplicates of the original post and are linked through the "trid" field, which connects all translations of a given post. The language code is also stored in these tables.
Because your site uses the block editor, note that most block content is saved as HTML with JSON-encoded block attributes inside the post_content field — not in postmeta. However, some plugins or custom blocks may store related data in the wp_postmeta table, often as PHP-serialized values. Any automated database edits (for example, via AI or MySQL search-and-replace) that alter quotes, brackets, or serialized structures can easily break block syntax, cause layout issues, or even make the post content unreadable in the editor.
Critical caution: If you overwrite or corrupt these values, you’re not just breaking WPML, you can break your entire WordPress instance. In other words, you’d be overwriting postmeta WPML created for you; if that breaks, the site breaks, not only WPML.
Thanks Marcel. The export seems like a great solution. I have both WP Export and WP Import installed, but I can't see the WPML → Export and Import option anywhere in my interface.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: Europe/Vienna (GMT+02:00)
Thanks for the info. I would eventually also need to request temporary access (WP-Admin and FTP) to your site
– preferably to a test site where the problem has been replicated if possible –
in order to be of better help and check if some configurations might need to be changed
Your next answer will be private which means only you and I have access to it.
❌ Please backup your database and website ❌
✙ I would additionally need your permission to de-activate and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important.
✙ Please add the Links to the […] Edit Screen, the Page/Post where you insert the […] and the corresponding Front End Page/Screen
The new plugin supports several import methods, including native WordPress, native WooCommerce, and WP All Import. The “WPML All Import” plugin can be considered a legacy version.
