Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
You are using Elementor with the Astra Pro theme and have a WooCommerce shortcode on your homepage to display featured products. This shortcode works correctly in the main language but fails in the translated version. Disabling the 'WooCommerce Multilingual' plugin allows the shortcode to function, but then the product shop page does not display translated products.
Solution:
We found that the 'icl_sitepress_settings' key in your site's wp-options table was corrupted. Here are the steps to resolve the issue:
1. Open your database manager, such as PhpMyAdmin.
2. Navigate to the wp_options table.
3. Search for 'icl_sitepress_settings'.
4. Delete this key.
5. Go to your site's dashboard.
6. Click 'Configure WPML'.
7. Complete the setup.
8. Check the translated homepage.
Please ensure to backup your database before performing these steps.

If this solution does not resolve your issue or seems outdated, we recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem 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.

Tagged: 

This topic contains 14 replies, has 2 voices.

Last updated by Osama Mersal 3 months, 3 weeks ago.

Assisted by: Osama Mersal.

Author Posts
August 20, 2024 at 11:34 am #16086840

Sergo NADJARYAN

Background of the issue:
I'm using Elementor on my website with the Astra Pro theme. On the homepage, I've included a WooCommerce shortcode to display featured products. It works perfectly on the main language home page. However, when I switch to another language (in my case, the second language is English), the shortcode doesn't function properly. If I disable the 'WooCommerce Multilingual' plugin, the shortcode works, but the product shop page doesn't show translated products. Link to a page where the issue can be seen: hidden link

Symptoms:
The shortcode for displaying featured products does not function properly on the translated homepage. Disabling the 'WooCommerce Multilingual' plugin makes the shortcode work, but the product shop page doesn't show translated products.

Questions:
Why does the WooCommerce shortcode not function properly on the translated homepage?
How can I get the shortcode to work without disabling the 'WooCommerce Multilingual' plugin?
Why doesn't the product shop page show translated products when the 'WooCommerce Multilingual' plugin is disabled?

August 20, 2024 at 11:59 am #16086961

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for contacting WPML forums support. I'll be glad to help you today.

Please edit the translated home page using Elementor and check the shortcode while WooCommerce Multilingual is enabled.

If it's copied correctly, I would need to look closely at your site, so I would need to request temporary access (WP-Admin and FTP)
Preferably to a test site where the problem has been replicated.

Your answer will be private, meaning only you and I can access it.

❌ Please backup your database and website ❌

✙ I need your permission to deactivate and reactivate the plugins and themes and change site configurations. This is also why the backup is critical.

✙ I also need your permission to take a local copy of your site to debug the issue without affecting your live site.

Best regards,
Osama

August 20, 2024 at 12:26 pm #16087084

Sergo NADJARYAN

Thank you for support. Please ask me questions and I will give you all information about problem. I can't give you access to site without owner permission, Im sorry.

August 20, 2024 at 12:31 pm #16087098

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

1) Could you please share screenshots of the following?

1- The shortcode in Elementor
2- WooCommerce Multilingual settings and status tabs

2) Please go to Products-> All products, switch the language using the top admin bar, and make sure that the translated products are featured.

Best regards,
Osama

August 20, 2024 at 12:54 pm #16087142

Sergo NADJARYAN

Thank you. all images attached.

WooMulti-status.png
WooMulti-settings.png
shortcode-inElementor.png
all-products-feature.png
August 20, 2024 at 12:57 pm #16087215

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for the screenshots. The screenshot shows Georgian products; please check the English products as well.

If they are featured, I'm afraid I would need the access details.

If sharing the access details is not possible, please let me know if you can provide a copy of the site.

Best regards,
Osama

August 20, 2024 at 1:08 pm #16087304

Sergo NADJARYAN

I have fresh install on newyork.webfortest.online

There is same problem. How can I give you access to this test site?

August 20, 2024 at 1:11 pm #16087325

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Your answer will be private, meaning only you and I can access it.

If you don't see the form below, please don't add your credentials, as they will be publicly exposed٫ (hidden link)

Best regards,
Osama

August 20, 2024 at 1:17 pm #16087367

Sergo NADJARYAN

Can I give you site files and db via WeTransfer?

August 20, 2024 at 1:19 pm #16087369

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Sure, We usually recommend the free Plugin “Duplicator” for this porpoise.

If you already know how Duplicator works. (http://wordpress.org/plugins/duplicator/)

Please skip the following steps and send me the installer file and the zip package you downloaded.

★ Duplicator Instructions (hidden link)

Send me both files (you probably want to use DropBox, Google Drive, or similar services, as the snapshot file will be quite big)

I will enable your next answer to be private so you can securely provide me with the information.

Best regards,
Osama

August 20, 2024 at 2:07 pm #16087474

Sergo NADJARYAN

note: This is not Duplicator or other plugin package file. This is original public_html files and in ZIP archive DataBase included.

August 20, 2024 at 3:01 pm #16087565

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for the copy. I installed a local copy of your site and tried some workarounds, but I haven't had any luck.

So, I created a hidden link">sandbox site to replicate the issue there, but the shortcode worked correctly in hidden link">both languages.

After that, I compared the two sites and found that the "icl_sitepress_settings" key in the wp-options table on your site was corrupted, so I deleted it, which fixed the issue.

Kindly check the following steps:

1- Open your database manager, for example, PhpMyAdmin
2- Open the wp_options table
3- Search for "icl_sitepress_settings"
4- Delete this key
5- Go to your site's dashboard
6- Click Configure WPML
7- Finish the setup
8- Check the translated home page

❌ Please backup your database before performing the above steps ❌

Best regards,
Osama

August 20, 2024 at 3:26 pm #16087664

Sergo NADJARYAN

please show me screen please - because I can not find it in wp-options table

August 20, 2024 at 6:25 pm #16088089

Sergo NADJARYAN

I did what you recommended for me but it not works. Now I decide to delete wpml fully and reistal it again. Later I will inform you about results. thank you

August 21, 2024 at 8:18 am #16088992

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Sure, please take your time and let me know if you need further help.

Best regards,
Osama