How does the dashboard generate the percentages?
My Total Orders, Total Sales, & Total Customers are all correct, but the percentages for each box are wrong with Total Orders showing -300%, Total Sales -250%, and Total Customer also at -300%.
Also the World Map doesn't show any sales.
I have OC 3.0.3.6, running on PHP 7.3.33. This has been working for a couple of years, and I double checked admin permissions in the Users section were enabled for Dashboard.
I have done a bit of cleaning up (purging some bulky log files), and haven't looked at the Dashboard for a little while - so may have deleted some important file I shouldn't have.
Thanks!
They are generated by dividing the total order in the database by the values in the statistics.
What do you see under Reports - > Statistics? Can you refresh them?
What do you see under Reports - > Statistics? Can you refresh them?
I tried Refreshing the Statistics - no change:ADD Creative wrote: ↑Thu Sep 29, 2022 6:48 pmThey are generated by dividing the total order in the database by the values in the statistics.
What do you see under Reports - > Statistics? Can you refresh them?
This is what I saw on the dashboard (Canada now shows 2 sales):
Today the stats are slowly recovering as we get sales (World Map has gone back to no sales anywhere):
Thanks for your time!
Sorry, I misread you post and thought you were talking about the percentages in the sidebar.
The box percentage is calculated form ('yesterday's orders' - 'the day before yesterday's orders') / 'yesterday's orders'. So if you have more orders the day before yesterday than yesterday, you will get a negative number. I think!
The box percentage is calculated form ('yesterday's orders' - 'the day before yesterday's orders') / 'yesterday's orders'. So if you have more orders the day before yesterday than yesterday, you will get a negative number. I think!
Further to my question on how statistics are generated in the Dashboard - does anyone know how the Dashboard World Map gets its data to show sales by countries? Mine is now ignoring sales and shows just the basic map, and mousing over the countries does not show sales, just the country's name.
I can ignore it of course, but I assume because it is not working that something is broken and needs attention.
I don't see any errors that might be related in the logs...
Thanks!
I can ignore it of course, but I assume because it is not working that something is broken and needs attention.
I don't see any errors that might be related in the logs...
Thanks!
It uses getTotalOrdersByCountry in admin/model/extension/dashboard/map.php. The order status needs to be tick as one the completed order statuses in your settings. The SQL query groups all order by country.
Ah, thanks! I see that when I go to admin/System/Settings/(store name)/Option/Complete Order Status and select "Processed" & "Shipped" & "(any choice we use to indicate sale is finished/shipped/picked up/...)" that the data now appears in World Map. Problem solved!ADD Creative wrote: ↑Mon Oct 03, 2022 10:45 pmIt uses getTotalOrdersByCountry in admin/model/extension/dashboard/map.php. The order status needs to be tick as one the completed order statuses in your settings. The SQL query groups all order by country.
You know the little question mark explanation isn't much use as it says something like - Status Reached where customer can download product - doesn't say anything about how this is actually used.
Who is online
Users browsing this forum: No registered users and 330 guests