Filter query not working

We have selected “OR” for the size filter, and even though we have it enabled properly, it allows multiple sizes to be selected.

I’ve attached a screenshot and shared the credentials.

Also, our site seems to be running extremely slow on the backend due to the high amount of table searches the filter functionality is doing. This is one of the reasons we’re going to limit the sizes to be an “OR” type of query, but if you have any insights, it would be greatly appreciated. I’m attaching a log of the queries as well.

It’s a live site so please be careful with any testing. Thanks!

Attachments:

You must be logged in to view attached files.

Hello,

The access is not working, please update it and let me know – https://monosnap.com/file/PnWicW7ksrFXYOM0QOpVi3BZeeG6jC

Thank you for your time.

Kind Regards

Hey Luke, try now with those same credentials.

Thanks,
Axel

Hello,

After thoroughly checking your website, we did not find any significant difference in page load speed when using either “OR” or “AND” logic in the attribute filter. In both cases, the server response time was around 2 seconds, which is a normal indicator considering your current hosting configuration and the volume of data in the database.

We would also like to point out that the product filtering mechanism by attributes is implemented by the WooCommerce core, not the theme. Our theme does not interfere with the database query logic in this case and does not affect how the filtering is formed or executed. You can easily verify this by activating the default “Product attributes” widget from WooCommerce — its behavior will be the same regardless of the active theme.

Kind Regards

Hey Luke,

I see! We’re not trying to improve the load time on the frontend, but the site’s backend was very slow. We did a lot of optimizing to the database and the queries loaded to improve on that, and one of the things we wanted to improve was the amount of lookups the site did to the variations table, thus why we want the OR functionality to work.

When you did your tests, did the OR functionality worked or was it allowing you to pick multiple sizes anyways?

Please let me know!

Hello,

Yes, during testing the “OR” functionality worked correctly — it allows selecting multiple sizes, and this is the expected behavior. In this mode, the filter displays all products that match any of the selected attributes.

Kind Regards

[Author]

Posts