Questions tagged [best-seller]
The best-seller tag has no usage guidance.
60
questions
4
votes
1answer
50 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
46 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
56 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
79 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
15 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
199 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
51 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
568 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
111 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
216 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
86 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
21 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
105 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
26 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
89 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
69 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
325 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
26 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 ...
1
vote
1answer
142 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
21 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
122 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
44 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
164 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
311 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
317 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
61 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
144 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
3k 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?
2
votes
0answers
494 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
277 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
152 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
68 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
164 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
65 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
14k 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
175 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
723 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
200 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
485 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
304 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
247 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 ...
