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?
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.
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?
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
Languages: English (English )German (Deutsch )French (Français )
Timezone: Europe/Zagreb (GMT+02:00)
Based on your observations, it looks like the discrepancy comes from the CSV export including unpublished products, drafts, and possibly older translation revisions. This would explain why the number of entries in the export is higher than what’s shown in the Dashboard.
Given this, it seems the issue is not related to WPML itself but rather to how the export tool handles content.
Could you please confirm if you agree that this is not an issue on the WPML side?
