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

1 Answer 1


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

  • thanks, but do I have to change magento filter funcionality?
    – apedic
    Commented May 11, 2015 at 17:12
  • You shouldn't have to change anything. That query is generated by default if you are using layered navigation. Commented May 11, 2015 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.
    – apedic
    Commented May 12, 2015 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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