Sort orders by delivery date

[FuRuiDe]

Hi everyone,

Question about admin/orders.php

How can I change the display of orders to sort by nearest delivery date first?

NB.I've installed the desired delivery date mod.

But now I want to change the default sort in the Admin>Customers>Orders
and change it to display in order of next delivery date.

I think the sort order is default to display either in ID or ordered date. I cant see the ascending/descending order you get in the customers section of admin (unless the delivery date mod knocked it out).

Looking at the orders.php I think it might have something to do with $oID as in this line...

$oID = zen_db_prepare_input(trim($_GET['oID'])); 

but it would impact a whole load of other parts on the file.

or something to do with order by date_added which appears a few times (I tried changing this to order by delivery_date, but nothing )

Any help appreciated its the first time I've been stuck on Zencart, and the shop is a florists so hence we need to sort the orders by when they will go out.

Ta very much.

[panelcart]

did you find any solution to this?