Sort by invoice number desc

Hello @snehaladdweb

Unfortunately we are bound by the limitations of WordPress queries here, and it seems that sorting will remove the orders that have empty Invoice numbers. I’m afraid we can’t help much more on this due to that.

Hi @snehaladdweb,

You can try this code snippet, but as my colleague @alexmigf said, it hides the orders without an invoice:

add_action( 'parse_query', 'wpo_wcpdf_set_orderby_pdf_invoice_number_in_admin' );
function wpo_wcpdf_set_orderby_pdf_invoice_number_in_admin( $query ){
	if( is_admin() && $_GET['post_type'] === 'shop_order' ){
		if(!isset($_GET['orderby'])) $_GET['orderby'] = 'pdf_invoice_number'; // Invoice Number column
		if(!isset($_GET['order'])) $_GET['order'] = 'desc'; //You can change it to ASC
	}
}

If you decide to use this code snippet, you’ll need to click on the Orders column heading to change the sort, in order to see the hidden orders (those without an invoice yet).

Hope it helps.