Skip to content

Instantly share code, notes, and snippets.

@lmartins
Created October 8, 2014 08:44
Show Gist options
  • Save lmartins/d92465daeda6a6a5e322 to your computer and use it in GitHub Desktop.
Save lmartins/d92465daeda6a6a5e322 to your computer and use it in GitHub Desktop.
WooCommerce custom loop for products on-sale
<?php
$args = array(
'post_type' => 'product',
'meta_query' => array(
'relation' => 'OR',
array( // Simple products type
'key' => '_sale_price',
'value' => 0,
'compare' => '>',
'type' => 'numeric'
),
array( // Variable products type
'key' => '_min_variation_sale_price',
'value' => 0,
'compare' => '>',
'type' => 'numeric'
)
)
);
$featured_query = new WP_Query( $args );
if ($featured_query->have_posts()) :
?>
<ul class="products">
<?php
echo "<h3>" . __("On Sale now") . "</h3>";
if ( $featured_query->have_posts() ) {
while ( $featured_query->have_posts() ) : $featured_query->the_post();
woocommerce_get_template_part( 'content', 'product' );
endwhile;
} else {
echo __( 'No products found' );
}
wp_reset_postdata();
?>
</ul><!--/.products-->
<?php endif; ?>
@marvlas
Copy link

marvlas commented Jan 20, 2021

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment