export csv - WPML

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
-	8:00 – 13:00	9:00 – 13:00	9:00 – 13:00	8:00 – 12:00	8:00 – 12:00	-
-	14:00 – 17:00	14:00 – 18:00	14:00 – 18:00	13:00 – 17:00	13:00 – 17:00	-

Supporter timezone: Europe/Zagreb (GMT+02:00)

Tagged: Not WPML issue

This topic contains 4 replies, has 0 voices.

Last updated by cagiC 12 hours, 50 minutes ago.

Assisted by: Bruno Kos.

Author	Posts
July 22, 2025 at 4:40 pm #17260426
cagiC	Background of the issue: I am trying to understand the discrepancy between the number of products displayed on the WordPress Dashboard and the number of articles exported to CSV on my site hidden link. My main language is Italian, and I also have content in German. Symptoms: On the Dashboard, I see 53 products in Italian and 53 in German, but the CSV export shows 60 articles in Italian and 73 in German. Questions: Why is there a discrepancy between the number of products on the Dashboard and the CSV export? How can I match the product counts in WordPress and the CSV export? Where can I eliminate the ghost pages?
July 24, 2025 at 4:52 am #17265918
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	Hi, The discrepancy between the number of products shown in the WordPress Dashboard and the number exported to CSV is likely caused by WooCommerce product variations and multilingual entries. Each product variation, such as a different bottle size, is treated as a separate product in the database and given its own unique ID. While these appear as a single product in the Dashboard, they are possibly listed individually in the CSV export. To verify this, can you temporarily disable WPML and export the products again? If the new CSV shows approximately 106 products, the issue is related to translation entries. If the number is still higher, the excess is likely due to product variations.
July 27, 2025 at 6:04 pm #17273393
cagiC	Hi, did this To verify this, can you temporarily disable WPML and export the products again? but nothing changed 🙁
July 28, 2025 at 12:37 pm #17275024
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	Just to make sure I fully understand — when you say "nothing changed" after disabling WPML, does that mean the number of products in the CSV export is still 60 for Italian and 73 for German? Or did the export show a different count?
July 28, 2025 at 4:22 pm #17276286
cagiC	Yes, it looks like the system keeps revisioned translation and also products which are not puplished (private). Take a look at the two files. The smaller where you can see names of the products and the bigger which contains everything (also the translations). please remove .jpg (they are csv. files) Greetings, Roberto