[ChristineP]

Does anyone have a suggestion to display the root sku (part number) on the product.tpl and products_t.tpl pages for variants. I checked in my include/search.php and the only reference close to the above code by proboscidian is $sql_tbl[variants].productid:

$left_joins["variants"] = array(
"on" => "$sql_tbl[variants].productid = $sql_tbl[products].productid AND $sql_tbl[quick_prices].variantid = $sql_tbl[variants].variantid",
"parent" => "quick_prices"
);


Once a product variant is selected and the customer adds to cart for checkout, then the variant sku number is fine to display.

Christine