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?
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:
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.
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?
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] ---
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.--
