Magento 2 - Bestseller product collection Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Magento 2 : Bestseller and most viewed product on homepageMagento 2 : get best seller product on daily basisCreate magento pagination in custom product collection inside phtml fileCan't get “products ordered” collection with configurable products included (top 10 products)Magento2 addViewsCount not working on Custom Product Attribute SetMagento 2 get out of stock products in collectionMagento2: How to update the product price programaticallyMagento 2: Product collection with filtersModel class not found in …/magento/framework/ObjectManager/Factory/AbstractFactory.php:93Overriding model collection issueGet product collection by store ID on Magento 2.2Magento2 REST API get all customers details

If 'B is more likely given A', then 'A is more likely given B'

Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system?

What do you call a plan that's an alternative plan in case your initial plan fails?

List *all* the tuples!

If a contract sometimes uses the wrong name, is it still valid?

When is phishing education going too far?

"Seemed to had" is it correct?

What is this single-engine low-wing propeller plane?

3 doors, three guards, one stone

Does accepting a pardon have any bearing on trying that person for the same crime in a sovereign jurisdiction?

Why was the term "discrete" used in discrete logarithm?

What LEGO pieces have "real-world" functionality?

What is the musical term for a note that continously plays through a melody?

How to draw this diagram using TikZ package?

Do you forfeit tax refunds/credits if you aren't required to and don't file by April 15?

How to bypass password on Windows XP account?

Why did the IBM 650 use bi-quinary?

Is the Standard Deduction better than Itemized when both are the same amount?

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

What causes the vertical darker bands in my photo?

What happens to sewage if there is no river near by?

Why does Python start at index -1 when indexing a list from the end?

Is it true that "carbohydrates are of no use for the basal metabolic need"?

Output the ŋarâþ crîþ alphabet song without using (m)any letters



Magento 2 - Bestseller product collection



Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Magento 2 : Bestseller and most viewed product on homepageMagento 2 : get best seller product on daily basisCreate magento pagination in custom product collection inside phtml fileCan't get “products ordered” collection with configurable products included (top 10 products)Magento2 addViewsCount not working on Custom Product Attribute SetMagento 2 get out of stock products in collectionMagento2: How to update the product price programaticallyMagento 2: Product collection with filtersModel class not found in …/magento/framework/ObjectManager/Factory/AbstractFactory.php:93Overriding model collection issueGet product collection by store ID on Magento 2.2Magento2 REST API get all customers details



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















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).










share|improve this question
















bumped to the homepage by Community 1 min ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • magento.stackexchange.com/questions/92157/… try this link.

    – Ravindrasinh Zala
    Nov 14 '17 at 4:15











  • magento.stackexchange.com/questions/156207/…

    – Ravindrasinh Zala
    Jan 29 '18 at 11:09

















1















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).










share|improve this question
















bumped to the homepage by Community 1 min ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • magento.stackexchange.com/questions/92157/… try this link.

    – Ravindrasinh Zala
    Nov 14 '17 at 4:15











  • magento.stackexchange.com/questions/156207/…

    – Ravindrasinh Zala
    Jan 29 '18 at 11:09













1












1








1


2






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).










share|improve this question
















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).







magento2 product collection best-seller






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 14 at 9:20









ABHISHEK TRIPATHI

2,1741828




2,1741828










asked Dec 20 '16 at 1:16









DominikDominik

63




63





bumped to the homepage by Community 1 min ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 1 min ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.














  • magento.stackexchange.com/questions/92157/… try this link.

    – Ravindrasinh Zala
    Nov 14 '17 at 4:15











  • magento.stackexchange.com/questions/156207/…

    – Ravindrasinh Zala
    Jan 29 '18 at 11:09

















  • magento.stackexchange.com/questions/92157/… try this link.

    – Ravindrasinh Zala
    Nov 14 '17 at 4:15











  • magento.stackexchange.com/questions/156207/…

    – Ravindrasinh Zala
    Jan 29 '18 at 11:09
















magento.stackexchange.com/questions/92157/… try this link.

– Ravindrasinh Zala
Nov 14 '17 at 4:15





magento.stackexchange.com/questions/92157/… try this link.

– Ravindrasinh Zala
Nov 14 '17 at 4:15













magento.stackexchange.com/questions/156207/…

– Ravindrasinh Zala
Jan 29 '18 at 11:09





magento.stackexchange.com/questions/156207/…

– Ravindrasinh Zala
Jan 29 '18 at 11:09










5 Answers
5






active

oldest

votes


















0














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;





share|improve this answer























  • What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

    – Dominik
    Dec 20 '16 at 10:10











  • I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

    – zed Blackbeard
    Jan 24 '17 at 12:37


















0














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());






share|improve this answer






























    0














    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());






    share|improve this answer






























      0














      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.






      share|improve this answer






























        0














        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;






        share|improve this answer























          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f151022%2fmagento-2-bestseller-product-collection%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          5 Answers
          5






          active

          oldest

          votes








          5 Answers
          5






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          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;





          share|improve this answer























          • What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

            – Dominik
            Dec 20 '16 at 10:10











          • I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

            – zed Blackbeard
            Jan 24 '17 at 12:37















          0














          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;





          share|improve this answer























          • What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

            – Dominik
            Dec 20 '16 at 10:10











          • I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

            – zed Blackbeard
            Jan 24 '17 at 12:37













          0












          0








          0







          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;





          share|improve this answer













          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;






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Dec 20 '16 at 2:45









          mrtuvnmrtuvn

          1,89411829




          1,89411829












          • What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

            – Dominik
            Dec 20 '16 at 10:10











          • I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

            – zed Blackbeard
            Jan 24 '17 at 12:37

















          • What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

            – Dominik
            Dec 20 '16 at 10:10











          • I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

            – zed Blackbeard
            Jan 24 '17 at 12:37
















          What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

          – Dominik
          Dec 20 '16 at 10:10





          What i understand it's working in own module, it's doesn't work in theme custom block. I need add some referencje/attributes to this block?

          – Dominik
          Dec 20 '16 at 10:10













          I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

          – zed Blackbeard
          Jan 24 '17 at 12:37





          I think, Magento 2 using default sales_bestsellers_aggregated_yearly table to get bestseller product, How can get best seller products using sales_bestsellers_aggregated_daily table.

          – zed Blackbeard
          Jan 24 '17 at 12:37













          0














          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());






          share|improve this answer



























            0














            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());






            share|improve this answer

























              0












              0








              0







              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());






              share|improve this answer













              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());







              share|improve this answer












              share|improve this answer



              share|improve this answer










              answered Dec 18 '17 at 7:11









              Kushal DaniKushal Dani

              900223




              900223





















                  0














                  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());






                  share|improve this answer



























                    0














                    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());






                    share|improve this answer

























                      0












                      0








                      0







                      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());






                      share|improve this answer













                      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());







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      answered Jan 29 '18 at 11:09









                      Ravindrasinh ZalaRavindrasinh Zala

                      1,281322




                      1,281322





















                          0














                          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.






                          share|improve this answer



























                            0














                            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.






                            share|improve this answer

























                              0












                              0








                              0







                              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.






                              share|improve this answer













                              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.







                              share|improve this answer












                              share|improve this answer



                              share|improve this answer










                              answered Aug 13 '18 at 6:33









                              Rasik MiyaniRasik Miyani

                              648




                              648





















                                  0














                                  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;






                                  share|improve this answer



























                                    0














                                    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;






                                    share|improve this answer

























                                      0












                                      0








                                      0







                                      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;






                                      share|improve this answer













                                      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;







                                      share|improve this answer












                                      share|improve this answer



                                      share|improve this answer










                                      answered Oct 15 '18 at 3:46









                                      Vu Tran KienVu Tran Kien

                                      3521224




                                      3521224



























                                          draft saved

                                          draft discarded
















































                                          Thanks for contributing an answer to Magento Stack Exchange!


                                          • Please be sure to answer the question. Provide details and share your research!

                                          But avoid


                                          • Asking for help, clarification, or responding to other answers.

                                          • Making statements based on opinion; back them up with references or personal experience.

                                          To learn more, see our tips on writing great answers.




                                          draft saved


                                          draft discarded














                                          StackExchange.ready(
                                          function ()
                                          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f151022%2fmagento-2-bestseller-product-collection%23new-answer', 'question_page');

                                          );

                                          Post as a guest















                                          Required, but never shown





















































                                          Required, but never shown














                                          Required, but never shown












                                          Required, but never shown







                                          Required, but never shown

































                                          Required, but never shown














                                          Required, but never shown












                                          Required, but never shown







                                          Required, but never shown







                                          Popular posts from this blog

                                          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

                                          Magento 2 disable Secret Key on URL's from terminal The Next CEO of Stack OverflowMagento 2 Shortcut/GUI tool to perform commandline tasks for windowsIn menu add configuration linkMagento oAuth : Generating access token and access secretMagento 2 security key issue in Third-Party API redirect URIPublic actions in admin controllersHow to Disable Cache in Custom WidgetURL Key not changing in Magento 2Product URL Key gets deleted when importing custom options - Magento 2Problem with reindex terminalMagento 2 - bin/magento Commands not working in Cpanel Terminal

                                          Aasi (pallopeli) Navigointivalikko