1

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.

closed as off-topic by Fabian Schmengler, Raphael at Digital Pianism, Keyul Shah, Qaisar Satti, Amit Bera Apr 15 '16 at 19:50

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions about third-party modules are generally off-topic because the scope of functionality and code are not available. For more information, see this meta post/answer." – Fabian Schmengler, Raphael at Digital Pianism, Keyul Shah, Qaisar Satti, Amit Bera
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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
1

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.

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