[tcatrainer]

I was looking to modify the search sql to search for another field the partnumber

$search_query = "(
$sql_tbl[products].productcode like '%$substring%'
or
$sql_tbl[products].product like '%$substring%'
or
$sql_tbl[products].descr like '%$substring%')

and
$sql_tbl[categories].category like '$search_category%'
and
$sql_tbl[products].forsale='Y' $price_condition ".$sort_by_price;

All I should really have to do is add:

$sql_tbl[products].productcode like '%$substring%'
or

i changed it in <
xcart dir>/admin/search.php
xcart dir>/customer/search.php
xcart dir>/provider/search.php
but it seems to have no effect when you actually performa a search.
It appears it should be calling
http://www.aeroaccess.com/xcart/customer/search.php