[Escalated to WPML Developers team] import of wpml translations

Hi again,

I rechecked the video and noticed that "_wpml_import_source_language_code" meta field didn't appear during the field mapping process in the default WooCommerce importer. Please see the attached screenshot.

Since you are creating custom CSV files, please ensure that all the columns required for the WPML Export and Import are in the CSV file. You can follow this guide to make sure that the CSV file is correctly configured.

Does this work for you?

Best Regards,
Marcel

Hi,

Could you please provide access to a staging environment for further testing? Additionally, it would be helpful if you could upload your import files to the server.

I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to a testing site where the issue is replicated.

You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you.

IMPORTANT
-Please make a backup of site files and database before providing us access.
-If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this:
hidden link

Thank you!

Best regards,
Marcel

Can you please try it again?

Thank you!

I’ll export the files, compare the settings, test everything locally, and keep you updated on the progress.

Best regards,
Marcel

Hi,

here’s what I did:

1) I imported a new product using my own de.csv export (note: all column headers in my file are in German, whereas in your file, the de.csv shows English column headers).
2) I translated the file into English to create the en.csv export.
3) I deleted the English version so that the import could proceed without an existing English product, as demonstrated in your video.
4) I started the English import after the German products were already imported.
5) Both the de.csv and en.csv files appeared in WooCommerce under the German products section.
6) I ran "WPML Export and Import."
7) The products were correctly linked.

It seems the issue on your end was likely related to the checkbox option "Update products where the ID or SKU is identical." This step isn’t mentioned in our documentation. You can view the import and try it yourself here: [hidden link">link]. You'll find both the en.csv and de.csv files in the media library. Use them as a reference, as they both are generated by WooComemrce and will exclude any issue in your own files.

Regarding your questions, I would fully import all to ensure both files are identical. You can find a sample file here.

Best Regards,
Marcel

Hi Thomas,

Regarding point 5, after importing the English version, both products appeared in German, meaning the DE product still shows in German, and the EN version also showed in German. However, after running the WPML Import/Export tool, the English version disappeared and is now correctly linked as English.

The reason you can’t see it in German anymore is that the WPML Import/Export process has already been completed, so the product now appears under "EN."

Best regards,
Marcel

Hi,

I wasn't able to replicate the issue you're describing. It seems like the data you're seeing in the products be leftover from previous imports. I have deleted all the data and re-imported everything, and the issue didn't occur on my end:

Part 1: hidden link">Loom Video
Part 2: hidden link">Loom Video

As you can see in the videos, the import was set to "Draft" and everything is correctly linked.

DE: hidden link
EN: hidden link

Best regards,
Marcel