Magento – How to combine two attributes in Adminhtml Grid view

adminhtmlmagento-1.9product-attributeproduct-grid

I am looking to learn how to combine both name and size attributes in the app/code/local/Mage/Adminhtml/Block/Catalog/Product/Grid.php file (yes, we will make a local) so that when I view products these two will appear together separated by a space. We have separated size as an attribute and we need it to appear in the name column of the grid. What we would see now might be something like "Fruit Drink Grape" and I wish to see "Fruit Drink Grape 8 fl. oz."

Best Answer

First: It's better to make a proper rewrite of this class or add your colums via observer.

However, you could update your name column like this:

$this->addColumn('name',
        array(
            'header'=> Mage::helper('catalog')->__('Name'),
            'index' => array('name', 'size'),
            'type' => 'concat',
            'filter_index' => "CONCAT(name, ' ', size)"
    ));

Related Solutions

Magento – Why isn’t magento finding the adminhtml grid block

The solution was to add the following block in config.xml:

    <blocks>
        <ebuynow_ebnreports>
            <class>Ebuynow_Ebnreports_Block</class>
        </ebuynow_ebnreports>
    </blocks>

Display Data in Custom Column in Magento 1.9 Admin – How To

I've finally did it that way:

app/code/local/Mypackage/Customgrid/etc/Config.xml:

<?xml version="1.0"?>
<config>
    <modules>
        <Mypackage_Customgrid>
            <version>0.4.0</version>
        </Mypackage_Customgrid>
    </modules>

    <global>
        <blocks>
            <adminhtml>
                <rewrite>
                    <catalog_product_grid>Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid</catalog_product_grid>
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

app/code/local/Mypackage/Customgrid/Block/Adminhtml/Catalog/Product/Grid.php:

class Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid
{
    protected function _prepareCollection()
    {
        parent::_prepareCollection();
        $collection = $this->getCollection();

        $collection->addAttributeToSelect('udropship_vendor');

        $this->setCollection($collection);
        $this->getCollection()->addWebsiteNamesToResult();

        return $this;
    }

    protected function _prepareColumns()
    {
        $attributeId = Mage::getResourceModel('eav/entity_attribute')->getIdByCode('catalog_product','udropship_vendor');
        $attribute = Mage::getModel('catalog/resource_eav_attribute')->load($attributeId);
        $attributeData = $attribute->getData();
        $attributeOptions = $attribute->getSource()->getAllOptions();

        $attributeOptions2 = array();
        foreach ($attributeOptions as $value) {
            if(!empty($value['value'])) {
                $attributeOptions2[$value['value']] = $value['label'];
            }
        }

        $this->addColumnAfter('udropship_vendor',
            array(
                'header'=> Mage::helper('catalog')->__('Vendor Name'),
                'width' => '150px',
                'index' => 'udropship_vendor',
                'type'  => 'options',
                'options' => $attributeOptions2,
        ), 'price');

        return parent::_prepareColumns();
    }
}

Best Answer

Related Solutions

Magento – Why isn’t magento finding the adminhtml grid block

Display Data in Custom Column in Magento 1.9 Admin – How To

Related Topic