Here's the coding I use ... Its a modified version of what I found on these forums about 6 months ago.
It works in v4.1.x but should work in v4.0.x as well.
Insert this where you want the text to appear.
Code:
{* get wholesale wholesale pricing data for product *}
{php}
$prodid=$this->_tpl_vars['pid'];
$results = func_query("SELECT min(price) as price, max(quantity) as quantity FROM xcart_pricing WHERE productid='$prodid' AND quantity > 1 ORDER BY quantity");
$this->assign("sv_val",$results);
$wsprice=$this->_tpl_vars['sv_val'][0]['price'] ;
$wsqty=$this->_tpl_vars['sv_val'][0]['quantity'] ;
if ($wsqty > 1) {
echo "
<font style='color: #ff9900; font-size: 7pt; font-style: italic'>";
echo "... as low as бё" . $wsprice . " when purchasing more than " . $wsqty . " items.";
echo "</font>";
}
{/php}