Home›Support›English Support›[Waiting for user feedback] After resetting WPML and importing products using WooCommerce Import, all products appear in English...
[Waiting for user feedback] After resetting WPML and importing products using WooCommerce Import, all products appear in English...
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.
Background of the issue:
I am working on a site under development and have reset WPML. After resetting, I imported products using WooCommerce Import. The products were originally exported using WooCommerce Export before the reset.
Symptoms:
All products appear in English only, even those that were originally in Arabic before export. Translations are not linked to their original content, and WPML Export and Import does not process anything, staying at 0%.
Questions:
How can we reset product languages so WPML recognizes Arabic products correctly?
Is there a way to force WPML to recognize translated products and link them back to their originals?
Is there a way to restore the original language settings for each product without needing a new export?
After resetting WPML and importing products using WooCommerce Import, all products appear in English only, even those that were originally in Arabic before export. Additionally, translations are not linked to their original content, making manual linking the only available option.
Steps taken so far:
Products were exported using WooCommerce Export before resetting WPML.
After the reset, products were imported back using WooCommerce Import.
The products exist but are not linked to their original translations.
Running WPML Export and Import did not process any items and remained stuck at 0%.
The "Set languages and connect translations" option is not available in WPML Export and Import.
The following WPML troubleshooting tools were executed, but the issue persists:
Set language information
Fix post type assignment for translations
Assign translation status
Fix taxonomy terms
Current Problem:
All products appear in English only, even those that were originally in Arabic before export.
WPML no longer recognizes translated products as separate content in different languages.
WPML Export and Import does not process anything and stays at 0%.
WooCommerce Export did not retain original translation metadata (trid and post_parent), making WPML unable to recognize translations after import.
Support Request:
❓ How can we reset product languages so WPML recognizes Arabic products correctly?
❓ Is there a way to force WPML to recognize translated products and link them back to their originals?
❓ Is there a way to restore the original language settings for each product without needing a new export?
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
It looks like your export file was not created correctly. WPML and our add-ons need to be active on the site when creating the export. Before exporting you need to go to WPML > Export & Import and set up the export process.
It seems like this was not the case, as this export file is missing the columns related to WPML:
_wpml_import_translation_group:
Use this column for a unique value that associates the default language content with its translations. For e-commerce sites, use the product’s SKU. If there’s no SKU, use a Translation ID (trid).This is an ID number you create, which should be the same for each piece of content and its translations.
_wpml_import_language_code:
Indicate the language code for each item, for example en for English, es for Spanish). Refer to ISO standards for custom languages (e.g., “es-MX” for Mexican Spanish).
_wpml_import_source_language_code:
Use this column to specify the original language code of the content. This field is only necessary for translations and you can leave it empty for content in the source language.
Thank you for your response and for reviewing the export file.
Yes, we do have a backup from before resetting WPML, but it is from six days ago. Since then, we have manually linked most of the products and attributes. However, we are now facing issues such as:
Variable products lost their stock status after linking.
Prices and attributes disappeared for some products.
Given our current situation, what would you recommend as the best course of action?
Continue with the current manual linking process and provide us with solutions to restore missing prices, stock statuses, and attributes.
Restore the backup and properly create a new export file before re-importing it to avoid further issues.
Manually adjust the export file following your guide and re-import it with the missing columns (_wpml_import_translation_group, _wpml_import_language_code, _wpml_import_source_language_code) added.
We would appreciate your advice on which approach would be the most efficient and least disruptive.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
It is important to know how the product attributes were created.
Custom attributes are created directly on the product, while global attributes are created at Products > Attributes.
If you have already manually connected the products, then you can do the following:
1) Edit the original products, save them again, and then let then translate them with the WPML Translation Editor. This will make sure that any custom attributes, that were created directly on the original products, will be available on the translated products.
2) If you are using global attributes, that were created at Product > Attributes, then you need to translate and sync them at WPML > Taxonomy Translation.
