Products filtering based on options (facets)

[gmonarque]

Hello,

I've been in the process of migrating a quite large ecommerce website to medusa V2.
There's a feature that's missing, I'd like to talk about it, and maybe know if it's something planned.

Product filtering is something essential, and particularly so when we're talking about catalogs with 20k+ SKUs available. Some product categories can have more than 3k SKUs, so filtering is essential for the customer to be able to find & buy what they're looking for.

What I want to achieve: Classic filtering, where I can filter by brand (using categories to define brands), by categories, and filter by options with an associated in-stock variant. For example, let's say that a given product category has 100 products. They all have a "Color" and a "Size" option name, with different option values. One would need an endpoint that returns the list of Option names and the list of option values associated with this category. Then, when applying the filter "Color: white", one would need medusa to return the updated option values for the "Size" option name where only the available sizes for the products where "Color: white" is returned. The classic filtering query logic is OR between option values of same option, and AND between options. "Color: white, green" "Size: S" would return products of color white or green that have an option / a variant with size S. Note that in my example, Size is an option the customer can choose from, while color is an attribute / filterable caracteristic of a product (implemented using product metadata)

I'm achieving this result using custom routes & custom SQL queries, but I'm sure I won't be the only one facing this issue.
Please let me know if I'm missing something, or if it's a plannes feature to integrate to the medusa product, or if it's something considered up to us to implement as I did.

Thanks!

[gmonarque]

I see that there is no reaction to my question, should I maybe reformulate?