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.