NO BUG: Show only on sale products in query - query not showing variable products

So I went through different variants to add meta and/or taxonomy queries but the Bricks query element refuses to show variable products and only shows simple products. It should be easy with “_min_variation_sale_price” but yeah …

What I have tried already:

Relation: AND

Meta Query 1:
Key: _sale_price

or

Meta Query 1:
Key: _min_variation_sale_price
Compare: EXISTS

Meta Query 2:
Key: _sale_price

or

Meta Query 1:
Key: _sale_price

Meta Query 2:
Key: _min_variation_sale_price
‘value’ => 0,
‘compare’ => ‘>’,
‘type’ => ‘NUMERIC’

and several other combos…

Hi Mike,
Thanks so much for your report!

Please take a look here: NO BUG: Sale products in query Loop - #4 by timmse

The “on-sale” toggle mentioned is currently “in review”, i.e., it will probably be included in one of the next versions.

Best regards,
timmse