Report for Top 50 customer

-- 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>Reports and configure it like that:
take.ms/eYVuE

We found some bug and error figure on this report



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


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

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.