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