Name: EAVCleaner
Owner: FireGento e. V. - Hackathons
Description: Clean up your Magento database by removing orphaned, unused and wrongly added attribute, attribute values and settings (for M1 & M2)
Created: 2015-05-29 07:56:09.0
Updated: 2018-04-26 08:56:57.0
Pushed: 2017-05-08 09:13:12.0
Size: 87
Language: PHP
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
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.
The Magento 1 version is in the master branch, the Magento 2 version is in the magento2 branch.
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.See issues labeled enhancement
See the magerun addon installation guide