Purpose of this project is to check for different flaws that can occur due to EAV and provide cleanup functions.
Run bin/magento in the Magento 2 root and look for the eav: commands.
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.eav:clean:attributes-and-values-without-parent Remove orphaned attribute values - those which are missing a parent entry (with the corresponding backend_type) in eav_attribute.Use --dry-run to check result without modifying data.
Use --force to skip the confirmation prompt before modifying data.
Installation with composer:
composer require magento-hackathon/module-eavcleaner-m2