Sign in
 
Microsoft Developer Network > Forums Home > Commerce Server Forums > Commerce Server 2007 > Browse items by category or by manufacturer
Ask a questionAsk a question
Search Forums:
 

AnswerBrowse items by category or by manufacturer

  • Friday, November 06, 2009 7:06 PMMike Kelley Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I want to allow my customer to not only browse by category but also by manufacturer.  How is the best way of handling this? 
     

Answers

  • Friday, November 06, 2009 9:30 PMCyril Rebreyend Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote

    Hello,

    you can create a product property called Manufacturer, and then you can retrieve this by doing a search with a SqlSearchclause = "Manufacturer = " + manufacturername

    To have the manufacturer list, you have 2 options:
    - create another database with a table containing all manufacturers names (recommended, so that you can use it in your backoffice to fill a ddl for the manufacturer property),
    - or create a static list in wich you store a select distinct of manufacturer.

    hope this help,
    Cyrebre

     
  • Sunday, November 08, 2009 4:46 PMRavi Kanth KoppalaMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    Mike,
    One of the nice option is to go with FAST ESP - which provides attribute based search - for example, if you go to any websites like bestbuy.com/ebay.com - you can able to see narrow results - like while browsing laptops you can see by progessor, customer reviews, price, brand, screen, RAM, weight, operating system etc and it is easily implementable using FAST ESP.

    Regards,
    -Ravi Kanth Koppala
    http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)
     

All Replies

  • Friday, November 06, 2009 9:30 PMCyril Rebreyend Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote

    Hello,

    you can create a product property called Manufacturer, and then you can retrieve this by doing a search with a SqlSearchclause = "Manufacturer = " + manufacturername

    To have the manufacturer list, you have 2 options:
    - create another database with a table containing all manufacturers names (recommended, so that you can use it in your backoffice to fill a ddl for the manufacturer property),
    - or create a static list in wich you store a select distinct of manufacturer.

    hope this help,
    Cyrebre

     
  • Saturday, November 07, 2009 8:13 PMMike Kelley Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Cyrebre,

    Thanks for the suggestion.  I'll try these. 
     
  • Sunday, November 08, 2009 4:46 PMRavi Kanth KoppalaMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    Mike,
    One of the nice option is to go with FAST ESP - which provides attribute based search - for example, if you go to any websites like bestbuy.com/ebay.com - you can able to see narrow results - like while browsing laptops you can see by progessor, customer reviews, price, brand, screen, RAM, weight, operating system etc and it is easily implementable using FAST ESP.

    Regards,
    -Ravi Kanth Koppala
    http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)
     
  • Tuesday, November 10, 2009 2:36 PMMike Kelley Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Ravi,

    Thanks for mentioning this... I've actually never heard of FAST ESP untill you just mentioned it.  This would definitely help me out since I also have keywords and many attributes for each item.  Where you suggest a good source of getting up to speed on how to use FAST ESP with CS2009?  Doing an initial search I did find some web entries for MOSS but nothing regarding WSS or CS2009.  Is this exclusive to MOSS?

    Mike