I use Magmi Product deleter for deleting products from Magento 1.8.

The plugin has a function removeFromFlat() to delete all records of the product from the catalog_product_flat_% tables.

What is the reason this is not done for all catalog_product_entity_% tables as well?

When I remove a product now, all attribute-values remain in the database.

  • 1
    Have you checked that they are staying? Maybe those are handled by sql foreign keys and on delete cascading? – Darokthar Feb 6 '15 at 10:12

For the eav system there should be foreign keys on all the tables like catalog_product_entity_datetime so that if the main product is deleted then mysql will also delete all the appropriate items from all the other tables.

|improve this answer|||||

Not the answer you're looking for?Browse other questions tagged or ask your own question.