Change Product Language

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 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	-
-	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	-

Supporter timezone: Europe/Paris (GMT+02:00)

This topic contains 5 replies, has 2 voices.

Last updated by Yvette 1 year, 11 months ago.

Assisted by: Yvette.

Author	Posts
May 20, 2022 at 9:36 am #11264217
Lucas	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
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello 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? Clarifications: 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
Lucas	correct 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
Yvette Supporter 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
Lucas	I know a little, please tell me how to do. How many is "almost all"?--> all
May 20, 2022 at 5:43 pm #11268489
Yvette Supporter 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.

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