[Resolved] Change the default language of products in bulk

Hi there,

Thanks for your contact!

There is no native way to bulk change product languages. The only way you can do bulk things in products is:

1) REST API :
hidden link

https://wpml.org/documentation/related-projects/woocommerce-multilingual/using-wordpress-rest-api-woocommerce-multilingual/#create-product-variation

2) WP All Import with WPML All import :
https://wpml.org/documentation/related-projects/wpml-all-import-plugin-website-import-with-wpml/

3) Here my colleague offered another option, which involves database manipulation: https://wpml.org/forums/topic/product-default-language/#post-9596035

I hope this helps. Please let us know if you need any further assistance.

Regards,
Mateus.

Hi there,

Thanks for your reply.

Answering your questions:

- there are other "element_types" to change
If you intend to change only the products language - no, it should be the ones already in your query.

- is it the "source_language_code" variable that I need to modify?
That's right, it holds the post language information. Please be very cautious and only do this after ensuring to have a backup.

DISCLAIMER:

Note: the possible solution provided is to be used just as an informational one. Please remember that custom coding is out of the scope of our support, so we can't create, debug or modify code for you and it's your responsibility to maintain it. We hope the one we used as an example could point you in the right direction. Please check our support policy:

- https://wpml.org/purchase/support-policy/

Thanks for your understanding. If you need anything else don't hesitate to contact us.

Hi there,

Thanks for your reply.

Although this feature seems to be a simple function, its implementation might not be that easy.

In order to not compromise the original website, please consider to test it first in a staging or local version.

Thanks,
Mateus.

Hi there,

Thanks for your reply.

Please apologize me, you asked about the 'source_language_code', and somehow I've read it as 'language_code' - which is the right column here.

Therefore, instead of 'source_language_code', try to change the 'language_code' value. If you get a 'trid' duplicated message, make sure to delete the German translation of the post (this error message only appears if the post already has a translation).

Another possibility, if you want to avoid meddle with the database, is to bulk duplicate the 'Italian' products to German, as explained here: https://wpml.org/forums/topic/i-want-to-change-all-content-to-another-standard-language/#post-14199925

Please check the info above and let me know if you still have doubts. Thank you.

Hi there,

Thanks for your reply.

I'm not sure if I fully understood this:

it is wrong to edit language_code. This is because the texts inserted in a specific language code are of the indicated language.

if I change language_code from IT to DE for example I will have a German product sheet with Italian language

Could you please give an example of this behavior? For instance, I have made some tests in a Sandbox. Three Italian products were created, and their language could be changed without problems to German through SQL commands.

I've recorded a video showing how to change it back to Italian, and at last, I modified to German again. Please check it out: hidden link

If you want to access the Sandbox and make your own tests, just do it through the automatic login link that I'll provide in my next private reply.

When possible, please take a time to read our doc related to the icl_tables: https://wpml.org/documentation/support/wpml-tables/

Furthermore, I have to emphasize that custom code solutions are out of the scope of this support forum. We can guide you through some examples, but not create the code customized for you. Please consider consulting one of our partners: https://wpml.org/contractors/

Thanks for your understanding.