Prestashop 1.7.2 has a filter named Faceted Filter. To add 3 new features an extension was developed but there are some small details to emend and a crucial MySQL queries optimization. The way the MySQL queries were written take too much time to return the results.
This extension makes possible the link between a compatibility list and the products so the customer can filter products, using the faceted filter, according to a compatible device (brand and model).
All files will be made available.
So, this project consists on:
1 - MySQL: correct optimize the queries
2 - FrontOffice->FacetedFilter->Extension->Listbox: present values alphabetically ordered
3 - FrontOffice->FacetedFilter->Extension->KeyWordFilter: correct / normalize the way filter is applied