How to set up a search by price sold.

[dmsid]

Any tricks or ideas on how to set up a seach by price sold?

By Price:
Under $5
$5 to $10
$10 to $15
$15 to $20
$20 to $25
$25 to $50
$50 to $75
$75 to $100
$100 to $150
$150 to $200
Over $200
more

Here is an example on a live site.
http://www.sptrains.com/search/nav.php? ... =y&Scale=N

This is very cool as it even shows you the amount of items in a category and it has bread crumbs, etc.

I know that will never happend in Shopsite, but how about a way to search.

All the best,
-Jon

[robm]

You could put special codes in an extra product field (i.e. 5to10, 10to15, etc...) and then on your search page where the custom can choose a search, you could set a dropdown with the field name of "search_field" and set the values for each option to match a code in your extra product field (with a space at the end). i.e.:

Code: Select all

Restrict search by: <select name="search_field">
<option value="">None
<option value = "5to10 ">$5 to $10
...
...
</select>
Search: <input type="text" name="search_field">


This would restrict the search term to the special code that matches an extra product field (as long as you set ShopSite to index that extra product field).

I haven't tested this but hopefully it gives you some ideas.

[avalonwine]

I use pulldowns with each price level named (under $30, $30-$45m etc) and point each pulldown menu to a page with those items. When I add an item I put it on the page appropriate to its price. Cumbersome, but it works, and you can search the product list by price in the backoffice, making it fairly fast to do the page assignments.

Here's a page
"pinot noir under $30"

http://www.northwest-wine.com/Oregon-Pi ... llars.html

Jean

[RedSyntax]

i know the owner of the trains site had alot of custom work done, my question is how was he able to assemble the products on the fly?

That kind of functionality should be standard and apart of any Cart system.

[RedSyntax]

How is he querying the database? and retrieving the results? then how is he passing the value to the productsearch.cgi. it looks like he's totally by passing the product search all together.