X-Cart forums

[bloomis]

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 alphabetically.

Thanks!

[funkydunk]

This is possible:

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

$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:

$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.