Questions tagged [best-seller]
The best-seller tag has no usage guidance.
0
votes
2answers
32 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
87 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
61 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
65 views
Magento2: get latest Best seller collection
I am fetching Bestsellers like this:
protected $_collectionFactory;
\Magento\Sales\Model\ResourceModel\Report\Bestsellers\CollectionFactory $collectionFactory,
$this->_collectionFactory = $...
0
votes
0answers
37 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
17 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
47 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
19 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
72 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-&...
0
votes
0answers
11 views
Mageplaza bestseller not translating in Spanish store view
I have added mageplaza bestseller in my store but the slider not translated in Spanish store view. when I clicking in a product it redirect to default store pdp instead of Spanish pdP
https://www....
1
vote
1answer
46 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
228 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
24 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
42 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
26 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
101 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
0answers
17 views
How to Filter bestselling products according to Store_id in magento 2.2.0?
I want to filter bestselling products according to its store_id. Below is the code that I have user.
<?php
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection =...
0
votes
1answer
16 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
76 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
37 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
135 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
227 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
242 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
55 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
127 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 ...
6
votes
1answer
4k 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
426 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
256 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
122 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
952 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 ...
4
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
...
1
vote
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
135 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
60 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
161 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
710 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
2k 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
165 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
464 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
283 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
3k 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
241 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 ...
0
votes
0answers
112 views
How to exclude an item from the best-sellers magento
I have a free gift item but it gets into the best sellers category. is there an easy way to exclude it for getting into the best sellers?
0
votes
2answers
172 views
Bestseller report in admin display products twice
I am facing a strange issue.
Bestseller yearly report in admin is showing product twice for the year in "to" field.
If I am changing the year from 2012 to 2013 then issue is for product listing for ...
1
vote
1answer
172 views
Best sellers and Flat Catalog?
I have installed Magento and used a custom theme. I want to use a Best sellers widget on my homepage, but it doesn't work with Flat Catalog I have enabled on categories and products. As I understand ...
