OpenCart Community

how to reset the
Products Purchased Report
Sales Report
Shipping Report
and other
but the most important is the Order ID: #8

thank for help is important the ans

Sorry but can you please explain what do you mean by reset report.

clean up your database would be the quickest solution. order id is incremental. you will need to alter your database for it to be 0 again. you will have to delete away previous orders before u can reset anything.

@ opcrat Reset the report : cleaning all the the voice register of any operation of sales or shipping, admin/report/order

@Marketinsg: How to find that record in the database ? how they are called?

Thanks for the ans

do some search in the forum next time, it's mentioned before.

I read that post.
I'm afraid to use that command, I would like to do it manually so you can turn back in case of error

and other reports instead?

there won't be any error or what. Just make a backup of your database before running it if you are scared.

I have a similar problem with the Products Purchased Report (Version 1.5.2.1)

I have deleted all testing orders (sales>orders>delete) but in the Products Purchased Report it still includes figures for items which where bought whilst testing and the orders have been deleted.

Where is it getting this information from, is it the cashe or is it in the database?

Basically how can I delete data in Products Purchased Report?

if you have deleted it from sales > orders, it should not be seen in the total figure because the orders are removed from database.

I did deleted the orders in the CMS but this didn't remove the orders from the database.

I've manually deleted orders in the database > order_products

which has worked.

Thanks for pointing me in the right direction

You have to do it from db directly .. phpMyadmin.
i did that .. did.nt solve all my problem but atleast it cleaned a little .
good luck