Leaf out "sold out products" when inserting products in post

[Patipada]

Hi,
I have inserted a box with best seller products from specific categories, but the most best selling products are out of stock:
https://littlegreeny.nl/draagconsulent-zwolle/.
See at the bottom of this page.

Is there a way to leave out all products that are out of stock?

[Mohammad – SUPPORT]

Hi,
1- Go to Woocommerce > Settings and click the Products tab.

2- Click the Inventory link at the top.

3- Check the Out Of Stock Visibility option to hide out of stock items.

Thanks
Mohammad

[Patipada]

Hi Mohammad,
Thanks for the quick reply.
I know about this option. The thing is this also hides the out of stock products in the product-categories.
But I wan’t to hide them only in my blogpost where I use the Swift Builder option to insert the best selling products.
Is this possible?

[Mohammad – SUPPORT]

Hi,
Please paste this code at functions.php of child theme.

function sf_product_items( $atts ) {

			extract( shortcode_atts( array(
			    'title'          => '',
			    'asset_type'     => '',
			    'category'       => '',
			    'products'		 => '',
			    'display_layout' => '',
			    'display_type'	 => '',
			    'carousel'       => '',
			    'multi_masonry'	 => '',
			    'fullwidth'      => '',
			    'gutters'        => '',
			    'columns'        => '',
			    'item_count'     => '',
			    'order_by'		 => '',
			    'order'			 => '',
			    'button_enabled' => '',
			    'width'          => '',
			), $atts ) );
			
            global $woocommerce, $woocommerce_loop, $sf_sidebar_config, $sf_carouselID, $sf_options, $sf_product_multimasonry, $sf_product_display_layout;

            if ( $sf_carouselID == "" ) {
                $sf_carouselID = 1;
            } else {
                $sf_carouselID ++;
            }

            if ( is_singular( 'portfolio' ) ) {
                $sf_sidebar_config = "no-sidebars";
            }

            $list_class           = "";
            $product_display_type = $sf_options['product_display_type'];

            if ( $display_type != "" ) {
            	$product_display_type = $display_type;
            }

            if ( $fullwidth == "yes" ) {
                $list_class .= 'products-full-width ';
            }
            if ( $gutters == "no" || $product_display_type == "gallery-bordered" ) {
                $list_class .= 'no-gutters ';
            }
			if ( $multi_masonry == "yes" && $product_display_type != "preview-slider" && $asset_type != "categories" ) {
				$carousel = "no";
				$list_class .= 'multi-masonry-items ';
				$sf_product_multimasonry = true;
			} else {
				$sf_product_multimasonry = false;
			}
			
			if ( $display_layout != '' ) {
				$sf_product_display_layout = $display_layout;
			}

            if ( $carousel == "no" && $multi_masonry == "no" ) {
                $list_class .= 'product-grid ';
            }

            $list_class .= 'product-type-' . $product_display_type . ' ';

			$woocommerce_loop['style-override'] = $product_display_type;

			$args = array();

            $sf_prev_icon = apply_filters( 'sf_carousel_prev_icon', '<i class="ss-navigateleft"></i>' );
            $sf_next_icon = apply_filters( 'sf_carousel_next_icon', '<i class="ss-navigateright"></i>' );

            // CATEGORY ASSET OUTPUT
        	if ($asset_type == "categories") {

        		ob_start();

        		$hide_empty = 1;
				$category_id = '';
				$ids = array();
				
				if ( $category != "" ) {
					$category = str_replace( "0,", "", $category );		
					$categories = explode( ',', $category );			
	       			foreach ($categories as $term) {
	       				$category_term = get_term_by('slug', $term, 'product_cat');
	       				$category_id = $category_term->term_id;
	       				array_push($ids, $category_id);
        			}
        		}
        		        		
        		$args = array(
        			'hide_empty' => $hide_empty,
        			'pad_counts' => true,
        			'include'    => $ids,
        		);

        		$product_categories = get_terms( 'product_cat', $args );

        		if ( $hide_empty ) {
        			foreach ( $product_categories as $key => $category ) {
        				if ( $category->count == 0 ) {
        					unset( $product_categories[ $key ] );
        				}
        			}
        		}

        		if ( $item_count ) {
        			$product_categories = array_slice( $product_categories, 0, $item_count );
        		}

        		ob_start();

        		if ( $product_categories ) {

        			if ( $carousel == "yes" ) { ?>

	                    <div class="product-carousel carousel-wrap <?php echo $list_class; ?>">

	                        <ul class="products list-<?php echo $asset_type; ?> carousel-items gutters" id="carousel-<?php echo $sf_carouselID; ?>" data-columns="<?php echo $columns; ?>">

	                            <?php

                    			foreach ( $product_categories as $category ) {

                    				wc_get_template( 'content-product_cat.php', array(
                    					'category' => $category
                    				) );

                    			}

								?>

	                        </ul>

	                        <?php if ( sf_theme_opts_name() != "sf_atelier_options" ) { ?>

	                        <a href="#" class="carousel-prev"><?php echo $sf_prev_icon; ?></a>
	                        <a href="#" class="carousel-next"><?php echo $sf_next_icon; ?></a>

							<?php } ?>

	                    </div>

	                <?php } else { ?>

	                    <ul class="products list-<?php echo $asset_type; ?> row <?php echo $list_class; ?>">

	                        <?php

                    			foreach ( $product_categories as $category ) {

                    				wc_get_template( 'content-product_cat.php', array(
                    					'category' => $category
                    				) );

                    			}

                    		?>

	                    </ul>

	                <?php }

        		}

        		woocommerce_reset_loop();
        		$product_list_output = ob_get_contents();
        		ob_end_clean();

        		wp_reset_query();
        		wp_reset_postdata();

        		return $product_list_output;
        	}

            // ARRAY ARGUMENTS
            if ( $asset_type == "latest-products" ) {
                $args                 = array(
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'product_cat'         => $category,
                    'ignore_sticky_posts' => 1,
                    'posts_per_page'      => $item_count,
                    'orderby'             => $order_by,
                    'order'				  => $order
                );
                $args['meta_query']   = array();
                $args['meta_query'][] = $woocommerce->query->stock_status_meta_query();
                $args['meta_query'][] = $woocommerce->query->visibility_meta_query();
            } else if ( $asset_type == "featured-products" ) {
                $args = array(
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'product_cat'         => $category,
                    'ignore_sticky_posts' => 1,
                    'meta_key'            => '_featured',
                    'meta_value'          => 'yes',
                    'posts_per_page'      => $item_count,
                    'orderby'             => $order_by,
                    'order'				  => $order
                );
            } else if ( $asset_type == "top-rated" ) {
                add_filter( 'posts_clauses', array( $woocommerce->query, 'order_by_rating_post_clauses' ) );

                $args               = array(
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'product_cat'         => $category,
                    'ignore_sticky_posts' => 1,
                    'posts_per_page'      => $item_count,
                    'orderby'             => $order_by,
                    'order'				  => $order
                );
                $args['meta_query'] = $woocommerce->query->get_meta_query();

            } else if ( $asset_type == "recently-viewed" ) {

                // Get recently viewed product cookies data
                $viewed_products = ! empty( $_COOKIE['woocommerce_recently_viewed'] ) ? (array) explode( '|', $_COOKIE['woocommerce_recently_viewed'] ) : array();
                $viewed_products = array_filter( array_map( 'absint', $viewed_products ) );

                // If no data, quit
                if ( empty( $viewed_products ) ) {
                    return '<p class="no-products">' . __( "You haven't viewed any products yet.", "swiftframework" ) . '</p>';
                }

                // Create query arguments array
                $args = array(
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'product_cat'         => $category,
                    'ignore_sticky_posts' => 1,
                    'posts_per_page'      => $item_count,
                    'no_found_rows'       => 1,
                    'post__in'            => $viewed_products,
                    'orderby'             => $order_by,
                    'order'				  => $order
                );

                // Add meta_query to query args
                //$args['meta_query'] = array();

                // Check products stock status
                //$args['meta_query'][] = $woocommerce->query->stock_status_meta_query();

            } else if ( $asset_type == "sale-products" ) {
                // Get products on sale
                $product_ids_on_sale = wc_get_product_ids_on_sale();

                $meta_query   = array();
                $meta_query[] = WC()->query->visibility_meta_query();
                $meta_query[] = WC()->query->stock_status_meta_query();
                $meta_query   = array_filter( $meta_query );

                $args = array(
                    'product_cat'    => $category,
                    'posts_per_page' => $item_count,
                    'no_found_rows'  => 1,
                    'post_status'    => 'publish',
                    'post_type'      => 'product',
                    'meta_query'     => $meta_query,
                    'orderby'        => $order_by,
                    'order'			 => $order,
                    'post__in'       => array_merge( array( 0 ), $product_ids_on_sale )
                );
            } else if ( $asset_type == "selected-products" ) {

	            $meta_query   = array();
	            $meta_query[] = WC()->query->visibility_meta_query();
	            $meta_query[] = WC()->query->stock_status_meta_query();
	            $meta_query   = array_filter( $meta_query );

				$product_ids = explode(',', $products);
	            $args = array(
	                'posts_per_page' => -1,
	                'no_found_rows'  => 1,
	                'post_status'    => 'publish',
	                'post_type'      => 'product',
	                'meta_query'     => $meta_query,
	                'orderby'        => $order_by,
	                'order'			 => $order,
	                'post__in'       => array_merge( array( 0 ), $product_ids )
	            );
            } else {
                $args = array(
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'product_cat'         => $category,
                    'ignore_sticky_posts' => 1,
                    'posts_per_page'      => $item_count,
                    'meta_key'            => 'total_sales',
                    'orderby'             => 'meta_value_num',
                    'meta_query'          => array(
                        array(
                            'key'     => array('_visibility','_stock_status'),
                            'value'   => array( 'catalog', 'visible','instock' ),
                            'compare' => 'IN'
                        )
                    )
                );

                $args['meta_query']   = array();
                $args['meta_query'][] = $woocommerce->query->stock_status_meta_query();
                $args['meta_query'][] = $woocommerce->query->visibility_meta_query();
            }

            ob_start();

            // OUTPUT PRODUCTS
            $products = new WP_Query( $args );

            // Set Columns
            $woocommerce_loop['columns'] = apply_filters( 'loop_shop_columns', intval( $columns ) );

            if ( $products->have_posts() ) {
                ?>

                <?php if ( $carousel == "yes" ) { ?>

                    <div class="product-carousel carousel-wrap <?php echo $list_class; ?>">

                        <ul class="products list-<?php echo $asset_type; ?> carousel-items gutters" id="carousel-<?php echo $sf_carouselID; ?>" data-columns="<?php echo $columns; ?>">

                            <?php while ( $products->have_posts() ) : $products->the_post(); ?>

                                <?php woocommerce_get_template_part( 'content', 'product' ); ?>

                            <?php endwhile; // end of the loop. ?>

                        </ul>

                        <?php if ( sf_theme_opts_name() != "sf_atelier_options" && sf_theme_opts_name() != "sf_uplift_options" ) { ?>

                        <a href="#" class="carousel-prev"><?php echo $sf_prev_icon; ?></a>
                        <a href="#" class="carousel-next"><?php echo $sf_next_icon; ?></a>

						<?php } ?>

                    </div>

                <?php } else { ?>

                    <ul class="products list-<?php echo $asset_type; ?> row <?php echo $list_class; ?>" data-columns="<?php echo $columns; ?>">

                    	<?php if ( $multi_masonry == "yes" ) { ?>

                    		<div class="clearfix product col-sm-3 grid-sizer"></div>

                    	<?php } ?>

                        <?php while ( $products->have_posts() ) : $products->the_post(); ?>

                            <?php woocommerce_get_template_part( 'content', 'product' ); ?>

                        <?php endwhile; // end of the loop. ?>

                    </ul>

                <?php } ?>

            <?php
            }
			
			// Get contents and then clean output
            $product_list_output = ob_get_contents();
            ob_end_clean();
		
			// Reset query
            wp_reset_query();
            wp_reset_postdata();
            remove_filter( 'posts_clauses', array( $woocommerce->query, 'order_by_rating_post_clauses' ) );
			
			// Reset global
			$sf_product_display_layout = "";
			
            return $product_list_output;

        }

Thanks
Mohammad