showing 2 custom attributes in 1 column catalog admin grid

Question

I add columns to the product admin grid with addColumn.

Is it possible to show 2 custom attributes in 1 column.

Something like this:

$this->addColumn('lev_vdm_inkoop',
        array(
            'header'=> Mage::helper('catalog')->__('VDM'),
            'width' => '70px',
            'index' => array('lev_vdm_stock','lev_vdm_inkoop'),
    ));

Answer 1

Here is how you can do it.
Rewrite the _prepareCollection method of the product grid and add this

    $collection->addExpressionAttributeToSelect(
        'lev_vdm_inkoop',
        "CONCAT_WS(' ', {{lev_vdm_stock}}, {{lev_vdm_inkoop}})",
        array('{{lev_vdm_stock}}'=>'lev_vdm_stock', '{{lev_vdm_inkoop}}'=>'lev_vdm_inkoop')
    );

After

->addAttributeToSelect('type_id');

Then in the _prepareColumns add this:

    $this->addColumn('lev_vdm_inkoop',
        array(
            'header'=> Mage::helper('catalog')->__('Label goes here'),
            'index' => 'lev_vdm_inkoop',
        ));