I’m just learning Magento and its Web Services API for a new job. I’ve just managed to build some basic PHP scripts fetching products in specific categories. I now need to fetch the best-selling products, but am struggling to find good documentation on this. Any help, pointers, sample code or anything else really w开发者_JS百科ould be much appreciated...
Thanks,
Tom
I believe there's no way to do this with the Web Services API. However within Magento's own PHP you can get the most sold products with the following:
$bestselling_products = Mage::getResourceModel('reports/product_collection')
->addAttributeToSelect('*')
->setStoreId(1)
->addOrderedQty($from, $today)
->addAttributeToFilter('visibility', $visibility)
->addAttributeToFilter('status', 1)
->setOrder('ordered_qty', desc);
I think there is not a direct way to do that with the API. Maybe you can do so by retrieving all the sales orders, and find which of the products have been the most ordered.
A quick way would also be to extend the api to add a method which will do what you want.
精彩评论