Knowledgebase
Home » Item #739
Deleting Sales Stats
Question
I performed several test orders before going live with the site. I have now deleted the test orders, but version sales stats still include the deleted orders. How can I set the sales stats to actual sales?
Answer
When an order is deleted, sales stats are not, because the sales statistics are not linked back to the original order. The only way to delete previous statistics is to to it by hand in the database.
If there are currently no real orders in the database, then you can simply delete all the records in the tblCactusVersionSalesStats table.
However if you want to delete only those from test orders, then you'll need to go through manually and delete each record you think was related to a test order. Alternatively it may be easier to delete all of them, and then add in some statistics to resemble what should be real statistics.