Dfrnhjy

I am trying to get bestseller products on homepage using product collection in Magento 2.
I only got Most Viewed product listing (?) and I am not getting bestseller products.

Here is my code:

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$productCollection = $objectManager->create('MagentoReportsModelResourceModelProductCollectionFactory');
$collection = $productCollection->create()
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('status','1')
 ->setPageSize(8)
 ->load();

Can someone tell me which ResourceModel I need to load? I tried with:

MagentoSalesModelResourceModelReportBestsellersCollectionFactory`enter code here`

But didn't helped (I got some error with that code and that resource).

M2 have some tables related to bestsell sales_bestsellers_aggregated_daily
sales_bestsellers_aggregated_monthly sales_bestsellers_aggregated_yearly

In code you can filter bestsell by method joinField
you can do this

$storeId = $this->_storeManager->getStore(true)->getId();
/** @var $collection MagentoCatalogModelResourceModelProductCollection */
$collection = $this->productCollectionFactory->create()->addAttributeToSelect('*');
$collection->addStoreFilter()
 ->joinField(
 'qty_ordered',
 'sales_bestsellers_aggregated_monthly',
 'qty_ordered',
 'product_id=entity_id',
 'at_qty_ordered.store_id='.$storeId,
 'at_qty_ordered.qty_ordered > 0',
 'left'
 )->setPageSize(8)->setCurPage(1);
return $collection;

You can try this code in that you can also filter the product by Month,year or day .

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$productCollection = $objectManager->create('MagentoReportsModelResourceModelReportCollectionFactory'); 
$collection = $productCollection->create('MagentoSalesModelResourceModelReportBestsellersCollection'); 

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

foreach ($collection as $item) 
 print_r($item->getData());

Try this.

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$productCollection = $objectManager->create('MagentoReportsModelResourceModelReportCollectionFactory'); 
$collection = $productCollection->create('MagentoSalesModelResourceModelReportBestsellersCollection'); 

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

foreach ($collection as $item) 
 print_r($item->getData());

U can used this code and get the Bestseller Product,

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$productCollection = $objectManager->create('MagentoReportsModelResourceModelReportCollectionFactory'); 
$collection = $productCollection->create('MagentoSalesModelResourceModelReportBestsellersCollection'); 

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

foreach ($collection as $item) 
 print_r($item->getData());

after used this code ,
In order for best selling products to show up in your magento website go to Reports > Refresh Statistics select all items > "Refresh Lifetime Statistics" -> submit.

Try code below :

protected $_collectionFactory;

public function __construct(
 MagentoBackendBlockTemplateContext $context,
 MagentoSalesModelResourceModelReportBestsellersCollectionFactory $collectionFactory,
 array $data = []
) 
 $this->_collectionFactory = $collectionFactory;
 parent::__construct($context, $data);

public function getBestSellerData()
 $bestSellerProdcutCollection = $this->_collectionFactory->create()
 ->setModel('MagentoCatalogModelProduct')
 ->setPeriod('month'); //you can add period daily,yearly
 //->setPeriod('year');
 //->setPeriod('day');

 return $bestSellerProdcutCollection;