4

I'm trying to get Best Seller Product collection using below code, but it will not display any data

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create('\Magento\Sales\Model\ResourceModel\Report\Bestsellers\CollectionFactory');
$collection = $productCollection->create()->setModel('Magento\Catalog\Model\Product')->setPeriod('yearly');

How to get Best Seller Product collection ?

  • it might not working because you have set "yearly" instead of "year", please check my ans for more information. – Aasim Goriya Feb 13 at 9:51
6

Please try this code to get best seller product collections using objectManager.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create('Magento\Reports\Model\ResourceModel\Report\Collection\Factory'); 
$collection = $productCollection->create('Magento\Sales\Model\ResourceModel\Report\Bestsellers\Collection'); 

$collection->setPeriod('year');
//$collection->setPeriod('month');
//$collection->setPeriod('day');

foreach ($collection as $item) {
    print_r($item->getData());
}
  • Hi Aasim Goriya I have used same logic in my custom block but it is displaying empty records (those are not available currently at admin end products grid) could you please advise? – NIPPU Apr 9 at 10:43
  • Exclude empty records using filters at code level – NIPPU Apr 9 at 10:44
  • @AssimGoriya, How can i get latest month's best seller product? any Idea? – Sanjay Gohil Apr 26 at 10:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.