[Skip to main content](#vessel-content)

#   Report for Top 50 customer

##

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

10 years 1 month ago [\#252508](#252508) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  *[Report for Top 50 customer](/forum/36-reports-statistics/886928-report-for-top-50-customer#252508 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.4.45  Any where to show top 50 customer in the dashboard?  We can currently find the top customer in the dash board, would like to show it as 50")* was created by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")*

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.4.45

Any where to show top 50 customer in the dashboard?

We can currently find the top customer in the dash board, would like to show it as 50

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODY5MjgtcmVwb3J0LWZvci10b3AtNTAtY3VzdG9tZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86555
- Thank you received: 14304
-
-

10 years 4 weeks ago [\#252544](#252544) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report for Top 50 customer](/forum/36-reports-statistics/886928-report-for-top-50-customer#252544 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.4.45  Any where to show top 50 customer in the dashboard?  We can currently find the top customer in the dash board, would like to show it as 50")*

Hi,

You can do that by creating a new report via the menu Orders&gt;Reports and configure it like that:
[ take.ms/eYVuE](http://take.ms/eYVuE)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODY5MjgtcmVwb3J0LWZvci10b3AtNTAtY3VzdG9tZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

10 years 3 weeks ago [\#253109](#253109) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report for Top 50 customer](/forum/36-reports-statistics/886928-report-for-top-50-customer#253109 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.4.45  Any where to show top 50 customer in the dashboard?  We can currently find the top customer in the dash board, would like to show it as 50")*

We found some bug and error figure on this report

[ ![ShutterFashion-Administration-Report.png](/forum/attachment/34138) ](/forum/attachment/34138 "...ion-Report.png")

referring to this best order this month report, we can know that xinshi126@gmail.com have at least 2 order with 700+ total

but when we calling out best customer this month report, we found it do not exist
[ ![FireShotCapture31-ShutterFashion-Admi&#95;-http&#95;&#95;&#95;shutterfashion.com.my&#95;administrator&#95;index.php.png](/forum/attachment/34139) ](/forum/attachment/34139 "...&#95;index.php.png")

Some serious error while we select period for best customer report, it work well only when select all time

- [ ![ShutterFashion-Administration-Report.png](/forum/attachment/34138) ](/forum/attachment/34138 "...ion-Report.png") [ ](/forum/attachment/34138?download=1 "...ion-Report.png")
- [ ![FireShotCapture31-ShutterFashion-Admi&#95;-http&#95;&#95;&#95;shutterfashion.com.my&#95;administrator&#95;index.php.png](/forum/attachment/34139) ](/forum/attachment/34139 "...&#95;index.php.png") [ ](/forum/attachment/34139?download=1 "...&#95;index.php.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODY5MjgtcmVwb3J0LWZvci10b3AtNTAtY3VzdG9tZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86555
- Thank you received: 14304
-
-

10 years 3 weeks ago [\#253199](#253199) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report for Top 50 customer](/forum/36-reports-statistics/886928-report-for-top-50-customer#253199 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.4.45  Any where to show top 50 customer in the dashboard?  We can currently find the top customer in the dash board, would like to show it as 50")*

Hi,

Could you turn on the "debug mode" of the Joomla configuration and try again to display that report. There, at the bottom of the page, in the list of MySQL queries of the debug data, could you search the big query done on the table hikashop_order and provide the information about it (and the query itself) ? That would greatly help understand the situation.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODY5MjgtcmVwb3J0LWZvci10b3AtNTAtY3VzdG9tZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.052 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
