Clearing Sales Reports

General Forums General Questions
#1

Hi,

We'd like to clean sales reports from entries that were related to test orders - how could it be done? Orders were deleted yet sales reports still show these transactions.
Is this info stored separate in db and I should manually delete it from there (which table?) or is there a more civilised way?

Thanks!

#2

Hi,

We'd like to clean sales reports from entries that were related to test orders - how could it be done? Orders were deleted yet sales reports still show these transactions.
Is this info stored separate in db and I should manually delete it from there (which table?) or is there a more civilised way?

Thanks!

Actually there are no specific tables in database for statistic. Everything is calculated from the actual data.

But if you mean not default reports, but 3rd party addon, you should contact developers of this module with this issue

#3

Thanks, but what do you mean by the actual data? I deleted all orders related to a particular product and I still can see this product in the standard product sales report

#4

Thanks, but what do you mean by the actual data? I deleted all orders related to a particular product and I still can see this product in the standard product sales report

Looks like some data was not deleted completely

#5

No, all these orders were deleted definitely. There are no orders for given vendor at all and yet his sales report shows these sales.

#6

No, all these orders were deleted definitely. There are no orders for given vendor at all and yet his sales report shows these sales.

You may not see orders in the admin/ vendor panel, but some tables can still contain data about these orders. It is required to examine your database

#7

Thanks, so we're back with my original question :) which tables should I examine and clear?

#8

I've found the reason! The sales report are including INCOMPLETE ORDERS, which are normally hidden!
Can anyone please confirm this behaviour, it doesn't make any sense.

Thanks!

#9

I've found the reason! The sales report are including INCOMPLETE ORDERS, which are normally hidden!
Can anyone please confirm this behaviour, it doesn't make any sense.

Thanks!

You can check it on the demo

http://demo.cs-cart.com/admin.php