Frontend missing

The sale prices aren’t actually being changed in the database, it is happening on the fly based on the promotion configuration.

We added a new attribute to the products shortcode called pw_black_friday. To use it, append the pw_black_friday attribute to your products shortcode. For example:

[products limit="4" columns="2" pw_black_friday="8" ]

This will show 4 products in 2 columns from the Black Friday event “8”. For more information on the products shortcode, follow this link:
https://docs.woocommerce.com/document/woocommerce-shortcodes/

Note: to get the Black Friday ID, click on the Deal inside the event to edit it. You will see the ID in your browser bar.

Thank you for the answer.

What about if I’m using Elementor ?

The only way to obtain the list of the reduced products is using the woocommerce products shortcode ?

That’s correct, the sale prices themselves are not changed in the database so you can’t query on the sale price field. The sale price is changed using the WooCommerce hooks.

Marking this thread as resolved, let us know if you need anything else. Best of luck with your store!