Sorting orders by status

[Guest]

I haven't figured out how to do the filtering v2 used to do yet, but I did come up with a quick fix for those of us with a lot of orders we are trying to keep track up.

I changed the sort order to be by status instead of by date and here's how:

Modify admin/orders/index.php

about line 86 find:

	$query = "SELECT ".$glob['dbprefix']."CubeCart_customer.customer_id, status, cart_order_id, time, title, firstName, lastName, ip, prod_total, ".$glob['dbprefix']."CubeCart_customer.email FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id ".$sqlQuery." ORDER BY time DESC";

and change the final line to:

ORDER BY STATUS ASC";

This puts all wth status 1 (pending processing) at the top followed by whatever you have your status to be.

Hope it helps!