Shared on Mage Dispatch · 14 May 2025

MySQL views to aggregate EAV data

These queries/views aggregate all EAV values for each entity into a JSON column (eav_int, eav_text, etc) for easier debugging. For scoped entities, any scope values will be appended as "{attribute_code}:{store_id}"="{value}".

Visit link → https://gist.github.com/rhoerr/a55285c9cabad6b87d592d5db7589262

More like this

New here? This is Mage Dispatch

Mage Dispatch is a community-run archive and bi-weekly newsletter for the Magento, Adobe Commerce and Mage-OS ecosystem. Modules, articles, security advisories and tools, hand-picked by developers and shared so good work does not disappear into the void.

Browse the latest links → Explore by topic → Submit a link → About us →