Site Search

Ecommerce has two kinds of search:

• Full Text Search
  • Default search for Ecommerce
  • Built on Microsoft Full Text Search technology
  • Heavily configurable in Site Settings>Site Search, including what columns to search and what their priority is
  • Works very well for handling plural/singular searches (ie. run vs ran) and synonms
  • Performs very well for large amounts of data
  • Works poorly for item numbers with punctuation (XYZ-1234-ABC) since the search engine sees the punctuation as word breakers
• Item Search
  • Typically disabled for Ecommerce, but can be enabled in Site Settings>Site Search
  • Uses Microsoft SQL LIKE searches
  • Heavily configurable in Site Settings>Site Search including what columns to search and what their priority is
  • Performs poorly for large amounts of data
  • Works well for item numbers with punctuation (XYZ-1234-ABC)
  • More technical info:
    
    • Searches the following columns (IM = IMItmIdx_sql and BDI = BDItems25):
      • IM.Item_No
      • IM.Item_Desc_1
      • IM.Item_Desc_2
      • BDI.ShortDescription
      • BDI.MediumDescription
      • BDI.LongDescription
      • BDI.MetaDescription
      • BDI.MetaKeyWords
      • BDI.SubTitle
      • BirdDog custom fields