X-Cart forums

[balinor]

Remember seeing this one for previous versions, but things have changed in 4.3. When you display the sku on the products list, it shows the first variant. Need to display the 'base' sku (i.e. the sku of the main product) instead. Any ideas where that little PHP snippet lives?

[Jon]

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:

        foreach ($variant_properties as $property) {
            $fields[] = "IFNULL($sql_tbl[variants].$property, $sql_tbl[products].$property) as ".$property;
        }

Replace with:

        foreach ($variant_properties as $property) {
            if ($property != 'productcode')
            $fields[] = "IFNULL($sql_tbl[variants].$property, $sql_tbl[products].$property) as ".$property;
        }

[balinor]

Going to move this to Custom Mods