All Submissions:

• Have you followed the WooCommerce Contributing guideline?
• Does your code follow the WordPress' coding standards?
• Have you checked to ensure there aren't other open Pull Requests for the same update/change?

Changes proposed in this Pull Request:

The price filtering query wasn't working properly when there are variations with different prices: if at least one variation was
outside of the price range but other were inside, the product wasn't being listed.

This pull request fixes the generation of the where clause in WC_Query->price_filter_post_clauses to account for this case.

Closes #25261

How to test the changes in this Pull Request:

Create a variable product having two variations with prices 1000 and 1200. Install the price filtering widget and try the following combinations of min and max price:

1. 0, 950
2. 0,1000
3. 0, 1050
4. 1000, 1100
5. 1050, 1100
6. 1050, 1300
7. 1200, 1300
8. 1250, 1300

The product should not be listed in the cases 1 and 7, in all the other cases it should be listed.

Note: if you don't have products with a price higher than 1220 you won't be able to use the widget for the last three combinations, but you can just modify the query string and reload manually.

Note: that's not a complete fix and will 100% work only when the "Hide out of stock products" option is disable. See this comment in the original issue.

Other information:

• Have you added an explanation of what your changes do and why you'd like us to include them?
• Have you written new tests for your changes, as applicable?
• Have you successfully run tests with your changes locally?

Changelog entry

Fix - price filtering not working properly with variable products whose variations have different prices.