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 4 of 4

Thread: Search Optimization

  1. 07-23-2009, 08:22 AM #1
    lukas is offline Junior Member
    Join Date
    Jun 2009
    Posts
    13

    Default Search Optimization

    When I search my site for 'ipod' I get results that incude 'tripod' in the top ten results.
    How can I optimize search results in ASPDotNetSF so that tripods do not show up or are at the bottom?
  2. 07-23-2009, 08:23 AM #2
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    What version of AspDotNetStorefront are you using? What version of SQL?
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>
  3. 12-14-2009, 12:23 PM #3
    sohan is offline Member
    Join Date
    Jun 2009
    Posts
    33

    Default Search not by ProductID

    I found that search function also search ProductID which I don't want because customer never know productID.

    Can you please guide me to remove that feature. I have source code and it is ML 8.0.1.2/8.0.1.2

    Help appreciated.

    Sohan
  4. 12-14-2009, 12:34 PM #4
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    Just modify the aspdnsf_GetProducts stored procedure, removing the two instances of or patindex(@searchstr, isnull(convert(nvarchar(20),p.productid), '')) > 0 . Make absolutely sure you test your modifications first, and that you have a recent, working backup of the database...if you make a mistake you can cause all sorts of issues with the rest of the site
    Last edited by George the Great; 12-14-2009 at 12:38 PM.
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>