Hi,
I've done a few test purchases on my site, and that all works fine. However if I cancel the order without marking it as payment received, the values are still included in the 'Total Sales' figure on the dashboard - even though the product has not been sold.
Is there anyway to get this to only include those orders marked as complete - ie the ones that have actually been sold, rather than the total value of orders placed.
Thanks
Ian
OC1.4.0
I think you need to change the way the Total Sales is counted in the Stats.
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.
No, sorry.rincerofwinds wrote:Thanks for that - any idea where/how i would go about doing it?
You need someone that can adjust the queries that generates the Stats.
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.
I checked the function.. It already omits products that have order status of 0
The file is admin/model/sale/order.php
and find:
If you want to ignore additional status ids then you can change it to:
where the numbers are the ids of the order statuses you want to exclude from the total sales
The file is admin/model/sale/order.php
and find:
Code: Select all
$query = $this->db->query("SELECT SUM(total) AS total FROM `" . DB_PREFIX . "order` WHERE order_status_id > '0'");Code: Select all
$query = $this->db->query("SELECT SUM(total) AS total FROM `" . DB_PREFIX . "order` WHERE order_status_id NOT IN ('0', '1', '2')");
To also have the total per year correct use in \admin\model\sale\order.php
You can add any other Order-status to ('0', '1', '2'), to find the other status numbers use phpMyAdmin and look at the Tabel: order_status.
Code: Select all
public function getTotalSalesByYear($year) {
$query = $this->db->query("SELECT SUM(total) AS total FROM `" . DB_PREFIX . "order` WHERE order_status_id NOT IN ('0', '1', '2') AND YEAR(date_added) = '" . (int)$year . "'");
return $query->row['total'];
}
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.
Works also in 1.5.4.1!
I have no clue why this is not changed because cancelled orders are no sale.....
I have no clue why this is not changed because cancelled orders are no sale.....
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.
I cannot believe this wasn't incorporated into later versions. I found this old post after trying to fix the Dashboard totals in my OC1.5.6 site...
Thanks Qphoria and i2paq
Stokey
Thanks Qphoria and i2paq
Stokey
Stokey
Hello
I am using opencart version 3.0.3.2
I have the same problem, I followed the steps but found my codes different and I did not know how to change it
Attach the code for Version 3.0.3.2, please
I am using opencart version 3.0.3.2
I have the same problem, I followed the steps but found my codes different and I did not know how to change it
Attach the code for Version 3.0.3.2, please
Who is online
Users browsing this forum: Amazon [Bot], RiguPhoto and 201 guests
