Create a query based based on price

[Kevin205]

Is there a way to create a query to display a listing page for products from a particular category/sub-category; which the product prices are less than a certain dollar amount?

[lat9]

Where does the "category/sub-category" value get set? Is it a cPath specification, e.g. category 1/subcategory 5 represented as 1_5?

[Kevin205]

Thanks for the reply.

Yes it is cPath specific.

http: // MyDomain . com/index.php?main_page=index&cPath=22
or
http: // MyDomain . com/index.php?main_page=index&cPath=22_10

[gjh42]

Is this a completely stand-alone page you want, or more like limiting the category page to just a certain price range on demand?

If the latter, it would pretty much be a matter of inserting something like a " and products_price < xx" in the "where" clause of an existing query.

[Kevin205]

Is this a completely stand-alone page you want, or more like limiting the category page to just a certain price range on demand?

If the latter, it would pretty much be a matter of inserting something like a " and products_price < xx" in the "where" clause of an existing query.

It would be wonderful to have a stand alone page! I just don't know how involved that would be?

But for now limiting the display of category page for product prices less than xx.xx would just do.

Can this be done from URL? Or is it more involved than that?

Don't laugh, but I tried this and did not produce anything.
index.php?main_page=index&cPath=22_10&products_price%3C50.00 (%3C is <)

Thanks Glen.

[gjh42]

Not possible from the URL. You would have to alter a query in the file that fetches the listing content. If you want to allow user choice of filtered or unfiltered, or even better the price breakpoint, you would have to additionally build a form that would re-call the page with the new info in the URL, which you would build code to extract and use in the query (with appropriate sanitization so a user couldn't input something malicious).

The "standalone page" you would like would still be a category listing page, wouldn't it? Or would it be a special "low-price" page that would not look like a standard page? In either case you would use the product listing page as a base, to clone and modify for the special page, or to add conditional code to use the limit on the standard page.

[Kevin205]

Got it thanks.