Skip to content Skip to sidebar

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
- 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 -
- 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 -

Supporter timezone: Asia/Kathmandu (GMT+05:45)

This topic contains 0 reply, has 1 voice.

Last updated by Shekhar Bhandari 2 months, 4 weeks ago.

Assisted by: Shekhar Bhandari.

Author Posts
January 15, 2025 at 8:56 am #16596115

alirezaS-3
Site owner

The end result of any 'translation/migration', the SKU's of translated products/variants should be the same as the products/variants of the original language. A product/variant must have the same SKU - no matter what language the web shop are using. This is quite fundamental in business/shopping.

If you look at a translated variant (in your test environment), the value of the SKU is taken from the product (not the variant) of the original language, which is wrong. See attachment.

If we still need to put in unique SKU's in the translated CSV, then your import/export function mixes up the SKU's - ie. it should copy the SKU from the variant of the original language, not the product.

and again, I have successfully performed such imports before with the same SKU's in translated CSV's. You can see that I have another support ticket - here we also did the same without such issues. We had no problems importing the products/variants, but the wpml import/export function mixes up the categories, which is why I have the other support ticket (which is still active). I think that 'something else' has changed, since we now can't import translations with identical SKU's. It could be changes in Woocommerce or changes elsewhere in WPML.

2025-01-15_09-36-35.jpg
January 15, 2025 at 9:27 am #16596255

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I can see the issue, I will pass the info to your 2nd tier supporters.

Thanks

January 22, 2025 at 3:04 pm #16623849

alirezaS-3
Site owner

Please let me know the status of this issue, Thanks.

January 23, 2025 at 4:08 am #16625513

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

The issue is still in our 2nd tier queue, I will update you as soon as I will receive further feedback.

Thanks

January 30, 2025 at 4:29 am #16649143

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Our 2nd tier suggested to use the following csv as example and import the products, we are also updating the documentation as needed.
hidden link

Let me know if this helps.

Thanks

February 3, 2025 at 6:23 pm #16664052

alirezaS-3
Site owner

Hi, I can't access the file. We don't have google drive at it seems it wants us to create a user etc. What is the process for getting the file ?

Also what has been changed ? Have you tested the csv file ?

February 4, 2025 at 4:19 am #16664848

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Can you try this url? hidden link

I have tested it and it worked for me.

Thanks

February 4, 2025 at 11:53 am #16666438

alirezaS-3
Site owner

Thanks, I managed to download the file. I will look into it, do an import and come back to you.

February 4, 2025 at 2:19 pm #16667281

alirezaS-3
Site owner

Hi

I downloaded your example csv file and changed 'fr' to 'de' (as we don't have french defined in our wpml/woocommerce site). I also removed the two simple products.

I ran the import and it imported 2 products and 4 variations. Afterwards I ran the wpml "export and import" and finally I saw the result - which was not as expected:

The two product languages are still listed as "en" products and looking the product in "en" and "de", I don't see any variations listed. There should be two for each language.

Screenshot attached.

Can you please perform the same import in your test environment and let me know the outcome. Please also let me know what/if something has changed - since you write "we are also updating the documentation as needed".

Thanks in advance.

2025-02-04_15-01-04b.jpg
February 5, 2025 at 4:30 am #16668984

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Please check this video: hidden link

I ran the tests on this test site: hidden link

While testing out we found out that if the columns name aren't defined properly for attributes the import doesn't work even without WPML and using sku for secondary language is not supported so if you check the csv now, we use id to link the parent and variations.

Let me know if this helps.

Thanks

February 5, 2025 at 7:23 pm #16672785

alirezaS-3
Site owner

Hi

There are still issues with the SKU of the translated variations, which you also can see in your test system:

SKU of EN product: woo-hoodie (correct)
SKU of EN product variant 1: woo-hoodie-blue (correct)
SKU of EN product variant 2: woo-hoodie-green (correct)

SKU of FR product: woo-hoodie (correct)
SKU of FR product variant 1: woo-hoodie (wrong – should be woo-hoodie-blue)
SKU of FR product variant 2: woo-hoodie (wrong – should be woo-hoodie-green)

We can't have a product with different SKU's. There must be something wrong with your wpml php code.

February 6, 2025 at 3:54 am #16673493

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Thank you for the feedback.

I will pass this info to our 2nd tier supporters.

Thanks

February 13, 2025 at 5:37 am #16699835

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Can you check the solution from here and see if it helps? https://wpml.org/errata/woocommerce-import-tool-importing-product-variations-is-not-supported/

Thanks

February 15, 2025 at 11:37 am #16708831

alirezaS-3
Site owner

Hi

Can you please help with this statement "Install it in your plugins directory and activate it". Which folder shall I copy the file to and how do I activate ?

Thanks

February 17, 2025 at 4:13 am #16711626

Shekhar Bhandari
WPML Supporter since 03/2015

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

You need to install it just like any other normal plugins, or add them in wp-content/plugins folder.

Let me know if this helps.

Thanks