remove orders when status changes

[leest35]

HI,

is there a way to archive or hide orders, once their status has been changed to delivered.

At present once the status changes the orders remain in the list and it could be good if i could just hide or archive them.

Thanks

Lee

[Ajeh]

You could customize the SELECT on the orders.php to not include orders with the orders_status for Delivered ... by default that is 3 but check your Order Status to make sure ...

[leest35]

I will give it a go thank you

[gloerick]

Ajeh, what would the code be for the orders.php or should say the ADMIN HOME page
where the NEW ORDERS are shown..
so that DELIVERED does not show, as the list is getting long
& would be more efficient to only see the orders needing attention.




Thx,
Erick

[Ajeh]

In the file:
/your_secret_admin_dir/index.php

is the SELECT for the New Orders around line 155:

  <?php  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and class = 'ot_total') order by orders_id DESC limit 5");

You could add to that a WHERE statement to limit the orders pulled to be a particular orders_status or something like < 3 where 3 is the Delivery Status ...

[gloerick]

I appriciate the reply, but I really do not understand what to replace,
I did find the code you state in the file but not sure on what to change.

<?php $customers = $db->Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " a on c.customers_id = a.customers_info_id order by a.customers_info_date_account_created DESC limit 5");

[Ajeh]

You can add a where statement to this by changing line 155 to:

  <?php  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and class = 'ot_total') WHERE o.orders_status < 3 order by orders_id DESC limit 5");

NOTE: line number and code change I goobered up in the last post ...

[gloerick]

That seems to be it, thank you so much,
all the older delivered orders are off the ADMIN HOME page and now only the
NEW pending orders that need attention are showing.

Thx SO MUCH, it took off ALOT of cluder.

Erick