### Admin Total Sales adjustment on Order Cancel / Refund

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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.

Global Moderator

Posts

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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.

Global Moderator

Posts

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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

Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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

### Re: Admin Total Sales adjustment on Order Cancel / Refund

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.

Global Moderator

Posts

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

### Re: Admin Total Sales adjustment SOLVED

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 7 guests