Bring featured products first in a WP_Query

woocommerce-orderby-featured-products.php

<?php
// Add this to your `functions.php` or (preferably) to a plugin:
function featured_products_orderby( $orderby, $query ) {
	global $wpdb;

	if ( 'featured_products' == $query->get( 'orderby' ) ) {
		$featured_product_ids = (array) wc_get_featured_product_ids();
		if ( count( $featured_product_ids ) ) {
			$string_of_ids = '(' . implode( ',', $featured_product_ids ) . ')';
			$orderby       = "( {$wpdb->posts}.ID IN {$string_of_ids} ) " . $query->get( 'order' );
		}
	}

	return $orderby;
}
add_filter( 'posts_orderby', 'featured_products_orderby', 10, 2 );

// Pass `featured_products` as `orderby` parameter:
$products = new WP_Query( array(
	'post_type'      => 'product',
	'orderby'        => 'featured_products',
) );

Great! Thank you very much.

function featured_products_orderby( $orderby, $query ) {
global $wpdb;

if ( 'featured_products' == $query->get( 'orderby' ) ) {
$featured_product_ids = (array) wc_get_featured_product_ids();
if ( count( $featured_product_ids ) ) {
$string_of_ids = '(' . implode( ',', $featured_product_ids ) . ')';
$orderby = "( {$wpdb->posts}.ID IN {$string_of_ids}) " . $query->get( 'order' )." , post_date DESC";
}
}

return $orderby;
}
add_filter( 'posts_orderby', 'featured_products_orderby', 10, 2 );

Thank you!
I add sort products by date.

Thank you, guys, it works excellent!