Anyone know how to sort the status order. I have tried using the "status order" field but it still sorts by "status_id" in admin sections.
Anyone encountered this before?
Regards,
Dave
TOCDCO
28 Sep 2008 11:28 PM
Just click on the title of the column and it will sort by that column
freezer
29 Sep 2008 12:26 AM
Hi Dan,
Thanks for your reply.
The trouble is the Status_order field is not present only the "id"
and neither are present in the sales/orders screen
best
Dave
eugene
29 Sep 2008 8:14 AM
In latest version status_order is already used in ORDER BY statement so order statuses are firstly orders by this field.
If it does not work in your installation, just check for example admin/admin_orders.php whether it contains correct SQL query string like
$sql = "SELECT status_id, status_name FROM " . $table_prefix . "order_statuses WHERE is_active=1 ORDER BY status_order, status_id";
freezer
29 Sep 2008 9:29 AM
Thanks eugene,
No no such SQL is present despite the fact I have the up to date version