Product Search fail to find products by SKU

I figured this out!!! Woo hoo!!!! Or perhaps I should say, I hacked together a solution that seems to work. I don’t know if this is the best solution or if it would work in all situations. Or that it didn’t break something I’m not aware of yet…

For anyone who is interested, this is related to the functions-enfold.php file and the avia_ajax_search() function. The comments in this function says that it “hook[s] into wordpress ajax function to catch any ajax requests”. This function is set up to use get_posts() to get the search results when the call is made to it via WP’s admin-ajax.php file. In fact, the function contains the ability to switch out and use a custom function instead of get_posts. That might be a better way to accomplish what I’m doing here but I don’t know honestly.

At any rate, all I did was change the filters provided by @hunter74 to also check if $_REQUEST contains the parameter “s”, This would indicate a search term was being requested. If it does, the meta values are checked for the search term and since one of the meta values is WooCommerce SKU, those records would be returned if any exist.

So this is the revised code:

/**  __________________________________   ENHANCE THE STANDARD SEARCH 
 * Join posts and postmeta tables
 * 					 This one hels to include the SKU in tzhe standard search
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_join
 */
function cf_search_join( $join ) {
    global $wpdb;
    if ( is_search()  || !empty($_REQUEST['s'] )) {    
        $join .=' LEFT JOIN '.$wpdb->postmeta. ' ON '. $wpdb->posts . '.ID = ' . $wpdb->postmeta . '.post_id ';
    }
    return $join;
}
add_filter('posts_join', 'cf_search_join' );

/**
 * Modify the search query with posts_where
 *
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_where
 */
function cf_search_where( $where ) {
    global $pagenow, $wpdb;
    if ( is_search() || !empty($_REQUEST['s'] ) ) {
        $where = preg_replace(
            "/\(\s*".$wpdb->posts.".post_title\s+LIKE\s*(\'[^\']+\')\s*\)/",
            "(".$wpdb->posts.".post_title LIKE $1) OR (".$wpdb->postmeta.".meta_value LIKE $1)", $where );
    }
    return $where;
}
add_filter( 'posts_where', 'cf_search_where' );

/**
 * Prevent duplicates
 *
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_distinct
 */
function cf_search_distinct( $where ) {
    global $wpdb;
    if ( is_search() || !empty($_REQUEST['s'] ) ) {
        return "DISTINCT";
    }
    return $where;
}
add_filter( 'posts_distinct', 'cf_search_distinct' );
/* END   Search includes SKU  */

If anyone out there has a better (possibly more secure) solution, I’m definitely curious to hear about this. And, honestly, I think this type of feature should be added to the Enfold core or perhaps a framework for adding fields to search criteria should be defined.

In any case, I love Enfold and really appreciate what a great theme the team has developed!

• This reply was modified 2 years, 9 months ago by  kevinmcgillivray.

Thanks for sharing this fix. Woocommerce have added search by SKU to core as of 3.6.x however Enfold breaks it for some reason.