How to fetch 5 bestsellers products programmatically?

[mydataprovider]

Mage::getResourceModel(‘reports/product_collection’)
->addOrderedQty()
->addAttributeToSelect(‘*’)
->setPage(1, 5)
->load();

View more threads in the same category:

• How to choose the right marketing team for a crypto project?
• What's the go with online betting in Australia these days?
• relax
• A mate of mine from
• Painted Hand Casino
• Where can I find character skins for Counter-Strike?
• Hitori - Play online
• What's the best way to use ChatGPT for content creation?
• Relax
• Webcam sites featuring models

[PeterJ]

You can get it by this simple line

$_productCollection = Mage::getResourceModel('sales/report_bestsellers_collection')
        ->setModel('catalog/product')
    ; 

Or you may look at this extension

http://www.magentocommerce.com/magen...extension.html

Maybe this article can help you too

http://inchoo.net/magento/bestseller...ts-in-magento/

[mydataprovider]

Thank you for help peter

[knowband.plugins]

$storeId = (int) Mage::app()->getStore()->getId();

// Date
$date = new Zend_Date();
$toDate = $date->setDay(1)->getDate()->get('Y-MM-DD');
$fromDate = $date->subMonth(1)->getDate()->get('Y-MM-DD');

$collection = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(Mage::getSingleton('catalo g/config')->getProductAttributes())
->addStoreFilter()
->addPriceData()
->addTaxPercents()
->addUrlRewrite()
->setPageSize(5);

$collection->getSelect()
->joinLeft(
array('aggregation' => $collection->getResource()->getTable('sales/bestsellers_aggregated_monthly')),
"e.entity_id = aggregation.product_id AND aggregation.store_id={$storeId} AND aggregation.period BETWEEN '{$fromDate}' AND '{$toDate}'",
array('SUM(aggregation.qty_ordered) AS sold_quantity')
)
->group('e.entity_id')
->order(array('sold_quantity DESC', 'e.created_at'));

Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection );
$collection = $collection->getData();

$collection will give 5 bestseller products.




Regards,

Knowband Plugins | Buy Best Magento Extensions

[adem]

<!--?php
Mega::getResourceModel('reports/product_collection')-->addOrderedQty()->addAttributeToSelect('*')->setPage(1,5)->load();
?>