Magento 1 – How to Display Quantity Order for Product on Product Page

magento-1ordersproductreports

Trying to get this to work, it is not return anything 🙁

 $product = Mage::getResourceModel('reports/product_collection')
 ->addOrderedQty()
 ->addAttributeToFilter('sku', $_product->getSku());
 echo 'Already Bought '.(int)$product->ordered_qty; ?>

Best Answer

As part of the function addOrderedQty it will only add product information for the simple product types. What you could to is rewrite this function so that it does not add the following to the join conditions.

$adapter->quoteInto('(e.type_id NOT IN (?))', $compositeTypeIds),

Then this will give you the information about all product types. Once you have this information you can simply get the first item and get the ordered_qty.

$product->getFirstItem()->getOrderedQty();

Related Solutions

Magento – Show image of associated product selected, rather than configurable product on wishlist page

This what I used to get simple product image to show in wishlist instead of configurable product image. You need to get the simple/child product ID of associated product and then get its attributes, in this case image.

$item_s = Mage::getModel('wishlist/item')
     ->loadWithOptions($item->getId(), 'simple_product')
     ->getOptionsByCode();
$simple_product = $item_s['simple_product']->getData();
// Simple product id
$simple_product_id = $simple_product_data['product_id'];
// Load associated product attribute by id
$simple_product_attr = Mage::getModel('catalog/product')->load($simple_product_id);
// Get Image
$simple_product_img_url = $this->helper('catalog/image')->init($simple_product_attr ,'small_image');

echo $simple_product_img_url into the html img src attribute.

Magento 1.8 – Can’t Filter ‘reports/product_collection’ on Category

Try building your reports like this:

$category = Mage::getModel('catalog/category')->load({category_id});
$reports = Mage::getResourceModel('reports/product_collection')
             ->addAttributeToSelect('*')
             ->addOrderedQty()
             ->addCategoryFilter($category)
             ->setOrder('ordered_qty', 'desc');

I mean use addCategoryFilter after addOrderQty. in the method addOrderQty there is this line $this->getSelect()->reset() that seams to remove your category filter.

Best Answer

Related Solutions

Magento – Show image of associated product selected, rather than configurable product on wishlist page

Magento 1.8 – Can’t Filter ‘reports/product_collection’ on Category

Related Topic