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.

Our next available supporter will start replying to tickets in about 0.18 hours from now. Thank you for your understanding.

This topic contains 5 replies, has 2 voices.

Last updated by Yvette 2 months, 3 weeks ago.

Assigned support staff: Yvette.

Author Posts
May 20, 2022 at 9:36 am #11264217


My products were created by second Language.
so, the product name, and price can't not change in main Language.
how to move them to main Language.

May 20, 2022 at 11:07 am #11265055


Languages: English (English ) Spanish (Español )

Timezone: Europe/Paris (GMT+02:00)


I understand that you have all of your products in the 2nd language of your site and you need them to be in the default language.

Is this correct?

1. Have you translated any of these products?

2. How many products do you have in this state?

3. Are there other products in the site that are correct? e.g. there is a subset of all products that have this issue

May 20, 2022 at 11:42 am #11265379


1.I translated all products from 2nd(Chinese) to default(Eng) Language.
2.almost all
3.all products in same situation.
hidden link

May 20, 2022 at 12:04 pm #11265723


Languages: English (English ) Spanish (Español )

Timezone: Europe/Paris (GMT+02:00)

How many is "almost all"?

You may need to do a database manipulation/query. Are you comfortable doing this?

May 20, 2022 at 1:52 pm #11267065


I know a little, please tell me how to do.
How many is "almost all"?--> all

May 20, 2022 at 5:43 pm #11268489


Languages: English (English ) Spanish (Español )

Timezone: Europe/Paris (GMT+02:00)

Well since you will not give me the exact number, I am going to assume that it is >100 products.

Here is what I would suggest:

1. Take a database copy that you are comfortable to replace.

2. With a database tool like PHPmyAdmin or Adminer plugin, select all entries in icl_translations table of element_type = post_product

This will give you a list of all translated products.

3, Sort this selection by "trid" field. These will group the various entries into translation pairs.

4. You will see that one of the entries has the "NULL" value as the source langauge value. This indicates the default language of the pair.

Essentially you will need to change the NULL value to the other entry and replace the original "NULL" entry value with the language code of the other entry. (see image).

In this way, you will have switched the language of the product in bulk.

Select_ wp_icl_translations - Adminer.png

The topic ‘[Closed] Change Product Language’ is closed to new replies.