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 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: America/Argentina/Buenos_Aires (GMT-03:00)

This topic contains 8 replies, has 1 voice.

Last updated by Otto 3 weeks, 1 day ago.

Assisted by: Otto.

Author Posts
April 4, 2025 at 11:18 am #16897138

piaP-6

Background of the issue:
We are importing simple products regularly using the guide here: hidden link. It works very well and stable. Now we want to import variable products as well. We have been looking at this guide: hidden link. However, we cannot figure out how to set up the combined sheet. We want to use Example B. We have tried to extend your example, but the products are just imported into the default language, and it is not changed after running the WPML export/import-"job".

Symptoms:
The products are just imported into the default language, and it is not changed after running the WPML export/import job.

Questions:
How can we import the variable products in different languages?
Do you have a test example?

April 5, 2025 at 9:23 am #16899629

piaP-6

Hi again,

I have read this guide as well https://wpml.org/documentation/related-projects/legacy-wpml-all-import/importing-variable-products-in-multiple-languages-with-wp-all-import-and-wpml/ but since it's marked as legacy in the URL, I do not think it is the right way to do it when using the new WPML Export and Import plugin.

April 8, 2025 at 4:05 am #16906636

Bigul
WPML Supporter since 01/2013

Languages: English (English )

Timezone: Europe/Vienna (GMT+02:00)

Hello,

Welcome to the WPML support forum. Before passing this thread to my colleague, I would like to share some suggestions and possible solutions for the issues you mentioned.

Sorry for the late response because of the holidays and the high support load. It is not normal here. Thank you for your kind understanding.

To help you faster, I've enabled debug information for this support ticket. Please see this link for how to get this information from your site and give it to us: http://wpml.org/faq/provide-debug-information-faster-support/

Have you tried the steps suggested in the following documentation:
https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/

If you are still having the issue, please share a couple of screenshots for a better understanding.

--
Thanks!

Bigul

April 8, 2025 at 9:21 am #16907870

piaP-6

Hi Bigul,

Yes, I know that guide as well. However, It does not explain importing variable products using Option B in the import process. Can you explain that further?

Additionally, the test data looks like it is for option A, and we cannot use that option due to our data formatting.

Best Regards,
Peter

Example B.PNG
April 9, 2025 at 1:55 pm #16914226

Otto
WPML Supporter since 09/2015

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

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello Peter,

I apologize for the delay in responding. I will handle this ticket; the reply time will be shorter now.

How is the export created? Can you share it with us? Are you moving products from another WP site? Did you try creating separate files per language instead? Did you try the standard WooCommerce export?

Best Regards,
Otto

April 10, 2025 at 10:35 am #16917825

piaP-6

Hi Otto,

Thanks for your reply. I have tried just to use a simple file like this: hidden link

For variable product group ID I use "Product Title"
For _wpml_import_translation_group I use the "SKU"

However, that simple test does not work. The translations are not connected correctly after import.

Best Regards,
Peter

April 10, 2025 at 2:24 pm #16919154

Otto
WPML Supporter since 09/2015

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

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello Peter,

Thanks.

The file lacks the column:
_wpml_import_translation_group

A value that’s the same for all the translations of each item. In e-commerce sites, this will often be the SKU.

Also, the column wpml_import_source_language_code should be _wpml_import_source_language_code (note the underscore at the beginning)

If you go to:
hidden link

you'll see detailed instructions.

Best Regards,
Otto

April 10, 2025 at 5:56 pm #16920171

piaP-6

1. As noted in my previous reply, I do use the SKU for the _wpml_import_translation_group meta field on import. I am not having a separate column for that since it will be a redundant duplicate.

2. The column name does not matter for the wpml_import_source_language_code (or other columns). The values are imported to the _wpml_import_source_language_code (including underscore :-))

However, it still does not work after the Export/Import-action. The translations are not put correctly into place.

Best Regards,
Peter B. Stidsen

April 10, 2025 at 7:28 pm #16920362

Otto
WPML Supporter since 09/2015

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

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hi Peter,

Apologize for the confusion, but as I suggested to try the WooCommerce importer, I was thinking in this flow:
https://wpml.org/documentation/related-projects/wpml-export-and-import/#import-multilingual-content

which needs the columns.

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

includes variable products. Can you give it a try?

If it does not point in the right direction, I created a test site so we can take a look there. You can access it by following this link:
hidden link

Can you please install the WP All Import add-ons needed to test it?

Best Regards,
Otto

The topic ‘[Closed] To import variable Woocommerce products’ is closed to new replies.