Customer Groups in alphabetical order?

AUwebman1 · **Joined:** Sat Aug 01, 2009 9:54 am **Posts:** 36

Cart Version: B2B 6.4.2

On the /admin/customers.php page when click I edit a customer's account, is there a way to set the Customer Groups to always display in alphabetical order on that page rather than in order by date created? I've got over a few dozen Groups and its that much harder to find the group I need to place that customer in when its as disorganized as it is now.

how it displays now:

TheLango · **Joined:** Sun Nov 29, 2009 10:57 am **Posts:** 352

I think, in Admin - customers.php, find around line 375 the following:

Code:

    $existing_customers_query = tep_db_query("select customers_group_id, customers_group_name from " . TABLE_CUSTOMERS_GROUPS . " WHERE group_status = '1' and group_access = '1' order by customers_group_id "); 

And replace with:

Code:

    $existing_customers_query = tep_db_query("select customers_group_id, customers_group_name from " . TABLE_CUSTOMERS_GROUPS . " WHERE group_status = '1' and group_access = '1' order by customers_group_name "); 

AUwebman1 · **Joined:** Sat Aug 01, 2009 9:54 am **Posts:** 36

Perfect!

Thank you, Lango!

CRE Loaded Community

Customer Groups in alphabetical order?

Who is online

Main Menu

Login

Forums Latest Activity

Top Listing

Members Online