[kpriest]

In the /xcart/customer/ directory: products.php
Original query:

#
# Get products data for current category and store it into $products array
#
$search_query = "($sql_tbl[products].categoryid='$cat' or $sql_tbl[products].categoryid1='$cat' or $sql_tbl[products].categoryid2='$cat' or $sql_tbl[products].categoryid3='$cat') and $sql_tbl[products].forsale='Y'";

I believe you just need to add the ORDER BY clause in here, like this:

#
# Get products data for current category and store it into $products array
#
$search_query = "($sql_tbl[products].categoryid='$cat' or $sql_tbl[products].categoryid1='$cat' or $sql_tbl[products].categoryid2='$cat' or $sql_tbl[products].categoryid3='$cat') and $sql_tbl[products].forsale='Y'" ORDER BY $sql_tbl[products].productcode;

I didn't test this - I have the sort alphabetically mod from somewhere in this forum.

hope this helps.