search on customer side.
search on customer side.
the search option which appears in the top border of the customer side allows for a search by name or keyword, any chance of adding Sku to this search? I know you can search by name, description or sku in the advanced search, but that's an extra click for the customer to go to this page.
Mike Keith
http://www.musicmart.com
http://www.musicmart.com
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: search on customer side.
Let's bombard mazhar and maybe he can some up with some code. The search is pretty puny as it is now.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
- m_plugables
- Commander (CMDR)
- Posts: 149
- Joined: Tue Mar 11, 2008 12:44 am
- Contact:
Re: search on customer side.
Edit the ConLib/SearchPage.ascx.cs and locate the following line of code
and replace it with the following lines of code
Code: Select all
ProductList.DataSource = ProductDataSource.NarrowSearch(_Keywords, this.CategoryId, _ManufacturerId, 0, 0, _PageSize, (_HiddenPageIndex * _PageSize), SortResults.SelectedValue);
Code: Select all
int startIndex = (_HiddenPageIndex * _PageSize);
if(startIndex == (-1*_PageSize))
startIndex = 0;
ProductList.DataSource = ProductDataSource.AdvancedSearch(_Keywords, this.CategoryId, _ManufacturerId, true, true, true, 0, 0, _PageSize, startIndex, SortResults.SelectedValue);
Visit the links below to Download Plugins for your AC7 Store
http://www.plugables.com
http://blog.plugables.com
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: search on customer side.
Thanks, this works great.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: search on customer side.
yes, exactly what i needed! This takes me one step closer to going live!
Mike Keith
http://www.musicmart.com
http://www.musicmart.com
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: search on customer side.
Hello Judy,
It's a matter of speed of searching via text, we removed those extra fields per a bug report posted by me. Most customers are not searching via SKU.The search is pretty puny as it is now.
Re: search on customer side.
Yeah, but it really is great to be able to search by sku. Thanks again Mazhar.
Mike Keith
http://www.musicmart.com
http://www.musicmart.com
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
I actually need this in one more spot.
/Admin/Catalog/Search.aspx
Can we change that to have the ability to search by SKU?
/Admin/Catalog/Search.aspx
Can we change that to have the ability to search by SKU?
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
Addition.
I'd like to see if there was an easy way to implemete searching by SKU everywhere?
My entire staff/customer base pretty much uses SKU's instead of description.
I'd like to see if there was an easy way to implemete searching by SKU everywhere?
My entire staff/customer base pretty much uses SKU's instead of description.
- igavemybest
- Captain (CAPT)
- Posts: 388
- Joined: Sun Apr 06, 2008 5:47 pm
Re: search on customer side.
Didnt want this to get lost. Just wanted to rehash the last post.... Is there any way to search by squ everywhere?
Re: search on customer side.
If I do a search with a space before or after the SKU number,
no results show up. This is also true in the "Advanced Search".
This variable (and all search variables) needs to be trimed.
Can someone show me where I could add a "Trim" to this value? thanks
no results show up. This is also true in the "Advanced Search".
This variable (and all search variables) needs to be trimed.
Can someone show me where I could add a "Trim" to this value? thanks
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
Just recently noticed this.Mike718NY wrote:If I do a search with a space before or after the SKU number,
no results show up. This is also true in the "Advanced Search".
This variable (and all search variables) needs to be trimed.
Can someone show me where I could add a "Trim" to this value? thanks
I would like to see a fix for this and be able to search by SKU everywhere.
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
Bump for this week. Any thoughts?
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: search on customer side.
In SimpleSearch.ascx.cs, add .Trim() to the end of this line:
string safeSearchPhrase = StringHelper.StripHtml(SearchPhrase.Text).Trim();
string safeSearchPhrase = StringHelper.StripHtml(SearchPhrase.Text).Trim();
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: search on customer side.
Thanks Judy. Just got around to doing this. Worked great.
Another solution to this problem would be what I did:
Add the Sku to the SearchKeywords field:
UPDATE ac_Products
set SearchKeywords = (ISNULL(SearchKeywords + ' ', '') + CAST(Sku AS VARCHAR(50)))
Another solution to this problem would be what I did:
Add the Sku to the SearchKeywords field:
UPDATE ac_Products
set SearchKeywords = (ISNULL(SearchKeywords + ' ', '') + CAST(Sku AS VARCHAR(50)))
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
Any solutions on searching by SKU in the Admin/anywhere else?Mike718NY wrote:Thanks Judy. Just got around to doing this. Worked great.
Another solution to this problem would be what I did:
Add the Sku to the SearchKeywords field:
UPDATE ac_Products
set SearchKeywords = (ISNULL(SearchKeywords + ' ', '') + CAST(Sku AS VARCHAR(50)))
Re: search on customer side.
Yes. This is extremely useful. Thanks!
I agree that the benefits of searching by SKU well outweigh the speed disadvantages. I bet a lot of other AC customers would agree!
I agree that the benefits of searching by SKU well outweigh the speed disadvantages. I bet a lot of other AC customers would agree!
Re: search on customer side.
Yes! Yes, Making search by sku on the admin side would help. Now you have to search by sku on the advanced search of the retail side (if you didn't alter the search script), then the easiest way is to copy the name as it appears there and paste to the name search on the admin side. (Commas, apostrophies, quotes, etc.).
It would also be nice if the advanced search on the customer side had the ability to search "all words", "any words" or "string" like version 5 could.
Also, When you use the search on the customer side, there's are options for name, description or Sku, Do any of these options search "key words"?
And is there a way to eliminate searching by "price range"?
It would also be nice if the advanced search on the customer side had the ability to search "all words", "any words" or "string" like version 5 could.
Also, When you use the search on the customer side, there's are options for name, description or Sku, Do any of these options search "key words"?
And is there a way to eliminate searching by "price range"?
Mike Keith
http://www.musicmart.com
http://www.musicmart.com
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: search on customer side.
I made all the boxes checked when the page loads.
I still still SKU search on admin side.
I still still SKU search on admin side.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: search on customer side.
This is to revisit mazhar's code above. I just had a client point out that with that substitution the SimpleSearch.ascx will return products by SKU, but it also shows the message
Displaying items 0 - 0 of 0 and
No products match your search criteria.
The problem is around line 50
_SearchResultCount = ProductDataSource.NarrowSearchCount(_Keywords, this.CategoryId, _ManufacturerId, 0, 0);
where it is pulling from the NarrowSearchCount
The ProductDataSource.AdvancedSearch doesn't have a Count method. I've fooled around some trying to find the count of the results, but haven't come up with a way yet.
Anyone?
Thanks
Displaying items 0 - 0 of 0 and
No products match your search criteria.
The problem is around line 50
_SearchResultCount = ProductDataSource.NarrowSearchCount(_Keywords, this.CategoryId, _ManufacturerId, 0, 0);
where it is pulling from the NarrowSearchCount
The ProductDataSource.AdvancedSearch doesn't have a Count method. I've fooled around some trying to find the count of the results, but haven't come up with a way yet.
Anyone?
Thanks
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: search on customer side.
For the regular search field for when a customer searches, is there anyway to have it show either webpages or categories that don't have any products in them? For example, I have created categories that have webpages with amazon product widgets in them to complement the items that I do sell. These categories don't show up in the search, and I would like them to. I have removed the advanced search so this question is just for the regular search bar. Possible?
AC 7.0.7 build 14600
Re: search on customer side.
Only catalog search on admin side can list webpages. You can try to write some search module using that search function from CommerceBuilder.Catalog.CatalogDataSource.
Re: search on customer side.
Is this still true for 7.0.3?