I am exporting products using Dataflow profile. The exported inventory csv file contains the deleted products also.But in Manage product option,no deleted products appear. I have tried exporting after clearing cache and reindexing, but no use. Still the products exported with deleted products. How to export active products only ?
This is a very late answer but I figured it out today. You have enable flat catalog in your M1 store.
The exported csv via System > Export, exports the in the catalog_product_entity. Not in the flat catalog.
If you want to delete the product without accessing the database directly, you need to disable flat catalog first, then delete the sku in Manage Products. Then export is via CSV. It will be gone. 😄👍