X-Cart forums - Category Sorting Problem

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Category Sorting Problem (https://forum.x-cart.com/showthread.php?t=1285)

Category Sorting Problem

I would think that if I set up 10 categories and assign them all the position of "1" then they would automatically sort alphabetically. It doesn't seem to work. Please tell me there is a way to fix this. I don't want to have to tell my client she will have to manually figure out how to sort :cry: alphabetically.

Thanks!

This is possible:

You will need to edit includes/categories.php and look for the line that is:

Code:

$categories_data = func_query("select $sql_tbl[categories].*, 0 as product_count from $sql_tbl[categories] ".($current_area=="C"?"where $sql_tbl[categories].avail='Y' $membership_condition ":"")." group by $sql_tbl[categories].categoryid order by ".($current_area=="C" ? "order_by" : "category"));

to be:

Code:

$categories_data = func_query("select $sql_tbl[categories].*, 0 as product_count from $sql_tbl[categories] ".($current_area=="C"?"where $sql_tbl[categories].avail='Y' $membership_condition ":"")." group by $sql_tbl[categories].categoryid order by ".($current_area=="C" ? "category" : "category"));

This will effectively disable the order by column and make it order by category name.