Post by RajaA » Mon Aug 09, 2010 3:59 pm

In Administration, why don't the "Total Sales" and "Total Sales This Year" automatically adjust when an order is cancelled or refunded?

I'm using Opencart 1.4.8.

Newbie

Posts

Joined
Mon Aug 09, 2010 3:52 pm

Post by i2Paq » Mon Aug 09, 2010 6:13 pm

That is because it only is calculating on the orders in total, it does not look at any statusses.
You need to delete an order to get it removed from the totals.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by RajaA » Mon Aug 09, 2010 6:23 pm

Is there no way of putting the order status check into the equation when its calculating the Total Sales?

Newbie

Posts

Joined
Mon Aug 09, 2010 3:52 pm

Post by i2Paq » Mon Aug 09, 2010 11:54 pm

RajaA wrote:Is there no way of putting the order status check into the equation when its calculating the Total Sales?
I think it needs a lot of coding for that.

Have a look at Full report.. !!.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by webternals » Tue Dec 14, 2010 11:20 am

What I did was create a product for my refunds and gave it a -1.00 price. Made a category named refund. Then I made sure that both refund category and the refund product are disabled for obvious reasons.

Now say you have a product that the cost was $4.95 you would make the tax be 395%

Then that would be -1.00 X 3.95 = -3.95
-3.95 + -1.00 = -4.95

Ta-da you can now add that product in the admin for any refunded products and your total will be right.

May not be optimal but it works and you get to show the refunded amount on the invoice as well.

Newbie

Posts

Joined
Tue Dec 14, 2010 11:14 am

Post by jty » Wed Dec 15, 2010 9:26 am

RajaA wrote:Is there no way of putting the order status check into the equation when its calculating the Total Sales?
you can add it to model/sale/order.php in the getTotalSales and getTotalSalesByYear functions, in the WHERE part of the query clause

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by ironspeeder » Fri Feb 15, 2013 3:47 am

This issue still exists in version 1.5.4 please fix because it affect our taxes we have to pay!

Newbie

Posts

Joined
Fri Feb 15, 2013 3:45 am

Post by i2Paq » Sat Feb 16, 2013 5:48 am

ironspeeder wrote:This issue still exists in version 1.5.4 please fix because it affect our taxes we have to pay!
True!

You can still filter on order-status.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Robonz » Fri Nov 10, 2017 1:26 pm

I have this bodge that works really well.

Make a product that has a price of minus $1.00. product ID "rebalance dashboard"

Work out how much your dashboard is out by e.g.Adjustment = Dashboard sales - Total completed sales

On a test account purchase Adjustment x "rebalance dashboard"

Set the sale to canceled and you are done. The dashboard total will now match completed sales.

Don't forget to make sure to set the product ID "rebalance dashboard" to disabled when you are done. You dont want your customers to buy this item!

Newbie

Posts

Joined
Mon Feb 27, 2017 2:24 pm
Who is online

Users browsing this forum: No registered users and 28 guests