Magento Database – How to Find Where a Value is Stored

eavmagento-1.8

I have an extension that has allowed us to add some custom customer attributes to the database for use on their profile. I am looking to use one of the attributes ina SQL join in an extension, but I can't find where exactly the value is being saved. I have found the description and setup of the attribute itself in the EAV_attribute table and the backend_type value for it is "varchar" but I can't seem to find exactly what table name to find the actual information.

Best Answer

You should be able to find the values related to a specific customer in customer_entity_varchar table filtering out the dataset by attribute_id ( coming from eav_attribute you mentioned) and entity_id (in your case a valid customer_id ).

Code

$attributeCode = 'color';

$attribute = Mage::getModel('eav/entity_attribute')->loadByCode(Mage_Catalog_Model_Product::ENTITY, $attributeCode);
$productResource = Mage::getResourceModel('catalog/product');

// Use collection only to prepare query
$valuesCollection = Mage::getResourceModel('eav/entity_attribute_option_collection')
    ->setStoreFilter(0, false);

// Now refine query
$valuesCollection->getSelect()
    ->joinLeft(
        array('value_table' => $productResource->getTable(array('catalog/product', 'int'))),
        'main_table.option_id=value_table.value AND main_table.attribute_id=value_table.attribute_id', 'entity_id')
    ->reset(Zend_Db_Select::COLUMNS)
    ->columns(array('main_table.option_id', new Zend_Db_Expr('COUNT(value_table.entity_id)')))
    ->where('main_table.attribute_id=:attribute_id')
    ->group('main_table.option_id');

// ...and fetch data
$result = $productResource->getReadConnection()->fetchPairs(
    $valuesCollection->getSelect(), array('attribute_id' => $attribute->getId()));

Result now contains an array in the form [option_id => number of products]

Magento – Missing custom product attribute value in getData()

Try using $product->getDangerous() after flushing cache since often collections are cached.

Best Answer

Related Solutions

Magento – How to get a collection of attribute values and products that use them

Code

Magento – Missing custom product attribute value in getData()

Related Topic