Skip Navigation

Home › Support › English Support › [Resolved] WP All Export Pro does not export language_code, source_language_code and translation_group

[Resolved] WP All Export Pro does not export language_code, source_language_code and translation_group

This thread is resolved. Here is a description of the problem and solution.

Problem:
You have a website with WPML and WooCommerce and need to export and import products and product categories.
Solution:
We recommend installing our addon plugin, WPML Export and Import. Once installed, the related WPML fields will appear when you try to export categories. For detailed guidance, please follow this documentation: Export Multilingual Websites Using WP All Export & WPML.

If this solution does not apply to your case, or if it seems outdated, we encourage you to open a new support ticket. We also 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. For further assistance, please visit our support forum at WPML Support Forum.

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.

Tagged: 

This topic contains 4 replies, has 2 voices.

Last updated by Dražen 7 months, 3 weeks ago.

Assisted by: Dražen.

Author Posts
July 22, 2024 at 5:26 pm #15988147

janK-52

Background of the issue:
I have a website with WPML and WooCommerce and want to export and import products and product categories with "WP All Export Pro" and "WP All Import Pro". The import file has to look like this: hidden link. Product Categories Spreadsheet: hidden link. Products Spreadsheet: hidden link.

Symptoms:
The export files DO NOT include the columns needed for the import: "_wpml_import_language_code", "wpml_import_source_language_code" and "wpml_import_translation_group".

Questions:
How can I add the columns "_wpml_import_language_code", "wpml_import_source_language_code" and "wpml_import_translation_group" to the export files?
July 23, 2024 at 6:33 am #15990497

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

if you are already using WPML on that website, and those products and categories where translated by WPML, then you should have those fields.

When you go to export files, in step 2 make sure to add WPML-related fields from the right side to the export template and then export it.

- hidden link

Regards,
Drazen
July 23, 2024 at 9:58 am #15991892

janK-52

"if you are already using WPML on that website, and those products and categories where translated by WPML, then you should have those fields."

There are no WPML-related fields.

Please enable the option to send you my login credentials.

Thanks,
Jan
July 23, 2024 at 11:23 am #15992209

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello Jan,

Please make a full backup of your site (files and database) and confirm it in your next reply.
If possible please provide access to the staging website, not production.

Please note, that I might need to do some debugging procedures like enable/disable plugins, switch themes, change the default language of the user account, and/or access your website database to debug the issue furtherly.

I will share with you any changes or steps done in this process. Please let me know if you do not agree with the above or if I do not have your permission for any.

I would need to access both your site's wp-admin and FTP account, if possible.

I have enabled the private username and password fields in your next reply.

I suggest you create a new user, set it as an administrator and then add those credentials in the private fields mentioned.

You can safely add your information into these fields.

Regards,
Drazen
July 23, 2024 at 11:52 am #15992293

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello Jan,

as per next guide https://wpml.org/documentation/plugins-compatibility/export-multilingual-websites-using-wp-all-export-wpml/

I have added our addon plugin WPML Export and Import, the related WPML field now show up when you try to export categories.

Regards,
Drazen

Screenshot_3.jpg
July 23, 2024 at 12:11 pm #15992359

janK-52

Hi Drazen,
I did not know that an additional plugin is needed to make it work.
Thank you very much for your quick help.
Have a great day!
Jan