Sorting by price - Not sorting discounted price correctly

[bluetail2011]

Joomla 2.5.4/VM 2.0.6

Hi all,

I'm having a problem with sorting products on the category page. Apologies if this has been asked before, but I've looked all over the forums and can't find the answer.

On my website when I sort by Product Price, it does not take the discounted prices into account. For an example scroll down to the GoDaddy Economy plan on this page: http://compareanyhost.com/index.php/component/customfilters/shared2012-04-23-16-26-09_/no-manuf

I am using the 'Override' field in the Product Pricing box to put in the discount. As these prices are dictated to me, I can't  use calculation rules to do this.

I'm not sure if this is expected behaviour or a bug, but any help would be much appreciated.

thanks,

Peter

[bluetail2011]

Anyone?