Questions tagged [best-seller]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
4answers
4k views

Magento 2 : How to get the best seller product collection?

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 = $...
0
votes
1answer
13 views

Sorting by “Best selling” not working for configurable products M2.4.x (but for simple products)

the sorting by "Best selling" is not working for configurable products in M2.4.x Its well working for categories with simple products. When mixed category, first the best-selling simple ...
1
vote
2answers
4k views

Add Category filter in best seller product Collection

I get best seller product for all category using below code public function __construct(\Magento\Sales\Model\ResourceModel\Report\Bestsellers\CollectionFactory $collectionFactory ) { $this->...
0
votes
2answers
429 views

Invalid template file: 'Magehit_Bestsellerproducts::html/bestsellerblock.phtml'

After upgrading to Magento 2.2.0, the Magehit bestseller module is causing the following exception. Can someone please help solving it? Thanks 1 exception(s): Exception #0 (Magento\Framework\...
3
votes
1answer
833 views

How to sort products by bestsellers (e.g. by sales) in Magento 2

these days I've faced a problem: I needed to to sort products by sales. So, first of all I decided to add this field to collection of products and the order it using method $collection->setOrder(). ...
0
votes
0answers
12 views

How to get the best selling products in a category and sort them from best selling to least selling?

How to get the best selling products in a category and sort them from best selling to least selling? I try get best selling collection like: use Magento\Store\Model\StoreManagerInterface; use Magento\...
1
vote
0answers
408 views

How to sort product by best seller Magento 2.1 without changing in core file [closed]

I want to get product Collection sort by bestseller product. How to achieve this ?
1
vote
0answers
24 views

How to get lifetime best seller products

I am creating an API for getting best seller products. There are a lot answer on community which answering for get best seller on monthly/yearly basis. I want to get lifetime bestselling product just ...
0
votes
0answers
68 views

Magento 2 - How to get new and best sellers products data using product graphql?

I want new products and bestsellers product data in product graphql. and also product review and rating. Does anyone have an idea?
0
votes
0answers
14 views

How can I display best sellers top 4 on catalog view by default in grid display with the option to see all the products?

I have been tasked to display the top 4 best selling products as a default view in Magento. After clicking a button the user should then be able to see the rest of the products. Bestsellers should be ...
7
votes
1answer
5k views

How can I get best seller product for each category in magento 2?

I have a main category "Computer" with 3 sub categories: Laptop Storage Software I know how can I get a sub category. But I need best the selling product for each category, for example: Laptop ...
2
votes
2answers
398 views

Best seller sort by option in Magento 2.3.4

I am trying to implement Best seller sort by in category list page. Followed below link, but that is not working in Magento 2.3.4. Magento 2 add Sort By Best Sellers Option on category products ...
0
votes
1answer
88 views

How to filter bestseller collection with a product attribute

You can addAttributeToFilter for product collection; $this->_productCollectionFactory->create()->addAttributeToFilter('att_x', ['eq', $att_x_value]); How can we do this with bestseller ...
0
votes
1answer
56 views

How I can Get Best Seller Products also all catalog products in grid Magento2.3.3?

I want to Get bestseller report in Product first show all filter getting then rest of it in grid. I want in magento2.3.x version in. Any one have idea? Thanks in advance!!
0
votes
0answers
62 views

How to get top 3 most purchased category list in magento 2?

There are modules that get top best selling products list but I want to get the topmost purchased categories list instead of products. Please help me with this. Is there any free module available? ...
1
vote
1answer
49 views

Magento 1.9 - CMS page products list error

Display Bestsellers for Specific Magento Categories in CMS page. Following tutorial, https://mercytapscott.com/display-bestsellers-for-specific-magento-categories/ Added following line into cms ...
2
votes
2answers
696 views

Magento 2: Change the bestseller report count more than 5 items

How to change the bestseller report items number more than 5 items Magento 2? Thank In Advance..!
1
vote
1answer
213 views

How Best seller tables gets populated Magento 2?

There are 3 tables related to bestseller in Magento 2 sales_bestsellers_aggregated_daily sales_bestsellers_aggregated_monthly sales_bestsellers_aggregated_yearly How and when these tables get ...
0
votes
1answer
276 views

Best seller collection filter magento2

I am trying to filter Best seller product collection like below. Seems the setOrder is not working. class BestSeller extends \Magento\Framework\View\Element\Template { protected $...
1
vote
1answer
2k views

Magento 2 Best Seller Collection Limit

Magento 2 Best Seller Collection: <?php namespace MPS\Allproduct\Block\Index; class Index extends \Magento\Framework\View\Element\Template { protected $_coreRegistry = null; protected $...
0
votes
2answers
310 views

Magento 2.3.2: Sort by Bestselling Minimal results

I am using custom code to implement sort by Best selling on the category page, I have created an around plugin for <type name="Magento\Catalog\Block\Product\ProductList\Toolbar"> <...
0
votes
1answer
516 views

How to get and show the best selling products in magento 2

I wish to show best selling products in homepage.Please provide me a solution to get best selling products and display in home page. Thanks
5
votes
0answers
172 views

Magento2 : Display Bestselling products for last 7 days

I want to display bestselling products for time inetrval 7 days. We can set period by day, month and year $bestSellers = $this->_bestSellersCollectionFactory->create() ->...
2
votes
2answers
475 views

Magento 2 REST API: Create an API to fetch recently viewed products

I need to create an API for fetching all the recently viewed products. Any suggestions on how to do it?
2
votes
1answer
1k views

Magento2: How to get Bestseller products collection by category ids(subcategories)

I need to get Bestseller products collection by category ids(subcategories) Thanks
1
vote
1answer
392 views

Magento 2 - How to get recent month's best seller products?

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 ...
1
vote
0answers
32 views

Bestsellers of current month rest api

I need to get bestsellers products for the current month. I use Magento\Sales\Model\ResourceModel\Report\Bestsellers\Collection, but I get bestsellers for all months, I used the following code to get ...
0
votes
2answers
680 views

Magento 2: get latest Bestseller collection

I am fetching Bestsellers like this: protected $_collectionFactory; \Magento\Sales\Model\ResourceModel\Report\Bestsellers\CollectionFactory $collectionFactory, $this->_collectionFactory = $...
4
votes
5answers
4k views

Magento 2 - Bestseller product collection

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: $...
0
votes
4answers
2k views

How to get only configurable products as a bestseller in Magento 2?

My site contain only configurable products and I want to display bestseller products. I know there are many extension available for bestseller products but i want to display only configurable products....
1
vote
1answer
741 views

How to ignore not avilable products from best seller product collection?

app/code/Test/Demo/Block/Widget/Bestsellerdproduct.php namespace Test\Demo\Block\Widget; class Bestsellerdproduct extends \Magento\Framework\View\Element\Template implements \Magento\Widget\Block\...
0
votes
2answers
344 views

Magento2 : What is the default table used by Bestsellers in the admin?

In the database, I know that there are 3 aggregated bestseller tables sales_bestsellers_aggregated_daily, sales_bestsellers_aggregated_monthly, sales_bestsellers_aggregated_yearly but which ...
1
vote
2answers
507 views

Get best seller products

I'm trying to get in the home page 12 bestseller products with this code: $_productCollection = Mage::getResourceModel('reports/product_collection') ...
6
votes
1answer
8k views
0
votes
1answer
23 views

Best Sellers Report

I am having issues where not all items are showing the bestseller block in the admin dashboard. I have narrowed this down to the sales_order_item table. If a product is bought through the frontend ...
0
votes
1answer
32 views

Bestseller Products Collection Not coming zero for current month and day even it is using old collection magento 2?

Here Bestseller Products Collection Not coming zero for current month or day because for this month or day we don't have any orders even it is using old records and showing some number of data in ...
1
vote
1answer
420 views

Can't get “products ordered” collection with configurable products included (top 10 products)

I'm trying to develop a module to display top 10 bestseller products for each category. (I'll use it on home page for overall top 10 products too) I have bundle, configurable and simple products in ...
1
vote
1answer
115 views

category id check

I have passing category id through xml i'm trying to check it in block file.but it did not work foreach ($productCollection as $product) { // get product id $productIds[]=$this-&...
0
votes
0answers
40 views

Magento 2 : Best Seller are not updated for imported order

I have import orders and generate shipment and invoice, But our Statistics are not updated like best seller, Most Viewed, Order Collection, Dashboard Graph. I have already tried with cron and refresh ...
1
vote
0answers
45 views

How to create best seller page in Magento 2.2

I am trying to create a page where all best sellers products should be displayed and it needs to look like magento's default category page(filters on the left and product grid/list on the right). I ...
1
vote
1answer
299 views

How can i get viewed product also viewed other product list and also bought product list?

I am using magento ver 1.9.2.3 , how can i get viewed product also viewed product list and also bought product based on my customer list using available options?
0
votes
1answer
221 views

How to set the order of the query as descending

I have created a query that would allow me to sort my products based on the quantity they have been ordered. But when I print the query, the quantity ordered is coming in Ascending order. I want to ...
0
votes
1answer
32 views

Bestselling products data is not gettting saved in its Table.

I am using magento 2.2.0 and I am trying to fetch bestselling products, but the problem is that there is not even a single product in the sales_bestsellers_aggregated_monthly table. As I purchased ...
3
votes
2answers
4k views

Magento 2 : get best seller product on daily basis

There are some tables related to bestseller in Magento 2 and it is using following tables to get best product collection. sales_bestsellers_aggregated_daily sales_bestsellers_aggregated_monthly ...
0
votes
1answer
86 views

Bestselling Product link in Magento 2.2.0

I have successfully listed the best selling products, but how should I give it a link to open the same product in the product detail page whenever we click on it. The same product should open at the ...
0
votes
1answer
244 views

Best Seller Logic - Magento 2

How does Magento 2 pick up the best seller products? What is the logic behind that? (I have the code , but want to know the logic)
0
votes
2answers
512 views

How to display “customer based” best sellers list?

I would like to build a custom module, for Magento 2, that will displays a list of products, from the logged in customer's, order history, and sort it by the best selling products. (e.g. most ...
4
votes
3answers
2k views

When 'sales_bestsellers_aggregated_daily' table will get update data?

In my local 'sales_bestsellers_aggregated_daily' table is empty, But I need to get the best selling products from this table. I made an order and created shipments also. But this table is empty. Is ...
0
votes
1answer
65 views
1
vote
1answer
194 views

How to get bestseller in left column layout in Magento 2.2.0?

I want to display bestseller products just below the compare product list. How can I do that?