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”.
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.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.