Import deletes wpml translation of products

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.

Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
10:00 – 14:00	10:00 – 14:00	10:00 – 14:00	10:00 – 14:00	10:00 – 14:00	-	-
16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	-	-

Supporter timezone: Asia/Jerusalem (GMT+03:00)

This topic contains 2 replies, has 1 voice.

Last updated by Itamar 5 days, 9 hours ago.

Assisted by: Itamar.

Author	Posts
April 1, 2025 at 12:24 pm #16882786
vadimP	Background of the issue: I am trying to import products using WP All Import on my site hidden link. I want the import process to recognize products by SKU, but it seems to be searching by name instead. Symptoms: The import process deletes products in other languages that are translated through WPML, while the original language products remain unaffected. Questions: Why does the import process delete translated products when using WP All Import with WPML? How can I ensure that the import process recognizes products by SKU instead of by name?
April 2, 2025 at 4:39 pm #16888171
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. We hope you are following the steps described in this doc to import the products: https://wpml.org/documentation/related-projects/legacy-wpml-all-import/ https://wpml.org/documentation/related-projects/legacy-wpml-all-import/importing-multiple-languages-with-wp-all-import-and-wpml/ hidden link Please upgrade to the latest version of WPML (4.7.2 series) after a full site backup {mandatory}. You may have to visit Plugins>>Add New>>Commercial tab and click on the Check for updates button to get the WPML automatic upgrade links of the latest version. This step will help us refresh the installer caches. Then, clear all caches and make sure the bug exists while importing the products. -- Thanks! Bigul
April 9, 2025 at 2:13 pm #16914304
vadimP	Hi, I have studied the information you provided, also checked the import settings on my site, but unfortunately it didn't solve my problem Import still works by product name, even though I set id as sku Also import still deletes all products in other languages except for the original one. What can be the solutions to this problem ?
April 9, 2025 at 5:35 pm #16915275
Itamar WPML Supporter since 02/2016 Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, I'll continue to help you with this issue. I carefully checked the screenshots you shared with the import settings. It seems that the setting 'Remove or modify WooCommerce products that are not present in this import file' is related to this problem. According to the second setting, 'Change status of removed WooCommerce products to Draft, ' the products not included in that import file should change their status to Draft. I have two questions, please. 1. Is that import file for product in Latvian the default language? 2. Maybe the translated product did not get deleted. Have you checked if the translated products changed status to Draft? Regards, Itamar.
April 9, 2025 at 6:30 pm #16915621
vadimP	Hi, here are some screenshots and some of the logs from the imports [11:07:03] Record #1 [11:07:03] ACTION: pmxi_before_post_import ... [11:07:03] WARNING: title is empty. [11:07:03] Combine all data for post ``... [11:07:03] Find corresponding article among database for post ``... [11:07:03] Duplicate post wasn't found for post ``... [11:07:03] Applying filter `pmxi_article_data` for `` [11:07:03] SKIPPED: The option 'Create new posts from records newly present in this import file' is disabled in your import settings. [11:07:03] --- [11:07:03] Record #2 [11:07:03] ACTION: pmxi_before_post_import ... [11:07:03] WARNING: title is empty. [11:07:03] Combine all data for post ``... [11:07:03] Find corresponding article among database for post ``... [11:07:03] Duplicate post wasn't found for post ``... [11:07:03] Applying filter `pmxi_article_data` for `` [11:07:03] SKIPPED: The option 'Create new posts from records newly present in this import file' is disabled in your import settings. [11:07:03] --- [11:07:03] Record #3 [11:07:03] ACTION: pmxi_before_post_import ... [11:07:03] WARNING: title is empty. [11:07:03] Combine all data for post ``... [11:07:03] Find corresponding article among database for post ``... [11:07:03] Duplicate post was found for post ``... [11:07:03] Preserve date of already existing article for `` [11:07:03] Preserve status of already existing article for `` [11:07:03] Preserve content of already existing article for `` [11:07:03] Preserve title of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve slug of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve excerpt of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve menu order of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve post parent of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve post type of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve comment status of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve ping status of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Preserve post author of already existing article for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] Applying filter `pmxi_article_data` for `Acetyl-L-Carnitine 120 kaps.` [11:07:03] UPDATING `Acetyl-L-Carnitine 120 kaps.` `Product` [11:07:04] Associate post `Acetyl-L-Carnitine 120 kaps.` with current import ... [11:07:04] WooCommerce ADD-ON: [11:07:04] Property `regular_price` updated with value `26.39` [11:07:04] Property `sale_price` updated with value `` [11:07:04] Property `stock_status` updated with value `instock` [11:07:04] Property `stock_quantity` updated with value `1` [11:07:04] ACF ADD-ON: [11:07:04] - Importing field `url` [11:07:04] IMAGES: [11:07:04] UPDATED `Acetyl-L-Carnitine 120 kaps.` `Product` (ID: 1478) [11:07:04] TEST [11:07:04] ACTION: pmxi_saved_post [11:07:04] ACTION: pmxi_after_post_import [11:07:04] --- I hope this helps you.
April 10, 2025 at 4:14 pm #16919801
Itamar WPML Supporter since 02/2016 Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, Thanks for sharing the log and the screenshots. At this point, I cannot decipher anything about this problem from them. WPML All import issues usually require a more extended investigation. Also, please answer the following question I asked before. Maybe the translated product was not deleted. Have you checked if the translated products changed status to Draft? Can you please take a video of your import process, use your voice over the video to describe what you are doing, and share it with me? You can use the free online screencast service Loom - hidden link. This should help me see if you do anything wrong. Thanks, Itamar.
April 13, 2025 at 7:33 am #16926060
Christopher Amirian WPML Supporter since 07/2020 Languages: English (English ) Timezone: Asia/Yerevan (GMT+04:00)	Hi, Itamar will be available tomorrow to answer the question. For now, I made the previous reply private as it contained user/pass. Thanks.
April 14, 2025 at 8:05 am #16927672
Itamar WPML Supporter since 02/2016 Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, Important! Our forum is public. It is not a private discussion/thread only between you and us. So please refrain from posting sensitive information in public replies. My colleague has hidden the login details from the previous reply. For your site's safety, please change those details. I'm not allowed to use the access details as you shared them. You must share them in a private reply. This way, you also consent that we will access your site and that you have a backup. If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply. Privacy and Security Policy We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ IMPORTANT - - Please backup the site files and database before providing us access. -- -- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.-- Regards, Itamar.
April 20, 2025 at 1:58 pm #16949906
Itamar WPML Supporter since 02/2016 Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi, and thanks for the access details. I checked things on your site and found out the following. A. You are not using WooCommerce Multilingual & Multicurrency, our bridge plugin for WooCommerce. This plugin is a must when working with WPML and WooCommerce. (The plugin that you use is not our official plugin.) B. You are using the legacy version of our WP All Import bridge plugin. We recommend using the newer version - WPML Export and Import. C. Your file has mixed products. It contains products in the Latvian and English languages. You should prepare a file for each language. Please thoroughly review our guides. D. Your settings are configured such that any product not included in the file is placed in draft status. The result of the translated products that reach the draft status is expected. I've recorded a video for you that provides additional explanations. hidden link Please let me know if you have any further questions. Regards, Itamar.