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.

Elementor users - please update WPML to the latest version to maintain compatibility. More details here - https://wpml.org/changelog/2024/12/wpml-4-6-15-critical-update-for-elementor-sites/
Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 -
- 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 -

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

This topic contains 11 replies, has 2 voices.

Last updated by Long Nguyen 1 week, 6 days ago.

Assisted by: Long Nguyen.

Author Posts
November 14, 2024 at 2:04 pm #16403044

piaP-6

Background of the issue:
I am trying to display the title of upsell products correctly on my Danish site.
hidden link

Symptoms:
The title of the upsell products is appearing in German on the Danish product.

Questions:
How can I change the language of the upsell product titles to Danish?

November 18, 2024 at 7:05 am #16412976

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi Peter,

Thank you for contacting WPML support, I’m happy to help you with this issue.

I can see the product title "Blockkerze LILA mit Rillen, 6,8 x 10 cm" is in German language and displayed in the Upsell products section in Danish language.
I suggest you follow some steps below and see if it helps:
- Edit the product in the original language
- Make a small change to the product description > Save
- Update the translation product
- Clear the cache (Litespeed)

Looking forward to your reply.
Thanks

November 18, 2024 at 8:04 am #16413191

piaP-6

Hi Long

Unfortunately, that did not help.

In the backend on the original product, I see that the German products is added. How I that even possible?

Original language backend.PNG
November 18, 2024 at 8:34 am #16413308

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I would like to request temporary access (wp-admin and FTP) to your site so I can take a better look at the issue. It would be better to have a testing site where the issue is replicated. Your next reply is set to private to share the info.

❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/
✙ I would need your permission to de-activate and re-activate Plugins and the Theme to change configurations on the site if needed. This is also a reason the backup is critical.

Looking forward to your reply.
Thanks

November 18, 2024 at 8:45 am #16413383

piaP-6

I am not able to offer that. The site has 200 orders per day and we do not have a staging site because the site is 30 GB +

November 18, 2024 at 9:48 am #16413889

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

Can you remove the related product, re-select it and update the product in Danish language?

Also, please go to WPML > Support > Troubleshooting > Click on some buttons below and check if the issue is resolved.
- [Products] Synchronize posts taxonomies
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Set language information
- Fix terms count
- Fix post type assignment for translations
❌ IMPORTANT: Please backup your database and website before proceeding ❌

Looking forward to your reply.
Thanks

November 20, 2024 at 4:59 pm #16425823

piaP-6

Unfortunately, that did not help. I have run the troubleshooting options in WCML as well.

I have looked into the postmeta table of the database and the post ID's in the _upsell_ids field is simply referring to the German translation instead of the Danish. That's weird..

November 21, 2024 at 1:22 am #16426977

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

Did you edit the product in Danish language, re-select the upsell products and re-update the product? If it still doesn't work, what happens if you manually replace the product ID in the upsell post meta value with the product ID in the original language?

Looking forward to your reply.
Thanks

November 22, 2024 at 12:08 pm #16433696

piaP-6

Hi Long,

That will help indeed. However, that does not clear out the reason for the issue. Neither if the issue is occurring on others of the 3K+ products.

Best Regards,
Peter

November 25, 2024 at 1:24 am #16437706

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I understand your situation, however, I cannot replicate the issue on a clean installation of WordPress with some new products. Does this happen when you create new products?
If it is possible, I recommend you copy your site to a staging site and share the credentials or at least, share the database archive so I can investigate the issue on the site. Your next reply is set to private to share the info.

Looking forward to your reply.
Thanks

December 5, 2024 at 9:54 am #16480712

piaP-6

Hi Long,

I think I have narrowed down the issue. I think it is a compatibility issue with WP All Import.

I tried to import the csv below as a test. The ID's in first columns are only Norwegian ID's. The 4 products are updated with the SKU's in the second columns, and they are correctly translated into the Norwegian version of that product. However, the Danish translations get the exact same ID's set in the database even though they should be touched because they are not in the file and if there are touched, they should be set with the Danish translation of the upsell product - not the Norwegian one.

I think I can replicate the issue in a sandbox if you can offer such an enviroment.

id;upsell_sku
127055;21001494,24001741,24001652,23001867,24001742,23001865
124767;21001823,21001821
127058;23001941,21001858,24001751,24001750,24001647,24001741,21001850
126655;87419D

December 6, 2024 at 1:23 am #16484283

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

You can access the sandbox site with the following URL hidden link

I've installed all necessary plugins WP All Import Pro, WPAI WooCommerce Import, WPML plugins ... that you need to import products.
Please try to replicate the issue with a few products so we can narrow down the issue. Then share with me steps to replicate it (or a screen record of steps you do) and the file that you use to import.

Looking forward to your reply.
Thanks