Search ID – SKU number conflict

Hey Richcc88,

thanks for reaching out! The following workaround will limit the search in metadata.

1.) In search-everything.php file find the function se_build_search_metadata() function and insert $search .= "{$searchand}(meta_key IN ('_sku', 'add_custom_field1_name_here', 'add_custom_field2_name_here'))"; line.

2.) Everything put together should look like this:

// create the search meta data query
    function se_build_search_metadata() {
        global $wpdb;
        $s = $this->query_instance->query_vars['s'];
        $search_terms = $this->se_get_search_terms();
        $n = ( isset( $this->query_instance->query_vars['exact'] ) && $this->query_instance->query_vars['exact'] ) ? '' : '%';
        $search = '';
        if ( !empty( $search_terms ) ) {
            // Building search query
            $searchand = '';
            foreach ( $search_terms as $term ) {
                $term = addslashes_gpc( $term );
                if ( $this->wp_ver23 ) {
                    $search .= "{$searchand}(m.meta_value LIKE '{$n}{$term}{$n}')";
                } else {
                    $search .= "{$searchand}(meta_value LIKE '{$n}{$term}{$n}')";
                }
                $searchand = ' AND ';
            }
            $search .= "{$searchand}(meta_key IN ('_sku', 'add_custom_field1_name_here', 'add_custom_field2_name_here'))";
            $sentence_term = esc_sql( $s );
            if ( count( $search_terms ) > 1 && $search_terms[0] != $sentence_term ) {
                if ( $this->wp_ver23 ) {
                    $search = "($search) OR (m.meta_value LIKE '{$n}{$sentence_term}{$n}')";
                } else {
                    $search = "($search) OR (meta_value LIKE '{$n}{$sentence_term}{$n}')";
                }
            }
            if ( !empty( $search ) )
                $search = " OR ({$search}) ";
        }
        $this->se_log( "meta where: ".$search );
        return $search;
    }

As said, this will limit the search results and the plugin will now search in custom fields with names you define only. In the provided code we added _sku for you and two examples (‘_sku’, ‘add_custom_field1_name_here’, ‘add_custom_field2_name_here’) but you can add more fields. Hope this helps!

Please let me know how it goes, take care and have a nice day,
Petra

Hi Petra,

Thanks for this response, it worked great. Sorry for being slow to get back to you with my thanks. I now have one quick further question if you don’t mind….this has allowed me to tailor the search results really well, but the only problem is there are page excerpts that need to be searchable and are now being excluded. I have tried to add these back in but with no success. Would you be able to help me introduce these back into the search please?

Thanks

Rich

Hey Rich,

thanks for getting back to me! I have tested this on our side and the excerpt search works for me. Also, the code I gave you should not affect the excerpts at all. Please check if you have ticked the box next to “Search every excerpt” in your plugin settings. You could also try to remove that ‘add_custom_field1_name_here’, ‘add_custom_field2_name_here’ after the _sku and see if that helps.

Looking forward to your reply,
Petra

Dear petra

I have jigoshop and search everything. The plugin works only I have the same problem when searching at sku the results return more then one product
I used the same code as above but then the search is not showing any results

Hey,

thanks for reaching out but to be completely honest that code above is not exactly a fix, just a workaround and it is not a “it will work” guaranteed. Would you be so kind and give me a link to your blog, so that I can take a closer look? Also, if I am not mistaken jigoshop has an implemented function that already searches for SKUs?

Looking forward to your reply,
Petra