Sometimes I feel like x-cart has one person who understands and writes the variants code and he works to ensure his job security
Open include/search.php
FIND:
Code:
foreach ($variant_properties as $property) {
$fields[] = "IFNULL($sql_tbl[variants].$property, $sql_tbl[products].$property) as ".$property;
}
Replace with:
Code:
foreach ($variant_properties as $property) {
if ($property != 'productcode')
$fields[] = "IFNULL($sql_tbl[variants].$property, $sql_tbl[products].$property) as ".$property;
}