Skip Navigation

Home › Support › English Support › [Waiting for user feedback] an error during import of csv file

[Waiting for user feedback] 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: 

This topic contains 0 replies, has 1 voice.

Last updated by Shekhar Bhandari 1 day, 5 hours 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
Supporter

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
Supporter

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
Supporter

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
Supporter

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
Supporter

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
Supporter

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.

2025-01-10_12-19-50.jpg
January 10, 2025 at 1:05 pm #16582157

Shekhar Bhandari
Supporter

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