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.

Tagged: 

This topic contains 11 replies, has 2 voices.

Last updated by Long Nguyen 1 year, 3 months ago.

Assisted by: Long Nguyen.

Author Posts
September 19, 2023 at 10:53 am #14418825

Number Nine

Hello, I will try to explain the question briefly wihout overloading you with data.

I am trying to import from Excel files just one test product.
The main language is Italian and the second langage English.

I have no problem loading data from file in the product in the basic Italian language. Problems arise when loading the data for the English translation.

I have four attributes, and all of them are translated:

Color (checked "In variations", "Is taxonomy", "Is visible")
Diameter (checked "In variations", "Is taxonomy", "Is visible")
Dimensions (checked "Is taxonomy", "Is visible")
Height (checked "Is taxonomy", "Is visible")

In Italian I can load successfully all four attributes.
In English I can load successfully only Color and Diameter, and if I try to add Dimensions and/or Height, each of the other two attributes (Color and Diameter) display values in both languages.

I would be much thankful for your opinion.
Please let me know if you need further information.

September 20, 2023 at 9:34 am #14428201

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi there,

Thank you for contacting WPML support, I'd be happy to help you with this issue.

Follow the documentation https://wpml.org/documentation/related-projects/wpml-all-import-plugin-website-import-with-wpml/importing-variable-products-in-multiple-languages-with-wp-all-import-and-wpml/

please try to create the attributes manually and translate them before importing variable products then start importing again. Note: In the Attributes tab, uncheck the option to Auto-Create Terms.

If you still have an issue when importing variable products, please try to replicate the issue on this sandbox site hidden link
I will help you to check the issue.

Look forward to your reply.
Thanks

September 22, 2023 at 8:13 am #14444351

Number Nine

Hello, thank you for your answer. I will look again into the linked support page and compare with it the procedure I have followed so far.

Concerning your suggestions "create attributes manually and translate them before importing" and "uncheck the option to Auto-Create Terms" they were already attended.

I'll let you know soon, thanks!

September 22, 2023 at 9:14 am #14445321

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I'm waiting for your feedback.

Thanks.

September 24, 2023 at 2:39 pm #14452923

Number Nine

Hello, after deep inspection of my website, and other import attemps, nothing has changed.

I have replicated a minimum install in the sandbox (as per your link) and have found out that the problem has been replicated too, as you can see in the screenshots below: in the EN import (second language) colors appear in both languages.

What's even worse is that in some data imports, without changing any setting, also the IT import (default language) displays colors in both languages, as you can see in the sandbox.

Please consider that I have kept import data to a minimum in order to make it easier to detect the problem.

Could you kindly have a look and give me some hints?

Thank you.

September 24, 2023 at 3:32 pm #14453049

Number Nine

Hello again, I may have found a solution, and would like you to give me your opinion.

After importing IT + EN, in EN product the Color and Diameter attributes (those with checkboxes in "In variations" and "Is visible ") display in both languages.

But if I go to WooCommerce > WooCommerce Multilingual & Multicurrency > Attributes > Attribute to translate: Color, and here click the "Syncro attributes and update variations" button, the unwanted attributes in IT in the EN product are removed.

Is this a correct procedure or a bug that you may fix?

And is this safe, or might it bring about negative effects in other product variations?

Should I make a DB backup before?

Thank you.

September 25, 2023 at 3:24 am #14454205

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

Thanks for your details and for sharing the solution.

I can replicate the issue from scratch and use the solution to fix the issue. I'm asking our 2nd tier support about this issue and update you here when I have something to share.

Meanwhile, you can click on the button to sync attributes across languages. You should create a backup file before proceeding.

Regards.

September 26, 2023 at 3:05 pm #14468031

Number Nine

Hello, thank you for your help.
Could you please leave this post open, until your team finds a solution?
That would avoid opening a double ticket later on and still leave a reference on the subject.
Thanks.

September 27, 2023 at 2:36 am #14470063

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

This issue has been escalated to our development team. I will let you know once I have any information. And this ticket is open until the development team finds a solution/workaround for this.

Thanks.

September 28, 2023 at 2:46 am #14478099

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I got some info from our development team, there is a workaround to fix the issue. You should switch the language with the language switcher at the topbar for the translation product before running the import, please check this screenshot hidden link
Remember to delete products before re-running the import.

Let me know how it goes.

October 5, 2023 at 7:50 am #14517761

Number Nine

Right, thank you for the workaround.
The last two tests I have performed have been successful.
Nevertheless, it would be useful if this bug could be fixed, and maybe also explained in your tutorial page (if I am not wrong it is not).

October 5, 2023 at 8:05 am #14517903

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

Thanks for your confirmation. It has been already escalated to our development team to fix. Meanwhile, you can switch the language to the second one when importing translation products.

Have a nice day.