Report for Top 50 customer

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
8 years 1 month ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 1 month ago #252544

Hi,

You can do that by creating a new report via the menu Orders>Reports and configure it like that:
take.ms/eYVuE

Please Log in or Create an account to join the conversation.

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
8 years 1 month ago #253109

We found some bug and error figure on this report



referring to this best order this month report, we can know that This email address is being protected from spambots. You need JavaScript enabled to view it. have at least 2 order with 700+ total

but when we calling out best customer this month report, we found it do not exist


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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 1 month ago #253199

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 or Create an account to join the conversation.

Time to create page: 0.070 seconds
Powered by Kunena Forum