Skip to main content
R
rdaley72
Participating Frequently
July 11, 2013
Question

"Drill down" style search

  • July 11, 2013
  • 1 reply
  • 888 views

Does anybody have an suggestions for a stepping off point to create a "drill down" type search navigation tool for ecommerce?  What I am looking for is when a user searches our website for "Red," they get search results with a list on the left side of ways to narrow their search.  It is pretty common on ecommerce sites but sadly, our site currently just searches through product descriptions using a sql query and displaying the results if there are any.  We have been looking at vendors but they are really expensive and I don't like giving 3rd parties too much control.

For some reason, we do not have Verity installed or it is not installed correctly.  We are running CF 8 on Linux servers.  I have been looking into getting it installed but I am not sure if that will help my situation other than providing me with a better index search.

I was hoping to modify an existing script or module so I don't have to lock myself away and try to code it from scratch.

Thanks!

    This topic has been closed for replies.

    1 reply

    p_sim
    p_sim
    Participating Frequently
    July 11, 2013

    Which e-commerce sites that have the kind of search? I was trying to picture what you wanted to do.

    R
    rdaley72Author
    Participating Frequently
    July 11, 2013

    Thanks for the response.

    I am looking for something like this (this store is the reason my wife hides my credit cards):

    http://microcenter.com/search/search_results.aspx?N=4294966653&ekw=memory&rd=1

    When you do a search for memory, there is navigation on the left side to help you narrow the results. 

    p_sim
    p_sim
    Participating Frequently
    July 11, 2013

    Oh, I see... That's not difficult to achieve!

    Assuming you use SQL Server, I would create views in the database and call the views via stored procedures. To get the quantity numbers (xxx), you use GROUP BY.

    The real challenge is to write SQL statements and this depends on your table structure.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices