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:modelsCheck if the assigned sourcemodel, backendmodel and frontendmodel still exist and if they are allowed to be used.eav:clean:product-attribute-set-valuesCheck for abandoned attribute values in eav tables. The attribute was removed from an attribute set the values still exist.eav:clean:scope-valuesCheck 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-valuesRemove attribute values for storeviews that don't exist anymore.eav:clean:entity-type-valuesRemove 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-parentRemove 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-valueCheck 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-valueCheck 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-unusedRemove attributes with no values set in products and attributes that are not present in any attribute sets.eav:media:remove-unusedRemove 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