Questions tagged [best-seller]
The best-seller tag has no usage guidance.
71
questions
0
votes
1answer
35 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
0answers
24 views
Magento2 - Widget not showing up on frontend category page
We have a dozen or so category pages. Each category page has a subcategories widget and a bestsellers widget that shows the 4 bestselling products for that category.
I created a new category, "...
0
votes
0answers
39 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?
...
0
votes
0answers
22 views
Magento 1.9: Homepage bestseller products redirect on image click
I have the bestsellers on my homepage. However, If I click on the product image it does nothing. It only redirects If I click on the product title under the image.
I want it to redirect if I click in ...
0
votes
1answer
37 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!!
1
vote
1answer
41 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
235 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..!
0
votes
0answers
70 views
How to show Bestseller products with brand(Manufactuerer) wise Magento 2
First I have refreshed the reports on best sellers on the admin panel it's giving me updated data on bestseller tables.
I get all the products id's of the best seller but the issue is
...
1
vote
1answer
85 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
2answers
80 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
0answers
11 views
Facing issue with from date and to date with Central Standard Time (America/Chicago)
I am facing an issue with from date and to date in reports with Central Standard Time (America/Chicago) Locale.
I am trying to get the bestseller report after selecting from and to date when I click ...
4
votes
0answers
135 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
3answers
267 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
701 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
226 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
20 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 ...
2
votes
2answers
263 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
4answers
1k 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
204 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 ...
5
votes
1answer
2k 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
373 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
479 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
1answer
174 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
22 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
330 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
0
votes
1answer
28 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
98 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
532 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
35 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
250 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
30 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
196 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
58 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
211 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
442 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
398 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
65 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
173 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?
3
votes
1answer
4k 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 ...
6
votes
1answer
7k 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?
2
votes
0answers
685 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
297 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
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 $...
1
vote
0answers
280 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
72 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
3k 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
3k 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
243 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::...
