Woocommerce Product Attributes not synced to translation

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

Problem:
You are trying to sync WooCommerce product attributes for translation, but the translations do not appear. This issue may be due to the length and usage of the Thai script, which is decoded into much longer texts.
Solution:
First, ensure you have a full backup of your website. Then, follow these steps:
1. Access your Database manager (via phpMyAdmin or a plugin like DB Adminer).
2. Open your database and locate the

wp_icl_translate

table (note: your table prefix might differ).
3. Modify the

field_type

length value to 1600.
4. Make a minor change to the original product in WordPress.
5. Update the translation.
If these steps seem too complex or if you're not confident in performing them, please contact us for further assistance.

Please note that this solution might be outdated or not applicable to your specific case. We highly 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, do not hesitate to open a new support ticket at WPML support forum.

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: Bug

This topic contains 6 replies, has 2 voices.

Last updated by Lucas Vidal de Andrade 1 year ago.

Assisted by: Lucas Vidal de Andrade.

Author	Posts
August 28, 2024 at 11:56 am
Viriya	Background of the issue: I am trying to sync WooCommerce product attributes for translation on my site hidden link. I have tried adding/removing attributes and saving/updating products, but the translations do not appear. Symptoms: The WooCommerce product attributes do not fully sync for translation. Questions: Why are the WooCommerce product attributes not syncing for translation? What steps should I follow to ensure WooCommerce product attributes are translated correctly?
August 28, 2024 at 1:44 pm #16115539
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hey there, I wasn't able to figure out a solution yet. I sent your ticket to our development team, so they can take a look at it as well. I'll get back to you as soon as I hear from them. Regards,
August 30, 2024 at 12:27 pm #16124729
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hey there, It seems that the issue was happening because of the length and the usage of the Thai script. That happen because Thai script is decoded into much longer texts. Example: ส่วนผสม becomes: wc_attribute_value:0:%e0%b8%aa%e0%b9%88%e0%b8%a7%e0%b8%99%e0%b8%9c%e0%b8%aa%e0%b8%a1 To fix that, please make a full website backup and follow these steps: 1. Go to your Database manager (you can do that via phpMyAdmin or install a plugin like DB Adminer): hidden link 2. Open your database; 3. Look for the wp_icl_translate table (the wp_ prefix might be different in your website) 4. Change the field_type length value to 1600; 5. Make a small change to the original product inside WP; 6. Update the translation; That should do it. If you find the instructions to alter the Database too complex or don't feel confident to do it, please let me know, so I can perform the steps for you.
September 2, 2024 at 8:02 am #16130344
Viriya	Thanks, I'll try and get back if this work out or not.
September 2, 2024 at 10:24 am #16131011
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Sure. Please let me know if you need assistance on any specific step.
September 4, 2024 at 11:58 am #16140240
Viriya	OKay, I tried and it fixed the issue. However since this is an alter to the table. Will this be a problem when I get an update on WPML plugin in the future?
September 4, 2024 at 5:03 pm #16142078
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hey there. No, you can update both WordPress and WPML that this value will stay the same within your website's database.
September 9, 2024 at 7:11 am #16154012
Viriya	Thanks for a great support!