[BCSE]

I had a little time to look into this and have it working for random products. I tested this with 3.5.5

First edit skin1/modules/Recommended_Products/recommends.tpl Add this code:

 <font class=ProductPrice>{include file="currency.tpl" value=$recommends[num].price}</font><font class=MarketPrice>{include file="customer/main/alter_currency_value.tpl" alter_currency_value=$recommends[num].price}

AFTER

<span class="ItemsList">{$recommends[num].product}

Then edit customer/recommends.php

Find this line:

$query_condition .= "productid='".$products_id[$rnd]["productid"]."'";

CHANGE IT TO:

$query_condition .= "$sql_tbl[products].productid='".$products_id[$rnd]["productid"]."'";

Find this line:

$query_condition .= " OR productid='".$products_id[$rnd]["productid"]."'";

CHANGE IT TO:

$query_condition .= " OR $sql_tbl[products].productid='".$products_id[$rnd]["productid"]."'";

Finally, find this line:

$query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND avail>0".$query_condition;

CHANGE IT TO:

$query = "SELECT * FROM $sql_tbl[products] left join $sql_tbl[pricing] on $sql_tbl[products].productid=$sql_tbl[pricing].productid WHERE forsale='Y' AND avail>0 and quantity='1'".$query_condition;

Hope this helps! Feel free to format recommends.tpl to suit your needs.

Carrie