AbleCommerce Shopping Cart Software

I wanted to see how everyones Advanced Search page works before I post this as a possible bug.

It says "Wild Cards * and ? may be used."

I have several products related to a lion and lions.

When I type in lio* or lion* it returns:
- no matching products -

But, if I type in lions it returns 11 products.
If I type in lion it returns 12 products.

I don't know what the ? wildcard is supposed to do. I am assuming you would put that wildcard before the remaining characters but I can't get any results when trying to use it.

If you have a chance please test yours out and post what you find out.

Thank you.

It seems good to me. you said

I have several products related to a lion and lions.

please explain you have the word lion in description, summary or the actual product name contains this word.

mazhar wrote:please explain you have the word lion in description, summary or the actual product name contains this word.

The important part of his post said,

A search for "lion" returns 12 results.
A search for "lions" returns 11 results.
A search for "lio*" returns 0 results.

If "*" is a wild card, then "lio*" should have returned at least 11 results, regardless of where the words are.

Unless I misunderstand what the "*" wild card does. Your question implies that it only does wild card searches of certain fields. Is that true?

Hello,

I have the word lion in the product name and description fields, not the sku or summary. Something is definitely wrong with mine. I did some more testing...

I have over 1,000 total products in my store, most of which are lighters. I can search for lig with no wildcard and it will pull up all of the products with the word lighter in the product name and description of almost the entire product line - dozens of pages.

If I put in lig* it returns 0 results.

I wished I could give you a link but my site is not live yet. I'm going to try and find a store from the forums to visit and see if their advanced search page functions correctly.

Unless I misunderstand what the "*" wild card does. Your question implies that it only does wild card searches of certain fields. Is that true?

The advance search will include the summary, description and extended description fields in search if the customer checked the description checkbox on the advance search panel

Here is an AC 7 live site

http://accuquilt.com/AdvancedSearch.aspx

Check all three boxes (Name, Description and SKU)

type in the keyword sleeping
it will return 1 result

type in sleep*
it will return 0 results

That's what my site is doing.

Hello,

Seems to be working correctly.

product title: 'Baby Sleeping Door Hanger'

Entering 'Sleep' is the same as entering *sleep* and will return the product.

Entering 'sleep*' will NOT locate it since now we've told it to remove the left 'like' since the product starts with 'baby' it wont find it.

Entering '*sleeping' won't find it as now we have a left like and only if the product ended in sleeping would it find it.

'*anger' will return the product.

Since the default is to wrap searches in left and right likes (*term*), using only a left or right like will 'limit' the results rather enhance them.

hope that helps.