Number of Purchased Item on Each Product

Question

I want to display the number of purchased item/s on a certain product. I did use this code:

$resultQuantity = $this->getQuantityPurchase($_product);
$resultQuantity[0];

But it displays nothing. What should I do? Could I use the Product ID for this?

Answer 1

$id = 123; // enter your product ID here
$product = Mage::getResourceModel('reports/product_collection')
    ->addOrderedQty()
    ->addAttributeToFilter('sku', $produt->getSku())
    ->setOrder('ordered_qty', 'desc')
    ->getFirstItem();

echo (int)$product->ordered_qty;

Answer 2

You can do this by getting the product sold collection

/** @var Mage_Report_Model_Mysql4_Product_Sold_Collection **/
$report = Mage::getResourceModel('reports/product_sold_collection');

You can set a date range or other criteria if you want. Once you have your collection just iterate over it, something like this:

foreach ($report AS $product) {
echo $product->getOrderedQty();}