Problem: You need to export product attributes and their translations into a single table using SQL or the WP ALL EXPORT plugin, but currently, they export as separate rows. Solution: We tested the WP All Export Pro and WP All Export - WooCommerce Export Add-On Pro plugins and found that each translation has a separate Term ID, causing each term to start on a new line in the export file. To organize the data in a single table, you can add the custom fields _wpml_import_language_code and _wpml_import_translation_group. After adding these fields, sort your spreadsheet based on _wpml_import_translation_group to group the English term with its translations. Additionally, consider using AI to reorganize the spreadsheet if necessary, as it might be simpler than custom coding.
If this solution does not apply to your case, or if it seems outdated, 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 you still need assistance, please open a new support ticket at WPML support forum.
