I am get bestseller product using below code but it will not display best seller products of latest month, It will display bestseller product from starting.
Can anyone tell me how can I filter best seller product.
Thanks In Advance.
<?php
$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('month');
foreach ($collection as $item) {
print_r($item->getData());
}
In short I want to implement below query logic.
SELECT * FROM
sales_bestsellers_aggregated_monthly
ORDER BYsales_bestsellers_aggregated_monthly
.id
DESC