HomeHome Product Discus... Product Discus...SmithCartSmithCartSearch ModuleSearch Module
Previous
 
Next
New Post
3/27/2012 5:57 AM
 

Hi there

I am implementing the search module on my home page, I am using the Mutliple Row layout, but only using the "show textbox" with a keyword: label. I guess this searches multiple fields in the product table, but its either coming up with no results or times out.

What stored procedure is used for this searching? I would like to implement full text searching on my product catalogue as we will be running a few million products, so I would like to customise the stored procedure.

I cant find any detailed information about this in the smithshoppingcartmanual.pdf

If I can find out what SP is being used for this search I can customise it to include full text and only search the fields I want it to.

Please advise.

Thank you.

Cheers

Jako

 
New Post
3/28/2012 4:47 PM
 
Hi Jako,

Which version of the Cart and DNN are you currently running?

The Show Textbox option allows the user to enter keywords to search on. The search module will a wildcard search on the
search terms entered in the search textbox.

Currently there are 3 different ways to search for products in your store.

The first being the DNN iSearchable interface so all your products are indexed and searchable using the regular DNN search facility.

The product search within the BuyNow module itself.

The last would be the Smith Search module which is a separate module in Smith Cart that can be placed in any pane on any page in your portal and allows the user to search and quickly locate products in your catalog.

When the user enters/selects their search options and clicks “Search” the search module will query the category and product tables and the user will be redirected to the BuyNow module product listing page and the products will be filtered according to the search criteria entered in the search module. If a search returns no rows then the search module will display a message “No records found” and remain on the same page.

For options 2 and 3 above, Smith Cart also provides the ability to enter additional product search keys that are searchable from the product listing page search box. This is useful if you would like to have products searchable on words that do not show up in the product name, sku, summary or description or they can be used for product associations or common misspellings.

Thanks,
 
New Post
3/29/2012 12:43 AM
 
Hi Kevin

Thanks for the reply, I am using DNN 6.1.4.127 and Smith.Cart 4.93.0

The search on the Buy.Now page works 100% and the Category page also brings up the results pretty good, I have created some extra indexes on the Product Table to speed it up though.

But the Smith.Search module keeps bringing up empty results or a "A critical error has occurred. Timeout expired." message.

I am using the MultiRow Layout and just the "Show Textbox" is checked with a Label "Keyword" entered. Nothing else. When I search for the same criteria with the Buy.Now search I get results though.

Any feedback on which SP the Smith.Search uses so I can implement FullText searching in it?

Thanks! Almost done with the testing, seems this is the way to go and it integrates with myGate out of the box which is great!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSearch ModuleSearch Module