tjitse-e/eavcleaner

Clean up your Magento database by removing orphaned, unused and wrongly added attribute, attribute values and settings (for M1 & M2)

EAV Cleaner Magerun Addon

Purpose of this project is to check for different flaws that can occur due to EAV and provide cleanup functions.

Use --dry-run to check result without modifying data.

Magento 1 or Magento 2?

The Magento 1 version is in the master branch, the Magento 2 version is in the magento2 branch.

Commands

• eav:check:models Check if the assigned sourcemodel, backendmodel and frontendmodel still exist and if they are allowed to be used.
• eav:clean:product-attribute-set-values Check for abandoned attribute values in eav tables. The attribute was removed from an attribute set the values still exist.
• eav:clean:scope-values Check for wrong scopes. Values in Scopes which shouldn't be present. For example values on Storeview level but attribute scope is global.
• eav:clean:removed-store-view-values Remove attribute values for storeviews that don't exist anymore.
• eav:clean:entity-type-values Remove attribute values with wrong entity_type_id. For example the table catalog_product_entity_int should only contain entries with entity_type_id == 10.
• eav:clean:attributes-and-values-without-parent Remove catalog_eav_attribute and attribute values which are missing parent entry in eav_attribute. This can happen after importing data with foreign key check switched off.
• eav:config:restore-use-default-value Check if config admin value and storeview value are the same, so "use default" doesn't work anymore. Delete the storeview values.
• eav:attributes:restore-use-default-value Check if product attribute admin value and storeview value are the same, so "use default" doesn't work anymore. Delete the storeview values.
• eav:attributes:remove-unused Remove attributes with no values set in products and attributes that are not present in any attribute sets.
• eav:media:remove-unused Remove unused product images.

Ideas

See issues labeled enhancement

Installation

See the magerun addon installation guide

Contributors

• Benno Lippert
• Damian Luszczymak
• Joke Puts
• Peter Jaap Blaakmeer
• Ralf Siepker