Magento – List all EAV Attributes of an entity_type_id via SQL

eavsql

How can I obtain the list of all EAV attributes of a specific entity (by its entity_type_id) via SQL?

Best Answer

EAV attributes in the eav_attribute table are directly linked to the entity_type table. So all attributes can be revealed by a left-join query across those two tables:

-- show all eav attributes of an eav entity by entity_type_id

SET @entity_type_id = 10;

SELECT entity_type.entity_type_id, entity_type.entity_type_code
     , entity_type.entity_model
     , attribute.attribute_id, attribute.attribute_code, attribute.backend_type
    FROM eav_entity_type entity_type
    LEFT JOIN eav_attribute attribute 
        ON attribute.entity_type_id = entity_type.entity_type_id
    WHERE entity_type.entity_type_id = @entity_type_id;

Example output:

+----------------+------------------+-----------------------+--------------+----------------+--------------+
| entity_type_id | entity_type_code |     entity_model      | attribute_id | attribute_code | backend_type |
+----------------+------------------+-----------------------+--------------+----------------+--------------+
|             10 | mcd_comment      | mcd_meeting05/comment |          246 | comment        | text         |
|             10 | mcd_comment      | mcd_meeting05/comment |          249 | created_at     | static       |
|             10 | mcd_comment      | mcd_meeting05/comment |          245 | customer_id    | int          |
|             10 | mcd_comment      | mcd_meeting05/comment |          244 | guest_email    | varchar      |
|             10 | mcd_comment      | mcd_meeting05/comment |          243 | guest_name     | varchar      |
|             10 | mcd_comment      | mcd_meeting05/comment |          247 | page           | varchar      |
|             10 | mcd_comment      | mcd_meeting05/comment |          251 | product_id     | static       |
|             10 | mcd_comment      | mcd_meeting05/comment |          248 | store_id       | static       |
|             10 | mcd_comment      | mcd_meeting05/comment |          250 | updated_at     | static       |
+----------------+------------------+-----------------------+--------------+----------------+--------------+

Related Solutions

Magento Database – How to Delete Custom EAV Attributes

See Mage_Eav_Model_Entity_Setup::removeAttribute(). It takes two arguments - the first is the entity code, and the second is the attribute code.

Edit - to run from a non-installation scope:

<?php
include 'app/Mage.php';
Mage::app();
$setup = Mage::getResourceModel('catalog/setup','catalog_setup');
$setup->removeAttribute('catalog_product','attr_code');

Magento – How to properly save EAV attributes for all store views at once

I'm not sure if I understand you correctly, but I'll try with explaining how the loading of the EAV Attributes actually (should) work(s).

If you save a Product in the Admin without choosing a Store View, the Attributes should all get stored with the default store id = 0.

An attribute in Magento has a Scope, which defines if it can be overridden on website or storeview level.

If you load a Product in the frontend, the values for the attributes are loaded from the current store view / website with a fallback to the default store.

So, if you want to save an attribute with the same value for all store views, you only have to save it with the store id = 0, or just do this in the admin context without setting a store id.

You do not have to save the attribute for every store view (if it does not change between them).

If you have to, you are probably not in the admin context or you have a module installed which messes sth up

Best Answer

Related Solutions

Magento Database – How to Delete Custom EAV Attributes

Magento – How to properly save EAV attributes for all store views at once

Related Topic