I'd like to understand how price filter works on configurable products.

Let's say I have one config. products with 2 linked simple products.

The simple product prices are 100$ and 200$, so that the configurable one base price will be 100$.

Let's say customers filter price from 150$ to 200$.

Will that product be listed?

If not, how to show it?

Hope I was clear. Thank you guys


This information is stored in the catalog_product_price_index table as min_price and max_price. So, yes, it should be listed.

| improve this answer | |
  • thanks, but do I have to change magento filter funcionality? – Antonio Pedicini May 11 '15 at 17:12
  • You shouldn't have to change anything. That query is generated by default if you are using layered navigation. – Kevin Schroeder May 11 '15 at 17:21
  • I've investigated on the query and it seems exclude those results because the it is like 'where min_price >= $minprice and $max_price <= $maxprice'. So I think the filtering query should be modified. – Antonio Pedicini May 12 '15 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.