I am using a product query loop to display products. I only want to show products on sale, which works well in the builder, but on the actual page and on the frontend, the page shows all products, including those not on sale. It is still a staging website, so the products are just test products, but I don’t really understand why it would act like that.
Please enable the “Disable query merge” toggle and see if it works. Your query may be merged with another one. Alternatively, try the “Is main query (Archive, Search)” toggle.