Issue with Query Loop for WooCommerce Sale Products

Hi everyone,

I’m trying to display sale products using Bricks Builder but getting no results, even though they exist in my WooCommerce store. My query setup in Bricks is:

  • Post Type: Products
  • Meta Query: _sale_price, EXISTS, NUMERIC

I tried both with meta_value > 0 and without any value, just EXISTS, but still no results.

I verified with this SQL query, which returns the expected products:

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE meta_key = '_sale_price' 
AND meta_value > 0;

Any ideas why Bricks isn’t returning these products?