Price filter on configurable products

Question

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

Kevin Schroeder · Accepted Answer · 2015-05-11 15:19:40Z

1

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

answered May 11, 2015 at 15:19

Kevin Schroeder

4172 silver badges8 bronze badges

thanks, but do I have to change magento filter funcionality?
– apedic
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.
– Kevin Schroeder
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
May 12, 2015 at 8:18

Add a comment |

1 Answer 1