Post by moreno13 » Fri Jan 07, 2011 7:19 am

Hi there any knows how to reset the total sales to 00.00
because we have to pay taxes from year to year if we do not reset the total sell to 000 we gone pay double taxes
next year as this year is a new year I need to reset the total sales to 000
any help please I am using 1.9.4.2
and I need some help because I need to add all losses
all the returns and all the taxes
people who pay taxes know all this drama :choke: the we need to go through each year any help reseting the total sales to 000
any help will do well grateful

Thanks to all the experts who take the time to read this post
God Bless you all.
nice work Opencart team

New member

Posts

Joined
Thu Sep 30, 2010 10:02 am

Post by JAY6390 » Fri Jan 07, 2011 9:19 am

If it's under the REPORTS > SALES you can use the filter and select the date range (and use group by year)
If you mean under REPORTS > PRODUCTS PURCHASED you will need to open

Code: Select all

/admin/model/report/purchased.php
FIND:

Code: Select all

WHERE o.order_status_id > '0'
and change it to

Code: Select all

WHERE DATE_FORMAT(o.date_added, '%Y') = DATE_FORMAT(NOW(), '%Y') AND o.order_status_id > '0'
(untested but should work)

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by moreno13 » Fri Jan 07, 2011 2:41 pm

Thanks Jay6390
but this is what I need to reset to 000
this not my real store this the test store I have on my localhost I just do all my testing on this one before I put on live
I try the code but I don't see any change
any help?
please ;)
any help will do well grateful

Thanks to all the experts who take the time to read this post
God Bless you all.
nice work Opencart team

Attachments

totalsales.png

totalsales - totalsales.png (35.29 KiB) Viewed 1022 times


New member

Posts

Joined
Thu Sep 30, 2010 10:02 am

Post by JAY6390 » Fri Jan 07, 2011 6:52 pm

I'm confused to be honest, the total sales for this year is directly below where you highlighted, so couldn't you just use that? I can give you a solution to show the same figure as above it, but wouldn't that be pretty pointless?

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom
Who is online

Users browsing this forum: Google [Bot] and 19 guests