Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
- - 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00
- - - - - - -

Supporter timezone: America/Lima (GMT-05:00)

This topic contains 11 replies, has 2 voices.

Last updated by Andreas W. 8 months ago.

Assisted by: Andreas W..

Author Posts
April 9, 2024 at 8:23 pm #15501443

michaelG-25

I want to import the taxonomies "categories" in different languages.

I imported the categories via WP ALL Import first with the default language "german". And then following in "french" and "english". But the categories are not translated but imported separate in each language. When I run "WPML > export and import" its not matching or shown as a translation.

What do I have to change that I can import all the categories via separat CSV Files?

Bildschirmfoto 2024-04-09 um 22.22.38.png
Bildschirmfoto 2024-04-09 um 22.18.22.png
April 10, 2024 at 2:06 am #15501972

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

Usually, you would need to use one file per language and run one import per language using the WPML All Import options to set language relations.

The issue with this is, that there is a known issue that will lead to an import, but the categories will not be connected:
https://wpml.org/errata/wpml-all-import-product-categories-are-not-connected-after-import/

As you can see here, we recently have quite many known issues in regards to WP All Import when using our WPML All Import Plugin:
https://wpml.org/documentation/related-projects/wpml-all-import-plugin-website-import-with-wpml/#known-issues

This is why not long time ago we released WPML Export & Import, a new plugin that can be used with various import methods:

- Built-in WordPress export tool and the official WordPress Importer plugin

- WP All Export and WP All Export Pro

- WP All Import Pro

- WP Import Export Lite

- WooCommerce built-in product CSV Importer and Exporter

I would suggest you give this a try:
https://wpml.org/documentation/related-projects/wpml-export-and-import/

Best regards
Andreas

April 10, 2024 at 11:16 am #15504146

michaelG-25

Hello Andreas,

Thanks for your reply and support!

The way I m importing the WooCommerce Products was recommended by your support team.
My understanding was that's this is the only way to import multilingual WooCommerce products. This was the solution your support team told me is the right way.

1. Import default language "german" with WP All Import
2. Import second language "french" with WP All Import >> "Run WPML Import"
3. Import third language "english" with WP All Import >> "Run WPML Import"

I was told that you can not do this with Built-in WordPress export tool and the official WordPress Importer plugin. See also my other tickets regarding this problem:
https://wpml.org/forums/topic/wpml-export-and-import-file-for-woocommerce-product-translation/
https://wpml.org/forums/topic/the-product-gets-completely-overwritten-with-the-french-version/
https://wpml.org/forums/topic/wpml-export-import-unique-identifier-for-woocommerce/

I would love to do it with the built-in WordPress export tool and the official WordPress Importer plugin. Coz in our live shop, where we only use one language. I export and import products only over the built in WooCommerce product export and and import. That works perfectly!

So how should I now continue. My understanding is also that I somehow used "WPML Export & Import"
I can give you all the access for my live and staging site. I really need this page to work in french and english. Thank you for your support.

April 10, 2024 at 1:56 pm #15505282

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

My apologies for the misunderstanding.

I would like to offer to have a closer look at the problem and request temporary access (wp-admin) to your staging site to investigate this issue further.

You can find the required fields below the comment section when you log in to leave the next reply. The information you provide is private, which means only you and I can see and access it.

IMPORTANT
Please be sure to make a backup copy of the website and database before allowing us access.
If you can't see the wp-admin / FTP fields, your post and website credentials are set as PUBLIC. DO NOT publish the data unless you see the required wp-admin / FTP fields.

The private response form looks like this:
hidden link

Next time you reply, click "I still need assistance."

Video:
hidden link

Please note that we are obliged to request this information individually on each ticket. We may not access any access information not specifically submitted on this ticket in the private response form.

Best regards
Andreas

April 11, 2024 at 3:20 pm #15510043

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

I see that all your categories have been imported as original content.

I would suggest, that before running import, you make sure to have the category base slug assigned to the correct source language and translated.

See screenshots.

I have fixed this now on your site.

Also, the product permalink base was not translated to English at WooCommerce > WooCommerce Multilingual & Multi-Currency > Shop URLs.

You should now remove the imported categories and create new imports.

If you still run into issues, then I need your exported files to review them and test them on a test site.

base.jpg
source.png
April 16, 2024 at 7:54 am #15523062

michaelG-25

Hi Andreas,

We made a completely new Dev-Site and installed everything from scretch.
We could successfully import the categories in DE and FR. Therefore we didn't use the WPML > Export & Import >> Run WPML. When we did Run the WPML the language mapping didnt work. Its really difficult to understand the logic behind WPML Export & Import. Why sometimes we need the WPML Export & Import and sometimes not???

Next problem:
Now we can import and match the categories but the subcategories are not imported.
How can we import the subcategories? We used the parentID as a parent category. Is this right?
Can you tell me how to import the subcategories for WooCommerce.
Also I would like to give you the new login data for the developer page.

April 16, 2024 at 5:50 pm #15527760

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

WPML Export & Import should be installed on both sites and you should use it for your Export and Imports by following this guide:
https://wpml.org/documentation/related-projects/wpml-export-and-import/

In this guide, we offer 5 different export and import methods. You must use the same method between Exports and Imports.

As I mentioned in my first comment, we do have known issues with product category imports when it comes to "WPML All Import" and it might be that this is also the case with "WPML Export & Import" and we were not aware of this yet. I would need to run a test for this purpose.

It would be ideal if you could provide me access to the site from which you are exporting the product categories so that I can run a test on a test site that I will provide.

You could alternatively send me the export files that you created with WPML Export & Import by using a service of your choice and sending me a download link.

Only make sure that those files have not been modified manually.

The private reply form is enabled again.

Best regards
Andreas

April 17, 2024 at 9:44 pm #15535008

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

The purpose of the plugin is to move your multilingual content to a new WordPress site.

You usually install the plugin on both sites, to create an export file and then you import this file on the new site.

In this case, WPML will add all the necessary information to the file, incl. taxonomy IDs, terms, slugs, parent slugs, and some specific WPML fields for setting the relation between languages.

This means if the language information inside the files does not match, or there might be a mismatch in regards to used IDs or slugs the import will fail.

If you use a custom import file, you will need to follow this guide:
https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/

Did you follow this guide when creating your English translations?

Could you please send me your files so that can review them?

For example, you can use a service like WeTransfer and send me a download link:
hidden link

Best regards
Andreas

April 18, 2024 at 7:53 am #15535876

michaelG-25

Hello,

I did send you over WeTransfer the WooCommerce Product Categories Files as an CSV-File in DE, FR, EN.

Yes, I did follow this guide when creating your English translations.
But in our case we not just Export & Import a WooCommerce Shop from old webshop-page to new webshop. We want to export the old Webshop which is only in german. And then import it into the new webshop and additionally import the translations in FR and EN.

Therefore your support told me we have to integrate WPML specific rows like:

_wpml_import_translation_group: Ein Wert, der für alle Übersetzungen der einzelnen Inhalte gleich ist. Auf E-Commerce-Websites ist dies oft die SKU.

_wpml_import_language_code: Der Sprachcode für jeden Eintrag.

_wpml_import_source_language_code:

The WPML Support told me when I wanna import different language translations into WordPress/WooCommerce Webshop I can only do it with WP All Import Pro. Is this right?
The strange thing is sometimes it works sometime it doesn't. Why one language works but two language doesnt work? The same problem I have with the products. I can import one language but not two??

Best regards,¨
Jun

April 18, 2024 at 6:58 pm #15540902

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

On your files, all categories are using the same ID. Each content in each language needs to have a unique ID. Also, with WPML Export & Import you should be able to run the import for all languages using one single file.

You can download an example file here:
https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/#creating-taxonomy-spreadsheets

Best regards
Andreas

April 23, 2024 at 1:47 pm #15556344

michaelG-25

Hello,

Thanks if I follow your instruction and using a single file it works!

But for the products I have two lists which I can not put together. How should I proceed with the product list in DE, FR, EN?

If you download the example which you send me for products its a different list then mine:
https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/#creating-post-spreadsheets

I will send you the product list in DE, FR, EN over wetransfer. So you can check my import spreadsheets.

Thanks a lot for your help.

Best regards
Jun

April 23, 2024 at 7:30 pm #15557891

Andreas W.
Supporter

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello Jun,

These files do not look as if you exported them with "WPML Export & Import", as they are missing the language information and also all your originals and translations share the same product ID.

Did you first install "WPML Export & Import" on your site before exposing the content?

Guide:
https://wpml.org/documentation/related-projects/wpml-export-and-import/#install-wpml-export-import-on-sites

I suggest you export a new file with WPML Export and Import and then, if you need to add a new language to the file, implement your translations into this file by using our example file as a reference.

- Each product in WooCoomerce needs a unique product ID - the translations can not share the same ID as the original product.

- Each product needs a source language in the column "_wpml_import_language_code" - for example the imported product is Spanish, then you need to enter "es".

- The unique identifier "_wpml_import_translation_group" should be the SKU - the SKU will be identical between original and translated products.

- If the product is a translation, you need to include a column for "_wpml_import_source_language_code" and place there the language code of the original product

Guide:
https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/#creating-spreadsheets-with-language-columns

Best regards
Andreas

The topic ‘[Closed] Import Multilingual Categories’ is closed to new replies.