My product variations aren't being copied to or updated in my translations. I've tried alot of suggestions from the support forum but nothing seems to help. Can you help?
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ā.
Thank you for contacting WPML support, Iām happy to help you with this issue.
I've tried to replicate the issue on my demo site and don't see that issue. The attribute is set to Not Translatable but the variations are still available on the translation product page.
On your site, I suggest you follow steps below and see how it goes:
1. Enable a minimal environment:
- Deactivate all plugins except WPML plugins and WooCommerce.
- Switch to a standard theme of WordPress.
2. Run troubleshooting buttons as my colleague suggested:
- Troubleshooting options from WPML > Support page.
- Sync troubleshooting options WCML > Settings > Troubleshooting page.
ā IMPORTANT: Please backup your database and website before proceeding ā
Looking forward to your reply.
Thanks
The topic ‘[Closed] Product variations aren't being copied to or updated in my translations’ is closed to new replies.