cancel
Showing results for 
Search instead for 
Did you mean: 

Use query on CMS page to find products based on price range and specific category

Use query on CMS page to find products based on price range and specific category

Hi Everyone,

 

I'm struggling with a query I use on the landing page. 

The code below shows an image and brings the user to a list of product with a max of 25 euro's.

 

But this only works when those products are listed in the 'default category'. The products I have only in a subcategory won't show as a result. How can I add an extra constraint to search on price + specific category (ID)? 

 

 I'm using magento CE 1.9.1.1   

 

Current query :

 

<a href="{{store url="catalogsearch/advanced/result" _query="price[from]=0&price[to]=25"}}"><img src="media/wysiwyg/design/tot25.gif"></a>

 

N.B. If anyone has a list of example queries to use on a CMS page that would be great! I can't seem to find it.

 

Thanks!  

 

1 REPLY 1

Re: Use query on CMS page to find products based on price range and specific category

Is there nobody around here who has a clue how to solve this?

 

Once I add all my products to the most top 'default category' they're found by the query. 

But that's gonna be a mess.

 

For example:

Default Cat  (this would have 700 products! , while i rather have 0 )

-- SubCat 1 (100 products)

-- Subcat 2 (600 products)

-- etc