[Closed] WPML All import second language doesn't match with the default language

Hello,

Thank you for providing me the files. I was able to reproduce on a sandbox site.

Here are few things to consider for your imports:
1. Unique ID should be a number (ID) and not a string of text.
2. SKU for the variation and SKU Parent should be in different columns.
You can look at the screenshot attached for those 2 points.

3. Probably the most important point: Taxonomies and attributes have to be translated first before importing the FR products.
You can either translate them in your dashboard ("WooCommerce > WooCommerce Multilingual > Attributes")
Or you can also make an import dedicated to those terms. It's very similar to the import of products. You have to specify an uniqueID in order to connect the FR attribute with the original NL attribute.

Nico

Hello,

I still have the sandbox site with your imports. Could you please send me the new imports you created so I can test them.
I have activated a private field to share packages but you can share a zip file instead with:
- Import of NL attributes and import of FR attributes (unless you translated them manually)
- Import of NL products and import of FR products

Nico

Hello,

I spent quiet some time running test imports.
At first i though it was the Xpath because I managed to make it work on my sandbox if I didn't use Xpath to determine attributes. I simply left all 4 options checked. But I knew that some of your variations have to be unchecked (In Variation and Is Taxonomy). So I try to figure out what was the issue.

At the end the wrong field was "SKU element for parent", you selected "{uniekeid[1]}" instead of "{skuproductcodeuniekeidnietveranderen[1]}".

Nico

Hello,

Maybe I wasn't clear enough:
1. The mistake was in the French import settings were {uniekeid[1]}" was used instead of "{skuproductcodeuniekeidnietveranderen[1]}". I changed it and ran the import and the products were created correctly.

2. Now regarding attributes, they need to be translated BEFORE importing the products. You can either translate them manually or use also an import.

Having said that let's take "Marque moteur" as an example.
1. hidden link
On that page I checked if "Merk Motor" was translated (terms such as Honda but all the attribute itself at the bottom of the page).
Honda and "Merk Motor" are translated!

2. hidden link
Here I noticed that "Marque moteur" still existed as a French attributes registered as a Dutch one (error from previous imports). I deleted it!

3. hidden link
In the French import settings I made sure that all products get updated (before that option was not set). Then I re-run the import and now "Marque moteur: Honda" is showing on the frontend.
You can see in the history
Previous run: 0 Products created 0 updated 37 skipped
New run: 0 Products created 37 updated 0 skipped

Hello,

I could reproduce the issue. You're right:
- All attributes are translated
- I checked and "copy/paste" those attribute translation into the FR XLS in case there was a small différence (extra space or something that would prevent them to "match" existing translations)
- I re-imported the XLS and re run the import
- I have the same issue you mentioned!

I'm running out of ideas here, so I have escalated your case to the second tier support team. I'll get back to you when I get their feedback.

Nico

Hello,

Thank you for providing this copy. I forwarded it to the second tier support with all information related to your ticket.

I'll get back to you as soon as I have an answer (probably beginning of next week).

Thanks for your patience and collaboration,
Nico

Hello,

I'm sorry for the delay in responding. We just launched WPML 4.6 and devs have been pretty busy. I sent a reminder to try to prioritize your ticket. I'll get back to you asap.

Nico