woocommerce sort products by in stock and out of stock in front-end woocommerce sort products by in stock and out of stock in front-end wordpress wordpress

woocommerce sort products by in stock and out of stock in front-end


Using this code:

<?php/** * Order product collections by stock status, instock products first. */class iWC_Orderby_Stock_Status{    public function __construct()    {        // Check if WooCommerce is active        if (in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) {            add_filter('posts_clauses', array($this, 'order_by_stock_status'), 2000, 2);        }    }    public function order_by_stock_status($posts_clauses, $wp_query)    {        global $wpdb;        // only change query on WooCommerce loops        if (false === is_admin() && $wp_query->is_post_type_archive('product')) {            $posts_clauses['join'] .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";            $posts_clauses['orderby'] = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];            $posts_clauses['where'] = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];        }        return $posts_clauses;    }}new iWC_Orderby_Stock_Status;?>


Others code that i saw in search sometimes can To be created 404 error in shop page, i edited to this:

    add_filter('posts_clauses', 'avn_order_by_stock_status');        function avn_order_by_stock_status($posts_clauses) {            global $wpdb;            if (is_woocommerce() && (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {                if(is_shop()){                    $posts_clauses['join'] .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";                }                $posts_clauses['orderby'] = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];                $posts_clauses['where'] = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];            }        return $posts_clauses;    }