On-Sale Products
Create a sale collection using WooCommerce's on-sale product IDs. The provider discovers eligible products; it does not create discounts or change cart prices.
Enable and Prepare
- Activate WooCommerce and BricksUltimate.
- Open Bricks → BricksUltimate → Misc, enable Ultimate Woo Query Builder, and save.
- Reopen the Bricks editor so the query options refresh.
Set a regular price and a lower sale price on the product or its variations. If the sale is scheduled, verify that it is currently active and the site's scheduled tasks are running.
Create the Query Loop
- Add an outer Section or Block for the heading and layout. Keep the section heading outside the repeated item.
- Add an inner Block for one product card and enable Use query loop on that Block.
- Choose Ultimate Woo Query Builder as the query Type, then choose On-Sale Products under Woo query type.
- Enable Disable query merge where offered so the current page's main query does not unexpectedly constrain this custom collection.
- Configure the controls below and place the record's dynamic elements inside the repeated Block.
- Save and test on the frontend. Builder sample content is not a substitute for the live query result.
Controls and Behavior
| Control | How to use it |
|---|---|
| Number of items to show | Limit the collection; default: 3. |
| Category(IDs) / Category operator | Restrict active sale products to selected category IDs. |
| Hide out of stock products | Hide sold-out sale products or retain them intentionally. |
| Show hidden products | Leave No unless the design deliberately includes hidden products. |
| Hide free products | Set No explicitly if products reduced to zero should appear. An unset value excludes them in the current code. |
| Order by / Order | Choose Price for a low-price-first sale shelf, Date for recent products, or another available sort and direction. Price sorts the current stored price, not the discount percentage. |
Design the Product Card
Inside the repeated Block, add a Product Image, a heading using the current product title, a product permalink, a WooCommerce price element, and a suitable add-to-cart control. Choose dynamic sources from the current loop item, not a hard-coded product. Keep the whole layout in the same product loop so image, title, price, and purchase action refer to the same product.
Set the outer wrapper to grid or flex, define responsive columns, and style one card. For a slider, use Slider (Nestable) and repeat its slide Block instead of repeating the whole slider. Configure slider arrows and breakpoints separately. Avoid nesting interactive buttons inside a fully linked card.
Variable Products and Sale Badges
WooCommerce calculates the on-sale IDs, including sale relationships for variable products. The normal visibility filter keeps the collection focused on parent catalog products. Use a variation-aware Products query if you need a dedicated variation listing. Add a Sales Badge element separately if you want a visual savings label.
Practical Example
Build a six-item Sale grid filtered to a category ID. Choose Order by Price and ASC to show the lowest current prices first. Use a price element that displays the regular and sale price together.
Scope and Limitations
Coupon discounts, automatic fees, and cart-only promotions do not make a product an on-sale product for this query. There is no built-in minimum-saving filter or sale-end countdown. Treat this as a limited collection rather than a complete faceted sale archive.
Troubleshooting and Testing
A future or expired scheduled sale is not an active sale. If a valid sale does not appear, check stock and zero-price filters, product visibility, WooCommerce sale transients, scheduled task health, and page caches.
Test the populated and empty states, desktop and mobile layouts, and any relevant AJAX refresh. Keep headings and decorative wrappers from leaving empty gaps when no eligible results exist. If a query type is missing, verify the feature toggle, WooCommerce activation, and editor reload before changing the layout.