Bestseller Best Practice

[jtsehouseoc9d1]

Hello everyone! 👋

On Magento, the default Best Seller widget only shows the top 5 best selling products. That’s not enough for how we operate. We’re a wholesale jewellery distributor and we need to elevate our inventory planning by reviewing the top 25 best sellers per category — not just 5.

I’m looking for the best approach to achieve this. 

Has anyone built a custom report or module that can:

• pull best sellers by category
• expand the limit to top 25 (or more)
• preferably export into CSV for product review + forecasting

Would this be best approached by modifying the existing `Bestsellers Report Collection` / Sales Aggregated Tables? Or is it smarter to build a completely separate custom report with its own query logic?

Any recommendations on structure, modules, or extensions are super appreciated! 🙏

I know some people edit the widget limit, but I want to be able to *report* this data and use it for strategic planning — not just storefront display.

Thanks in advance! 💡

Excited to hear what other Magento experts suggest!

[iyerananth181b]

Hi @jtsehouseoc9d1 

Yes there is an advanced reporting module by Mirasvit. You can create multiple reports and insert widgets. You can export the report too.

Click here: https://shrt.gt.tc/mirasvit-advanced-reports (This link will redirect to original page)

Key points of the module:

• Realize the full potential of your data
• Analyze any data in your database
• Review 20 ready-to-use reports
• Create your own reports and columns
• Build custom dashboards
• Access your KPIs from any device
• Quick Access to Reports & Sharing New
• Google Sheets Integration New

Thank you.

[jtsehouseoc9d1]

Hi @iyerananth181b 

Thanks, this is very helpful. Do you know if it can exclude certain customers?

[iyerananth181b]

Hi @jtsehouseoc9d1 

Yes, there are a variety of filters and conditions you can apply and exclude certain customers in the reports too. Recently, we add custom metrics in the Mirasvit Reports.

There are duration selections like custom, 1 week, 1 month, 1 year, previous month, etc.

Thank You.

[iyerananth181b]

Hi, If you found my previous message helpful, feel free to click “Kudos” on it—it means a lot! Your support encourages me to keep sharing valuable insights with the community.

[hjose0910159d3]

That’s a great question I’d build a custom report rather than just tweaking the widget for more flexibility. Extend or query the Sales Aggregated tables to pull top-25 per category and add a CSV export for forecasting. It keeps reporting separate from storefront logic and makes future filters/automation easier.

[iyerananth181b]

Hello,

I am happy the community is discussing 

Thanks,

Anant