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.

Sun Mon Tue Wed Thu Fri Sat
- - 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00
- - - - - - -

Supporter timezone: America/Lima (GMT-05:00)

This topic contains 1 reply, has 2 voices.

Last updated by Andreas W. 1 year, 3 months ago.

Assisted by: Andreas W..

Author Posts
March 8, 2024 at 1:02 pm #15389338

jariA-3

I'm trying to have my variations synchronized across all languages, but whatever I do I can't seem to get it to work. I'm beyond frustrated since I've spent about 25 hours on this already, I need this to be fixed as soon as possible!! please help me figure this out.

This is what I've found so far:

So, in woocommerce using WPML some of the translated product variations lose their connection to the attribute term it was connected to in the original language. I did a thorough examination of the database hoping to find out what records are missing, but I can't seem to find anything and have the idea there might be a record connection the variation id to the attribute term which I haven't found yet. I have to find out what could cause variation swatches to be missing on translated product pages, and why some of the translated product variations are missing their link to the original attribute term even though it seems available in the frontend form data and all seems to be present in the database. Here are two data sets of my findings:

variation ID: 60359 attribute term: Anthracite - variation IS linked and term is present on attribute used for variations on product page backend

wp_postmeta “kleur_anthracite-1” via “attribute_pa_kleur” linked to post_id 60359 and meta_id 1992940
wp_terms slug: kleur_anthracite-1 with name: “Anthracite” and term id 1138
wp_term_relationships term_id 1138 is linked to parent product id 60227 in object_id
wp_term_relationships term_id 1138 is linked to variation id 60359 in object_id
wp_wc_product_attributes_lookup term _id 1138 is linked to taxonomy pa_kleur product_or_parent_id 60227 and product_id 60359. is_variation_attribute 1. In stock 1
wp_termmeta term_id 1138 is linked to meta_id 1359 and meta key “order” and meta_value 0
wp_term_taxonomy term_id 1138 is linked to taxonomy pa_kleur, term_taxonomy_id 1138 count 216 parent 0

Variation ID: 60364 term: Black - variation not linked but term is present on attribute used for variations on product page backend

wp_postmeta “kleur_black” via “attribute_pa_kleur” linked to post_id 60354 and meta_id 1993120
wp_terms slug: kleur_black with name: “Black” and term id 73
wp_term_relationships term_id 73 is linked to parent product id 60227 in object_id
wp_term_relationships term_id 73 is linked to variation id 60364 in object_id
wp_wc_product_attributes_lookup term _id 73 is linked to taxonomy pa_kleur product_or_parent_id 60227 and product_id 60364. is_variation_attribute 1. In stock 1
wp_termmeta term_id 73 is linked to meta_id 103 and meta key “order” and meta_value 0
wp_term_taxonomy term_id 73 is linked to taxonomy pa_kleur, term_taxonomy_id 73 count 198 parent 0

Also I compared other values from the translated product variations, these are my findings:

V _product_attributes are the same
V _colorevariables are the same ( foor WooSwatches plugin )
V Term “Black” = Term ID 73, linked to NL product id 35190 and FR product id 60227 in wp_wc_product_attributes_lookup
V Form variations_form cart shows 26 variations in both languages, which are all of them
V All attribute trems are present under Attribute used for variations in backend of french translation of the product
V All WooSwatches are present and filled accordingly in the backend of french product
V In the wp_postmeta table is post_id 60364 attribute_pa_kleur: kleur_black. meta id: 1993120

X. The product page for the french translation ( id 60227 ) is only showing 23 swatches, also only 23 generated, so none are printed and hidden.
X 3 of the variations in the backend of the french translation of the product are showing “choose attribute..” while they do have their metadata such as Image, price and SKU
X In WCML troubleShooting clicking the “sync translated variant relations 19448 remaining” shows it counting down but when done and I refresh the number returns as if nothing happend, same goes for other WCML troubleshoot options.
X In WPML I have set “Copy” for all product attributes that are used for variations, But on the product backend page it shows those attribute fields with the option “translate” and “do not translate” instead of copy
X I would like to know if settings those to translate if they will be “translated” using the general WPML setting “Copy”.

March 8, 2024 at 1:45 pm #15389559

Andreas W.
WPML Supporter since 12/2018

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

Timezone: America/Lima (GMT-05:00)

Hello,

Do you see any config issue when visiting WooCommerce > WooCommerce Multilingual & Multi-Currency > Status?

Please send me a screenshot of the screen.

Best regards
Andreas

The topic ‘[Closed] I need help symchronizing product variations’ is closed to new replies.