Show Stock Level/QOH on the Sales_Order_Create_Search_Grid in the backend

Question

We are trying to show a column containing the current Quantity on Hand for each product in the "Please Select Products to Add" search grid in the Magento Backend.

I have so far tried to follow two different post's answers:

• https://stackoverflow.com/questions/17069097/magento-show-stock-levels-in-sales-order-create-search-grid
• Magento add stock qty in backend new order creation

However get the column, the filtering works, but no QOH is shown, and if we view the source the td only contains a nbsp.

We are using Magento EE 1.13.1.0, so I suppose it's possible that our Grid.php is different than the one in 1.8x or 1.9x CE but it seems doubtful.

Does anyone have any feedback or suggestions on something we might try? I am not sure if I am allowed to paste the source from EE but can if it will help.

Edit:

Here is a screenshot the intended result (albeit broken):

Answer 1

It ends up that the code in the other two solutions does work it was a conflict with one of our third party plugins. Sorry to waste everyone's time.

Answer 2

Overide block class called

Mage_Adminhtml_Block_Catalog_Product_Grid located in /app/code/core/Mage/Adminhtml/Block/Catalog/Product/Grid.php file.

protected function _prepareCollection()
{
$store = $this->_getStore();
$collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect('sku')
->addAttributeToSelect('name')
->addAttributeToSelect('short_description') // THIS IS WHAT WE HAVE ADDED
->addAttributeToSelect('attribute_set_id')
->addAttributeToSelect('type_id')
->joinField('qty',
'cataloginventory/stock_item',
'qty',
'product_id=entity_id',
'{{table}}.stock_id=1',
'left');
if ($store->getId()) {
//$collection->setStoreId($store->getId());
$collection->addStoreFilter($store);
$collection->joinAttribute('custom_name', 'catalog_product/name', 'entity_id', null, 'inner', $store->getId());
$collection->joinAttribute('status', 'catalog_product/status', 'entity_id', null, 'inner', $store->getId());
$collection->joinAttribute('visibility', 'catalog_product/visibility', 'entity_id', null, 'inner', $store->getId());
$collection->joinAttribute('price', 'catalog_product/price', 'entity_id', null, 'left', $store->getId());
}
else {
$collection->addAttributeToSelect('price');
$collection->addAttributeToSelect('status');
$collection->addAttributeToSelect('visibility');
}
$this->setCollection($collection);
parent::_prepareCollection();
$this->getCollection()->addWebsiteNamesToResult();
return $this;
}

Add a column

protected function _prepareColumns()
{
$this->addColumn('short Desc',
array(
'header'=> Mage::helper('catalog')->__('Short Desc'),
'index' => 'short_description', //Change your index to qty 
'renderer'  => 'Mage_Adminhtml_Block_Catalog_Product_Renderer_Red',
));
}

Make class

Mage_Adminhtml_Block_Catalog_Product_Renderer_Red extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract


class Mage_Adminhtml_Block_Catalog_Product_Renderer_Red extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract
{
public function render(Varien_Object $row)
{
$value =  $row->getData($this->getColumn()->getIndex());
return '<span style="color:red;">'.$value.'</span>';
}
}