Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    182
    Plugin Contributions
    0

    Default Custom sort order of our 22 status bins

    There was a thread closed in 2009 that I am highly interested in finding more about. http://www.zen-cart.com/forum/showthread.php?t=105926

    I would like to custom sort order the status bins based on ID. We have 22 bins and they don't make much order sense the way they are.

    PHP Code:
    $orders_status $db->Execute("select orders_status_id, orders_status_name
                                     from " 
    TABLE_ORDERS_STATUS "
                                     where language_id = '" 
    . (int)$_SESSION['languages_id'] . "' order by orders_status_id"); 
    For example would I simply list the custom ID numbers accordingly like this :
    order by orders_status_id 16,17,1,2,3,8,9,10

    I would like to do this to orders, super_order and admin/index.php so I assume the code would be all the same.

  2. #2
    Join Date
    Jan 2010
    Posts
    182
    Plugin Contributions
    0

    Default Re: Custom sort order of our 22 status bins

    Note: this is for sort order display purposes only and I would like to keep the orders_status_id as is. Just specify the ID and sort accordingly.

    I would like to avoid this direction:
    mysql> update orders set orders_status = '5' where orders_status = '3';

 

 

Similar Threads

  1. Changing the sort order for order status
    By heavenlynights in forum General Questions
    Replies: 8
    Last Post: 20 Dec 2009, 02:46 AM
  2. Sort Order Status
    By styledata in forum Customization from the Admin
    Replies: 4
    Last Post: 3 Aug 2006, 01:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg