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.

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 6 replies, has 1 voice.

Last updated by vadimP 16 hours, 35 minutes 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 Supporter 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 Supporter 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 Supporter 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 11, 2025 at 2:27 pm #16923167
vadimP	I can send you access to the test site. hidden link login - wpml-admin pass - 7uXr$hVnJyZTl^vIrezsqsE2 this import should make products in draft that are not in google table file - hidden link. it works correctly only on the LV version, but absolutely all products translated into other languages it does in the draft although it should have saved the translations. This link will show you all the settings for the import I need - hidden link. I hope I've explained enough about what kind of help I need