Issue with UPCs

If the Relevanssi admin search (Dashboard > Admin search) finds something the Flatsome Ajax search doesn’t, that means the Flatsome Ajax search is not using Relevanssi. I’m not sure what’s up with that; it sometimes work and sometimes doesn’t. There’s a way to make it always work, though, and that’s documented here. Does that fix your problem?

When debugging the problems, it’s also a good idea to try disabling Search & Filter Pro to rule out if that has an effect on anything.

Thanks for getting back to me so quickly! I forgot to mention that I already tried both of those snippets. They help to get the AJAX search to pull UPCs for simple products but it doesn’t work for variable products.

Ok, in that case try disabling Search & Filter Pro. Does that have any effect on this?

Hey Mikko,

I tried disabling S&FP and that didn’t help, I’m still unable to search for variable product UPCs. Simple and variable SKUs work as well as simple UPCs but no variable UPCs.

I did notice that my second issue regarding SKUs is straightened out both with SF&P enabled and disabled though – if I punch a SKU into search and hit enter before the Flatsome AJAX search loads it takes me right to the product page.

I just realized you’re talking about UPC, and not just SKU. Yes, you need to amend the variation SKU function so that it also adds the UPC. Where’s the UPC stored?

I am using the Product GTIN (EAN, UPC, ISBN) for WooCommerce plugin and it stores the UPC meta as _wpm_gtin_code.

Fixing that isn’t complicated. Change your SKU function to this:

// RELEVANSSI VARIABLE SKU SEARCH
add_filter('relevanssi_content_to_index', 'rlv_index_variation_skus', 10, 2);
function rlv_index_variation_skus($content, $post) {
    if ($post->post_type == "product") {
        $args = array('post_parent' => $post->ID, 'post_type' => 'product_variation', 'posts_per_page' => -1);
        $variations = get_posts($args);
        if (!empty($variations)) {
            foreach ($variations as $variation) {
                $sku = get_post_meta($variation->ID, '_sku', true);
                $upc = get_post_meta($variation->ID, '_wpm_gtin_code', true);
                $content .= " $sku $upc";
            }
        }
    }
 
    return $content;
}

That worked perfectly, thank you!

Another issue I ran into in the process of getting this working however is tied to the below code. In order to use Flatsome’s AJAX search with SKUs or UPCs I had to add the following code but it made the search results a bit odd. The top of the list will be the product that is searched for but it will also add about 50 completely unrelated products below it. Before this snippet it would only pull the actual product or anything relevant to the search terms, do you have any ideas on how I might be able to stop all of the extra products from loading?

function rlv_flatsome_search_function( $query, $args, $defaults ) {
  $_wp_query = new WP_Query();
  $_wp_query->parse_query( $args );
  relevanssi_do_query( $_wp_query );
  return $_wp_query->posts;
}

The snippet should run a search with exactly the same parameters as the Flatsome default search does.

If you change the function to this:

function rlv_flatsome_search_function( $query, $args, $defaults ) {
  error_log( wp_json_encode( $args ) );
  $args['relevanssi'] = true;
  return get_posts( $args );
}

and then run a search and look at the server PHP error log, what does that print out in there?

I tried that and ran a few searches but it didn’t output any errors.

Are you perhaps missing the line that activates the function?

add_filter( 'flatsome_ajax_search_function', function() { return 'rlv_flatsome_search_function'; } );

That line is there but I had forgot to copy/paste it in my earlier message.

You can also try this:

function rlv_flatsome_search_function( $query, $args, $defaults ) {
  error_log( wp_json_encode( $args ), 1, '[email protected]' );
  $args['relevanssi'] = true;
  return get_posts( $args );
}

This should email you instead of writing to the error log.

That worked perfectly, below is the emailed error log.

{"s":"","orderby":"relevance","post_type":["product","product_variation"],"post_status":"publish","posts_per_page":100,"ignore_sticky_posts":1,"post_password":"","suppress_filters":false,"order":"DESC","meta_query":[{"key":"_sku","value":"850002123159"}],"tax_query":[{"taxonomy":"product_visibility","field":"term_taxonomy_id","terms":6,"operator":"NOT IN"}]}

Ah, I see. That’s the SKU product search. Can you disable that from Flatsome settings? It shouldn’t be necessary with Relevanssi.

If you can’t, this should do the trick:

add_filter( 'theme_mod_search_by_sku', '__return_zero' );

Does disabling the SKU search help?