For one of my project I needed to display the total quantities ordered in Products lifetime in product view page.
Here is the code
$product_id = 1; // the id of the product for which the quantities is required $current_storeid = Mage::app()->getStore()->getId();//get current store id, used for filtering the collection $productCollection = Mage::getResourceModel('reports/product_collection') ->addOrderedQty() ->addAttributeToSelect(array('name')) ->addAttributeToFilter('entity_id',array('eq', $product_id)) ->setStoreId($current_storeid) ->addStoreFilter($current_storeid) ->setOrder('ordered_qty'); foreach ($productCollection as $_product): echo 'Product Name: '.$_product->getName().' Quantities Ordered: '.intval($_product->getOrderedQty()).'<br/>'; endforeach; //end
Hope this is helpful.