[SOLVED] Which table(s) does BO use to retrieve sales/revenue data?

[Masteries]

I've made a few test orders on my shop and the sales data is now including the revenue of those test orders. I tried removing those orders in all the "ps_orders_x" tables but the dashboard still shows their sales revenue. I'd like to completely remove traces of those test orders from the table(s) it uses so it doesn't show in the dashboard. Check the attachment to see what I'm talking about.

 

Thanks in advance!

Edited September 6, 2016 by Masteries (see edit history)

[rocky]

I checked the code and that module gets the data from the ps_orders table, so deleting the sample data should have worked. Did you turn off "Demo mode" in the top-right corner of the dashboard?

[Masteries]

Yep, the demo mode was never on to begin with. Anyways, for some reason it's now displaying correctly without me doing anything. Oh well... Prestashop works in mysterious ways..

[vekia]

it can be a matter of cache, i've got similar problems and after cache clear i get new sales stats on my dashboard

[Masteries]

it can be a matter of cache, i've got similar problems and after cache clear i get new sales stats on my dashboard

 

Indeed. I believe this is the only explanation.

Edited August 12, 2016 by Masteries (see edit history)