Sorry but can you please explain what do you mean by reset report.
Most Useful Extensions || Most Selling Extensions
Opencart Development || Opencart Designing || eCommerce Project
✔ Join more than 5000 Happy Opencart Store Owners enjoying the extensions designed and developed by Opcrat, Opencart Partner.
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.
do some search in the forum next time, it's mentioned before.
Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =0
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?
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
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
i did that .. did.nt solve all my problem but atleast it cleaned a little .
good luck
Who is online
Users browsing this forum: No registered users and 324 guests