Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Sort by Price - Sale Price Not?

  1. 08-28-2010, 09:59 AM #1
    MSD is offline Member
    Join Date
    Sep 2009
    Location
    EST
    Posts
    57

    Default Sort by Price - Sale Price Not?

    I have noticed that sort by price must just look at Price and not Sale Price. In a category of products I would prefer the sale items to rise to the top of the page.

    Is this just how it works, a known issue, or does everyone edit something.

    Thanks MSD
    Started V8 switched half way to V9 /// I need a V9 Forum

    AspDotNetStorefrontML 9.0.1.3/9.0.1.3 AspDotNetStorefront ML 8.0.1.2/8.0.1.2
  2. 11-02-2010, 09:17 AM #2
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Default

    Sounds like you will need to change the T-SQL
    maybe to something like ISNULL(pv.SalePrice,pv.Price)
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience