WooCommerce: Sort Products By Stock @ Admin Dashboard

We’ve already seen how to sort frontend products by in stock first and out of stock last, but what about doing the exact same for administrators and shop managers in the backend?

Sometimes shops have to deal with a lot of “sold” products and the products table becomes messy, so this is a way to sort by stock status (In stock -> Out of stock) on load. You can then use the column headers to sort by other data as usual, so this will only work once you access /wp-admin/edit.php?post_type=product page.

So, here’s a very simple snippet for you. Enjoy!

PHP Snippet: Sort Products by Stock Status @ WooCommerce Admin

/**
 * @snippet       Product Sorted By Stock @ WordPress Dashboard
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 5
 * @donate $9     https://businessbloomer.com/bloomer-armada/
 */

add_action( 'pre_get_posts', 'bbloomer_sort_products_by_stock_status_admin' );

function bbloomer_sort_products_by_stock_status_admin( $query ){
	global $typenow;
	if ( is_admin() && $query->is_main_query() && $typenow == 'product' ) {
		if ( ! isset( $_GET['orderby'] ) ) {
			$query->set( 'orderby', 'meta_value' );
			$query->set( 'meta_key', '_stock_status' );
			$query->set( 'order', 'ASC' );
		}
	}
}

Related posts:

• WooCommerce: Add Column to Orders Table @ WP Dashboard The WooCommerce Orders Table, which can be found under WP Dashboard > WooCommerce > Orders, provides us with 7 default...
• WooCommerce: Disable Update Notifications @ WordPress Dashboard We talked a lot about safely updating WooCommerce. The same applies to WordPress core, other plugins, themes… WordPress is such...
• WooCommerce: Disable Orders Table Row Hyperlink @ Admin If you access the WordPress dashboard and go to WooCommerce > Orders, you will be presented with the WooCommerce “Orders...

Where to add custom code?

You should place PHP snippets at the bottom of your child theme functions.php file and CSS at the bottom of its style.css file. Make sure you know what you are doing when editing such files - if you need more guidance, please take a look at my guide "Should I Add Custom Code Via WP Editor, FTP or Code Snippets?" and my video tutorial "Where to Place WooCommerce Customization?"

Does this snippet (still) work?

If you think this code saved you time & money, feel free to join 17,000+ WooCommerce Weekly subscribers for blog post updates and 250+ Business Bloomer supporters for 365 days of WooCommerce benefits. Thank you in advance!

Need Help with WooCommerce?

Check out these free video tutorials. You can learn how to customize WooCommerce without unnecessary plugins, how to properly configure the WooCommerce plugin settings and even how to master WooCommerce troubleshooting in case of a bug!

Rodolfo Melogli

Business Bloomer Founder

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza.

Follow @rmelogli