lmartins
10/8/2014 - 8:44 AM

WooCommerce custom loop for products on-sale

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; ?>