Page 1 of 1
Admin Total Sales adjustment on Order Cancel / Refund
Posted: Mon Aug 09, 2010 3:59 pm
by RajaA
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.
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Mon Aug 09, 2010 6:13 pm
by i2Paq
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.
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Mon Aug 09, 2010 6:23 pm
by RajaA
Is there no way of putting the order status check into the equation when its calculating the Total Sales?
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Mon Aug 09, 2010 11:54 pm
by i2Paq
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.. !!.
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Tue Dec 14, 2010 11:20 am
by webternals
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.
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Wed Dec 15, 2010 9:26 am
by jty
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
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Fri Feb 15, 2013 3:47 am
by ironspeeder
This issue still exists in version 1.5.4 please fix because it affect our taxes we have to pay!
Re: Admin Total Sales adjustment on Order Cancel / Refund
Posted: Sat Feb 16, 2013 5:48 am
by i2Paq
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.
Re: Admin Total Sales adjustment SOLVED
Posted: Fri Nov 10, 2017 1:26 pm
by Robonz
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!