Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [best-seller]

The tag has no usage guidance.

1
vote
3answers
34 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?
1
vote
1answer
41 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
54 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
14 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
4answers
110 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....
0
votes
2answers
43 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 ...
3
votes
1answer
302 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 = $...
1
vote
2answers
83 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') ...
0
votes
2answers
156 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 = $...
0
votes
0answers
61 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 $...
0
votes
1answer
19 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
0answers
79 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 hoe page. Thanks
0
votes
1answer
24 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 ...
0
votes
0answers
81 views

What is the type of 'Magento\Sales\Model\ResourceModel\Report\Bestsellers\Collection'

What is the return type of the following function public function getBestseller(){ $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $productCollection = $objectManager-&...
1
vote
1answer
60 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-&...
1
vote
1answer
294 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
0answers
25 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
43 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 ...
0
votes
0answers
27 views

Adding products back into Featured, Bestseller, and Popular widgets.

I am on an instance of Magento 1.9.3.7. I am wanting to add products back into my featured, bestseller, and popular widgets. Is there an easy way to do this? Thank you. :)
1
vote
1answer
124 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
19 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 ...
0
votes
1answer
98 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
39 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
149 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
286 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 ...
0
votes
1answer
275 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\...
0
votes
1answer
59 views

How to create Bestselller product and Related product and call it on the cms page in magento 2.2.0

I want to display Related products and BestSeller products on two different pages.
1
vote
1answer
136 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?
2
votes
1answer
2k views

Magento 2: insert a “Bestsellers” widget via the Magento admin

I am working on a Magento 2.1.7 shop. To achieve this, I have created a child-theme of Magento Blank. On the home page, I want to insert a "Bestsellers" widget via the Magento admin, like the one ...
5
votes
1answer
5k views

How to get Best Selling Product Collection in Magento 2 using Object Manager

How can I get "Monthly Best selling product" in Magento 2?
1
vote
0answers
451 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(). ...
1
vote
0answers
266 views

How to show the bestsellers products of only Completed Orders in the dashboard

I want to show BestSellers Products of only Completed orders in the Dashboard. This is the file that I am editing file path : Mage/Adminhtml/Block/Dashboard/Tab/Products/Ordered.php Code : class ...
1
vote
1answer
1k 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 $...
1
vote
0answers
132 views

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

I tried to create override block but it is not working is there any proper way or link from where I can get suggestion
0
votes
1answer
1k views

Display bestsellers products on products catalog page

I am displaying bestsellers on a blank layout right now, but I want to use the same layout and template as in product catalog, to be able to switch between grid and layout mode, apply filters, etc. Is ...
0
votes
1answer
67 views

Product attributes not loading in home page. Maybe Permissions? I really don't know

I was trying to reboot the index with the shell/indexer.php script (because my new categories are not displaying on my megamenu) and after using this script my products are not showing some custom ...
3
votes
2answers
2k 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 ...
4
votes
5answers
2k 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
1answer
153 views

All best seller getting as per categorywise. Using Magento Ver 1.9

I did code as per instruction. Make query on app\code\local\Mage\Catalog\Block\Product\bestseller.php: parent::__construct(); $storeId = Mage::app()->getStore()->getId(); $products = Mage::...
0
votes
1answer
62 views

How can I find after how many sales a product becomes best seller?

It is kind a silly question (I know), but where can I find after how many sales a product becomes a Bestseller?
3
votes
4answers
13k views

how to display best selling products on homepage in magento

I need to show best selling product on product view page. I tried with the code: $storeId = Mage::app()->getStore()->getId(); $_productCollection = Mage::getResourceModel('reports/...
1
vote
0answers
170 views

Target parent product on bestseller query if best selling product is a child

How would I get the top 10 bestsellers like targeting the parent if the best seller is a child product. I use the following code to get the bestsellers public function getBestsellerCollection() ...
0
votes
0answers
716 views

Display Best Selling Products

I want replacement of the following code in Magento 2.x class Mage_Catalog_Block_Product_Bestseller extends Mage_Catalog_Block_Product_Abstract{ public function __construct(){ parent::...
6
votes
1answer
3k 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 ...
0
votes
1answer
188 views

bestseller how is it determined? Can it be based on number of orders instead of quantity? [closed]

I just want to know how bestseller is determined. Is it simply based on the quantity of a product ordered? Can it be based on how many orders you have for the product? For example Product 1 has a ...
2
votes
3answers
1k 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
2answers
478 views

Block not working after Magento update

I recently upgraded from Magento 1.5.1 to Magento 1.9.2.3 and noticed that a block on my webshop doesn't work anymore. I've got a static block called "Bestsellers" and in that block I have this peace ...
0
votes
1answer
293 views

Invalid use of table with UNION

I am getting error Invalid use of table with UNION while I am trying to export the Bestsellers report in admin. Below is the exception report content. a:5:{i:0;s:31:"Invalid use of table with UNION";...
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->...
2
votes
0answers
243 views

Filter product collection to include only one parent configurable product

So I'm trying to build a 'Bestseller list' on our homepage. Currently the bestseller list is only showing the top selling simple products. All these simple products are child products of different ...