Post by Diffice » Thu Sep 06, 2012 3:35 am

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

Active Member

Posts

Joined
Thu Aug 16, 2012 7:59 pm

Post by opcrat » Thu Sep 06, 2012 7:44 am

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.


User avatar
Active Member

Posts

Joined
Wed Dec 21, 2011 6:54 am

Post by MarketInSG » Thu Sep 06, 2012 9:13 am

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.


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Diffice » Thu Sep 06, 2012 5:07 pm

@ 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

Active Member

Posts

Joined
Thu Aug 16, 2012 7:59 pm

Post by MarketInSG » Thu Sep 06, 2012 8:18 pm

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

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =0


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Diffice » Thu Sep 06, 2012 8:26 pm

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?

Active Member

Posts

Joined
Thu Aug 16, 2012 7:59 pm

Post by MarketInSG » Fri Sep 07, 2012 9:23 am

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


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by DesktopNev » Mon Sep 10, 2012 7:15 pm

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?

Newbie

Posts

Joined
Tue Feb 07, 2012 9:38 pm

Post by MarketInSG » Mon Sep 10, 2012 8:27 pm

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


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by DesktopNev » Tue Sep 11, 2012 9:45 pm

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

Newbie

Posts

Joined
Tue Feb 07, 2012 9:38 pm

Post by allexdaemon » Tue May 26, 2015 1:03 am

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

Newbie

Posts

Joined
Sat Mar 21, 2015 6:30 pm
Who is online

Users browsing this forum: No registered users and 38 guests