Ubercart

Thanks again for helping, it really is appreciated.

In the end, I decided to put on my mysql and php thinking hat. It's been a while... I used the MSQL query formed by the custom view and added the stock field with a join:

$query= "SELECT node.nid AS nid,
node_data_field_date2.field_date2_value2 AS node_data_field_date2_field_date2_value2,
node_data_field_date2.field_date2_value AS node_data_field_date2_field_date2_value,
node_data_field_date2.nid AS node_data_field_date2_nid,
node.type AS node_type,
node_data_field_date2.field_location_value AS node_data_field_date2_field_location_value,
node_data_field_date2.field_venue_value AS node_data_field_date2_field_venue_value,
uc_products.sell_price AS uc_products_sell_price,
node.title AS node_title, uc_product_stock.stock as stock_value
FROM node node
LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid
LEFT JOIN uc_product_stock uc_product_stock ON node.nid = uc_product_stock.nid
LEFT JOIN content_type_product node_data_field_date2 ON node.vid = node_data_field_date2.vid
WHERE (uc_products.model) = ('PRODUCT-NAME')";
$results = db_query($query);

while($output = db_fetch_object($results))
{

$stock_value = $output->stock_value;
$date = $output->node_data_field_date2_field_date2_value2;
$price = $output->uc_products_sell_price;

}

echo "stock".$stock_value;
echo "date".$date;
echo "price".$price;