Archive for July, 2011
Magento add Bestseller products by date range
Here is how to get a collection of products best sold in a given date range (could be daily, monthly, weekly, etc…) <ul> <?php $from = date("Y-m-d H:i:s", (time()-2592000)); $to = date("Y-m-d H:i:s", time()); $_productCollection = Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect('*') ->addOrderedQty($from, $to, true) ->addAttributeToFilter('status', 1) ->setOrder('ordered_qty', 'desc') ->getSelect()->limit(10)->query(); foreach ( $_productCollection as $prod ) : $_product = [...]
