Product SKU Search with default search

PHOTO

Thu Jul 06 2023 12:00:21 GMT+0000 (Coordinated Universal Time)

Saved by @gshailesh27

If you are using wordpress search you can add this code to make it work



function search_by_sku( $search, &$query_vars ) { global $wpdb; if(isset($query_vars->query['s']) && !empty($query_vars->query['s'])){ $args = array( 'posts_per_page' => -1, 'post_type' => 'product', 'meta_query' => array( array( 'key' => '_sku', 'value' => $query_vars->query['s'], 'compare' => 'LIKE' ) ) ); $posts = get_posts($args); if(empty($posts)) return $search; $get_post_ids = array(); foreach($posts as $post){ $get_post_ids[] = $post->ID; } if(sizeof( $get_post_ids ) > 0 ) { $search = str_replace( 'AND (((', "AND ((({$wpdb->posts}.ID IN (" . implode( ',', $get_post_ids ) . ")) OR (", $search); } } return $search; } add_filter( 'posts_search', 'search_by_sku', 999, 2 );

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

WordPress Snippet

@gshailesh27

Display Custom Post By Custom Texonomy Hide Section If Data Empty Custom post Url Change Social Share Link Genrator / meta tag OG Set Custom post type template Custom post by current category page List all Category Loop Reverse Reverse Array in custom repeat fields Display custom texonomy name into post WP Rocket Delay JavaScript execution Files Post FIlter By Texonomy URL Check and echo active exclude current post from single page Post Sort by Custom Taxonomy in Admin Ajex select change texonomy and post Wordpress Ajex select Get Category Name (wp get object()) List Display Custom Taxonomy Order Date Woocommerce Disable notification for plugin update Custom Ajax Form for WP Order Expiry Woocommerce Post By Post Taxonomy Hide Section If Data Empty Product SKU Search with default search Hide WP Version Disable REST API Get Post Data with Post or page id (WCK CTP Select field) Custom API For Page with custom fields Disable WordPress Update Notifications Create Users Automatically In WordPress / create admin login Create and Diplsay ACF Texonomy Data Custom Post by Custom Texo filter JQuery Multiple Select Filter WordPress Premium Plugins Repo WP Premium Plugins Repo Part 2 Custom Taxonomy Template Post Order by ASC and DESC on published date Post Order by ASC and DESC on published date Widget Register and Dipslay Display category and Subcategory with Post CF7 Successful Submit Redirect to another page Load Fancybox on page load Once in month with cookies SVG Support in WP in function.php List Custom Taxonomy Wordpress Admin Login Page Layout Change Change Posts To Blogs (Post Type) JQuery Load More Display Custom Post under custom taxonomy Search Form with result page Stater Theme style.css file Acf option page Call Another Custom Header Zoho Integration for cf7 Forms www redirection 404 WP Template Coming Soon HTML Template Display Custom Posts by Category With Ajax filter Disable wordpress update notification / wp update notification custom breadcrumbs Disable admin toolbar except admin Disable Comment module on whole website Custom Data / Product / Card Filter by page load (by get and isset function) Mastek Resource Page for filter data List All pages on admin dashboard Custom Taxonomy Name on Single Page custom texonomy list with child WordPress Security and admin page Code Js Load on Page Based

Browse more snippets >>