an error during import of csv file

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 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	-
-	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	-

Supporter timezone: Asia/Kathmandu (GMT+05:45)

Tagged: Documentation request

This topic contains 1 replies, has 1 voice.

Last updated by Shekhar Bhandari 2 months, 1 week ago.

Assisted by: Shekhar Bhandari.

Author	Posts
December 20, 2024 at 7:18 am #16532213
alirezaS-3 Site owner	Background of the issue: I'm using the built-in CSV importer. The first import with products in language EN completes without errors. The next import with products in language DE shows an error. I didn't tick the option 'Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped.' In the CSV files, I have the three WPML fields 'Meta:_wpml_import_translation_group, Meta:_wpml_import_language_code, Meta:_wpml_import_source_language_code'. Symptoms: The second import shows the error: 'Import complete! Products were skipped' and for each product: 'A product with this SKU already exists.' Questions: Why are products being skipped during the second import? It should import both csv files (ie. for both languages) What's the issue/solution ?
December 23, 2024 at 3:14 pm #16540839
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello 🙂 Could you set the SKU in the second language import to "Do Not Import" and proceed with the import? After the import, run the WPML settings, and it should copy the SKU from the primary language automatically. Let me know if this works for you. Thanks!
January 4, 2025 at 9:02 am #16563000
alirezaS-3 Site owner	During the 2nd import I can't leave out the SKU, because the SKU's are used as 'links' between products and variations.
January 6, 2025 at 7:27 am #16565187
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, Can you provide me the csv file you are using? You can use google drive and share the links with me. Look forward to your reply. Thanks
January 7, 2025 at 10:28 am #16568889
alirezaS-3 Site owner	Hi Here are the two files: hidden link hidden link
January 7, 2025 at 10:32 am #16568964
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, You mentioned that you are using SKU for slugs, can you explain how you are doing that. With WPML SKU for both languages will be same, so you are okay with setting the slugs similar in multiple languages? Look forward to your reply. Thanks
January 7, 2025 at 8:05 pm #16571348
alirezaS-3 Site owner	Hi Not sure what you mean about using SKU as slug. I 'just' want to import original language products followed by translated products.
January 8, 2025 at 4:20 am #16571983
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, Sorry, I misunderstand it. You mentioned links I thought it as slug. Can you set the sku something different in secondary language csv and run the import to see if the problem exists? Look forward to your reply. Thanks
January 8, 2025 at 1:54 pm #16573774
alirezaS-3 Site owner	This does not work, because relationships between variant and variations are controlled by the SKU. Also your example files on your own website show identical SKU's.
January 9, 2025 at 4:04 am #16575920
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello, I’ve escalated the issue to our second-tier support team for further investigation. I will keep you updated as soon as I receive any feedback from them. Thank you.
January 9, 2025 at 2:07 pm #16578180
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, Our second-tier team has further investigated the issue and confirmed that there is an error in the example provided in the documentation. We have notified the documentation team to address and correct these examples. Regarding the default import, the SKU can be added to entries in the primary language, but it should remain empty for entries in secondary languages. WPML will automatically handle and set the SKU for secondary languages during processing. Therefore, I recommend adjusting the CSV file accordingly and reimporting it. Thank you.
January 10, 2025 at 11:26 am #16581757
alirezaS-3 Site owner	I adjusted the translation csv (removed SKU's) and ran both imports, followed by the wpml export and import function. The result is not as expected. All products in mixed languages are listed under language EN. I would expect to only see two products: two products under EN and two products under DE. Please advice. Maybe you should setup a test environment. Thanks in advance.
January 10, 2025 at 1:05 pm #16582157
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, I have created a test site here: hidden link I imported the products and it worked for me but I made some adjustments as below on de import file - Removed the sku fields and set it to be empty. - On Meta:_wpml_import_source_language_code I added en as this is required, since it's translations of English. - While importing set the sku to do not import for De. Can you make this changes and try to see if it helps. Thanks
January 14, 2025 at 10:30 am #16592311
alirezaS-3 Site owner	Hi Still not working 100%. Looking at the test site, I don't see any product variations in language DE. They are only shown in EN. When you look at a product in DE you can't select any 'options/variants'.
January 15, 2025 at 5:45 am #16595507
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hi there, Thank you for sharing the details. It appears that WooCommerce relies on the SKU for linking product variations. Since the SKUs were left blank, this caused the issue to arise. I’ve now added unique SKUs for the German products and updated the parent field in the CSV file. It seems to be working fine on my end — could you please verify this from your side? Looking forward to your response. Thanks

The topic ‘[Closed] an error during import of csv file’ is closed to new replies.