Please add following code in theme function.php file
function wpa104537_filter_products_by_featured_status() {
global $typenow, $wp_query;
if ($typenow==’product’) :
// Featured/ Not Featured
$output .= “<select name=’featured_status’ id=’dropdown_featured_status’>”;
$output .= ‘<option value=””>’.__( ‘Show All Featured Statuses’, ‘woocommerce’ ).'</option>’;
$output .=”<option value=’featured’ “;
if ( isset( $_GET[‘featured_status’] ) ) $output .= selected(‘featured’, $_GET[‘featured_status’], false);
$output .=”>”.__( ‘Featured’, ‘woocommerce’ ).”</option>”;
$output .=”<option value=’normal’ “;
if ( isset( $_GET[‘featured_status’] ) ) $output .= selected(‘normal’, $_GET[‘featured_status’], false);
$output .=”>”.__( ‘Not Featured’, ‘woocommerce’ ).”</option>”;
$output .=”</select>”;
echo $output;
endif;
}
add_action(‘restrict_manage_posts’, ‘wpa104537_filter_products_by_featured_status’);
function wpa104537_featured_products_admin_filter_query( $query ) {
global $typenow, $wp_query;
if ( $typenow == ‘product’ ) {
// Subtypes
if ( ! empty( $_GET[‘featured_status’] ) ) {
if ( $_GET[‘featured_status’] == ‘featured’ ) {
$query->query_vars[‘meta_value’] = ‘yes’;
$query->query_vars[‘meta_key’] = ‘_featured’;
} elseif ( $_GET[‘featured_status’] == ‘normal’ ) {
$query->query_vars[‘meta_value’] = ‘no’;
$query->query_vars[‘meta_key’] = ‘_featured’;
}
}
}
}
add_filter( ‘parse_query’, ‘wpa104537_featured_products_admin_filter_query’ );
