Rank: Member
Joined: 9/21/2004(UTC) Posts: 97
|
Greetings ALL; Perhpas you can help me on a project.
I want to have clients click on button that will list products from a manufacturer. Essentially, if the button is click, it will show the same result as a person using the Advance Search and filtering based on manufacturer from the drop down list.
We are running version BV5.
Please advise.
Thanks.
Nolax
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Couldn't you just create a dynamic category that shows all products by a manufacturer and then link to that? |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 9/21/2004(UTC) Posts: 97
|
Hi Aaron: as always it seems that you are the one who is in a position to save the day. I have not gone that route as I have stayed away from dynamic categories which thought would be a potential performance issue when is performs the update. We currently have over 90,000 skus. I will look into it now that you have pointed it out. I am still wondering what keywords are supported by search.aspx. I know that: http://www.getfeetwet.com/search.aspx?keyword=crossbow will do a search but but interstingly enough, the URL will do some processing and then displays the advance search but does not list the result set. It does however have the keyword value shown on the advance search keyword field and if you click on the search button it will list the result set. Perhaps, the keyword parm is not really supported but seems like the system was actually performing a search and passes parm to advance search keyword field. I appreciate your thoughts on this. Nolan
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "nolax" I am still wondering what keywords are supported by search.aspx. I know that: http://www.getfeetwet.com/search.aspx?keyword=crossbowwill do a search but but interstingly enough, the URL will do some processing and then displays the advance search but does not list the result set. It does however have the keyword value shown on the advance search keyword field and if you click on the search button it will list the result set. Perhaps, the keyword parm is not really supported but seems like the system was actually performing a search and passes parm to advance search keyword field. I suspect that you're hitting a server timeout. The BV search is very inefficient and does not perform well when searching many fields (especially the Long Description) and/or if you have a lot of products (like 90,000). We've actually developed an improved search that we may offer to the community. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 12/23/2003(UTC) Posts: 909
|
[quote="Aaron"] We've actually developed an improved search that we may offer to the community.Don't want to hijack this thread but I'm all ears. |
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "Matt@9BallDesign" Originally Posted by: "Aaron" We've actually developed an improved search that we may offer to the community.
Don't want to hijack this thread but I'm all ears. I'm such a tease, aren't I? :smilewinkgrin: |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 9/21/2004(UTC) Posts: 97
|
Greetings:
Just want to give an update on where we are at with the project. I revisited the dynamic category and I think it is a very viable option. I can't seem to however find an option to manually referesh all the categories at one time. I did see the dynamic category scheduling option in the Options section of the admin console which is good but still concern about the timing of the refresh.
It did however led to coding SQL to create categories programmatically and then add the productxcategory items using the feed from various vendors. This way we can just add the section of code to the batch updates we do to refresh product information. We do not have to identify what new vendors have been added by the distributor or manufacturer. I can also control the refresh or the rebuild of the whole category list.
Thanks to Aaron, we had to re-think using the category list as an approach versus search results. When you think about it, the category list will be much much more efficient specialy with a huge number of SKUs since it does not have to go through the thousands of SKUs which a search will do every time the button is clicked. If you have dozens of clients clicking the search to list product from a given manufacturer, then it can really be a resource hog. Category list just lists them without have to read through each data on sku, productname, etc.
Aaron, I would like to hear more about the search engine you have developed.
Nolan
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Glad to hear things are working out for you, Nolan! Originally Posted by: "nolax" I can't seem to however find an option to manually referesh all the categories at one time. Just click the "Regenerate Dynamic Categories" text link on the Categories page in the admin. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 9/21/2004(UTC) Posts: 97
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.