linux4me2

@roeljonker I’m glad that works for you!

I don’t know if the WooCommerce developers would consider this a bug. I think it falls into the category of a “feature.” The code looks like they intended to leave “In Stock” out.

It seems like adding an option in the Settings or in Appearance -> Customize -> WooCommerce to display the “In Stock” would be a nice thing to have. There is a WooCommerce Feature Request Forum that I believe is still active where you could suggest it, or maybe on their GitHub Page as an enhancement. If you do, please post the link here and I will vote for it. 🙂

Interesting. It looks like it might be the difference with using Blocks.

I tried using a products shortcode, and I got the unordered list layout like you have on your Shop page. You might give that a try on your Home page instead of Blocks. There are shortcodes to reproduce each section you currently have on your Home page.

I have to say, your Home page doesn’t look bad to me at all, though you need some images for your categories to spice it up. 🙂

You could add the following to Appearance -> Customize -> Additional CSS to get rid of the underlines on the “Select Options” buttons to make it look more like the Shop page if you decide to go with the Blocks:

.hentry .entry-content a:not(.button):not(.components-button) {
	text-decoration: none;
}

I figured it out! I was using the wrong slug for the parent menu. I found the answer using the code contributed by Aurovrata Venet on the remove_submenu_page in the Codex to find the correct slug:

global $submenu;
error_log(print_r($submenu, true));

With that information, the code to hide the “Reports” submenu is:

function custom_menu_page_removing() {
  remove_submenu_page('woocommerce', 'wc-reports');
}
add_action('admin_menu', 'custom_menu_page_removing', 110);

That removed the “Reports” submenu for me with and without the new Analytics disabled.

With variable products too, it would just use an array for the post_type:

add_shortcode( 'scheduled_sale_products', 'scheduled_sale_products_shortcode' );
	function scheduled_sale_products_shortcode($atts) {
		extract( shortcode_atts(array('limit' => '', 'columns'=>'' ), $atts));
		$columns = ! empty($atts['columns'] ) ? $atts['columns'] : 3;
		
		//echo 'Products on sale: ' . implode( ',', wc_get_product_ids_on_sale() ) . '<br>';
		//echo 'From time = ' . current_time('timestamp', 1) . '<br>';
		
		$args = array(
			'post_type'=>array('product', 'product_variation'),
			'post_status' =>'publish', 
			'post_in'=>implode( ',', wc_get_product_ids_on_sale() ), 
			'posts_per_page'=>$atts['limit'],
			'meta_query'=>array(
				'relation'=>'AND',
				array(
					'key' =>'_sale_price_dates_from',
					'value' =>current_time( 'timestamp', 1 ),
					'compare'=>'>',		
				),
				array(
					'key'=>'_sale_price_dates_to',
					'value'=>current_time( 'timestamp', 1 ),
					'compare'=>'>',		
				),
			),
		);
	
		$loop = new WP_Query( $args );
	
		if ( $loop->have_posts() ) {
			?>
			<ul class ="products columns-<?php echo $columns; ?>">
			<?php
				while ($loop->have_posts()) : $loop->the_post();
					woocommerce_get_template_part( 'content', 'product' );
				endwhile;
			?>
			</ul>
			<?php
			}
			else
				echo __('No products found');
		
			wp_reset_postdata();
	}

Give this a try:

add_shortcode( 'scheduled_sale_products', 'scheduled_sale_products_shortcode' );
	function scheduled_sale_products_shortcode($atts) {
		extract( shortcode_atts(array('limit' => '', 'columns'=>'' ), $atts));
		$columns = ! empty($atts['columns'] ) ? $atts['columns'] : 3;
		
		//echo 'Products on sale: ' . implode( ',', wc_get_product_ids_on_sale() ) . '<br>';
		//echo 'From time = ' . current_time('timestamp', 1) . '<br>';
		
		$args = array(
			'post_type'=>'product',
			'post_status' =>'publish', 
			'post_in'=>implode( ',', wc_get_product_ids_on_sale() ), 
			'posts_per_page'=>$atts['limit'],
			'meta_query'=>array(
				'relation'=>'AND',
				array(
					'key' =>'_sale_price_dates_from',
					'value' =>current_time( 'timestamp', 1 ),
					'compare'=>'>',		
				),
				array(
					'key'=>'_sale_price_dates_to',
					'value'=>current_time( 'timestamp', 1 ),
					'compare'=>'>',		
				),
			),
		);
	
		$loop = new WP_Query( $args );
	
		if ( $loop->have_posts() ) {
			?>
			<ul class ="products columns-<?php echo $columns; ?>">
			<?php
				while ($loop->have_posts()) : $loop->the_post();
					woocommerce_get_template_part( 'content', 'product' );
				endwhile;
			?>
			</ul>
			<?php
			}
			else
				echo __('No products found');
		
			wp_reset_postdata();
	}

The shortcode will now be:

[scheduled_sale_products limit=12 columns=3]

There were a couple of problems with the original code. One was a typo in 'post__in' which had an extra underscore in the original code and was causing a MySQL error, and the other was with the handling of the operators in the times. I also removed some code that wasn’t used. It’s working for me to display a simple product that is scheduled for being on sale in the future. That code doesn’t work on variable products for me. I also added a parameter to the query to display only published products. On my test site using Twenty Sixteen, the layout is obviously going to need to be tweaked, but hey, it works now. 🙂

I don’t understand how this is going to help you, because it doesn’t show the date the product is coming on sale, but maybe that’s what you want?

• This reply was modified 6 years, 2 months ago by linux4me2.

It’s not my code, but just a quick look at the original code that @yazdaniwp gave you makes me wonder if the problem might be with the operator in this section:

array(
  'key'     => '_sale_price_dates_to',
  'value'   => current_time( 'timestamp', 1 ),
  'compare' => '<',		
  ),

I’d try changing it to greater than the current time to see if you get the expected results.

I think to call that function, you’d have to make the WooCommerce functions global. You might try the current, wc version, which shouldn’t require a global:

'post__in' => implode( ',', wc_get_product_ids_on_sale() )