Magento – way to add custom attributes to the Admin side product search

catalogsearchmagento-1.7

I am looking to be able to search by a custom attribute's values on the Admin side in Catalog > Product search.

By default you can search by a range of product ID's, name, type, attribute set name, SKU, etc.

Is there a way to add my own attribute in that product search?

Best Answer

To add an attribute column to products grid you have to create a module with 2 observers.

First you have to observe eav_collection_abstract_load_before event and to add your attribute to collection:

public function eavCollectionAbstractLoadBefore(Varien_Event_Observer $observer)
{
    $observer->getCollection()->addAttributeToSelect('color');
}

Then you have to observe adminhtml_block_html_before event, check that the current grid is products listing and add new column:

public function adminhtmlBlockHtmlBefore(Varien_Event_Observer $observer)
{
    $block = $observer->getBlock();
    if ($block->getId() == 'productGrid') {
        $block->addColumn('test', array(
            'header'    => 'Color',
            'index'     => 'color'
        ));
    }
}

That's all. Enjoy.

Related Solutions

Magento Quick Search Custom Attributes with Conditions

Try creating a new module

In your config.xml

...
<adminhtml>
    <global_search>
        <magepal_custom_attributes>
            <class>MagePal_GlobalAttributesSearch_Model_Search_Customattributes</class>
            <acl>magepal_globalattributessearch</acl>
        </magepal_custom_attributes>
    </global_search>
</adminhtml> 
    ...

in app/code/local/MagePal/GlobalAttributesSearch/Model/Search/Customattributes.php

<?php
class MagePal_GlobalAttributesSearch_Model_Search_Customattributes extends Varien_Object
{
    /**
     * Load search results
     *
     */
    public function load() {
        $arr = array();
        $searchText = $this->getQuery();


        // move code above to your if statement and do your db lookup accordingly 
        $collection = Mage::getModel('module/name')->getCollection()

         if(is_int($searchText)){
           /* search for int in product sku and custom */
            $collection->addFieldToFilter(
                array('field_name'),
                array(
                    array('like'=>'%'.$searchText.'%'), 
                    )
                );
         }
         else{
            /* search product name and description  */
            $collection->addFieldToFilter(
                array('field_name','field_name'),
                array(
                    array('like'=>'%'.$searchText.'%'),
                    array('like'=>'%'.$searchText.'%'), 
                    )
                );
         }

        $collection->load();

        foreach ($collection as $model) {
            $arr[] = array(
                'id'            => 'path/1/'.$model->getId(),
                'type'          => Mage::helper('adminhtml')->__('Custom Attributes'),
                'name'          => $model->getId(),
                'description'   => Mage::helper('core/string')->truncate('desc', 35),
                'url' => Mage::helper('adminhtml')->getUrl('*/path/edit', array('id'=>$model->getId())),
            );
        }

        $this->setResults($arr);
        return $this;
    }
}

See http://blog.mattstephens.co.uk/post/27326981315/adding-custom-module-to-magentos-admin-global-search

You could also rewrite the global product search block.

Magento – Loop Magento Custom Attributes in Product View Description

Magento already has a block that displays the attributes in the view page. It is called Mage_Catalog_Block_Product_View_Attributes. See this as demo (additional information section).
All the attributes that have is_visible_on_front are displayed in that section.

The only down side is that it shows event he attributes that don't have a value.
To overcome this, just rewrite the method getAdditionalData in that block and replace

if (!$product->hasData($attribute->getAttributeCode())) {
    $value = Mage::helper('catalog')->__('N/A');
} elseif ((string)$value == '') {
    $value = Mage::helper('catalog')->__('No');
} elseif ($attribute->getFrontendInput() == 'price' && is_string($value)) {
    $value = Mage::app()->getStore()->convertPrice($value, true);
}

with

if (!$product->hasData($attribute->getAttributeCode())) {
    continue;
} elseif ((string)$value == '') {
    continue;
} elseif ($attribute->getFrontendInput() == 'price' && is_string($value)) {
    $value = Mage::app()->getStore()->convertPrice($value, true);
}

EDIT
But just in case you need it for something...here is how you can get the product available attributes

$attributes = $product->getAttributes();

Best Answer

Related Solutions

Magento Quick Search Custom Attributes with Conditions

Magento – Loop Magento Custom Attributes in Product View Description

Related Topic