Revanssi & Woocommerce

Relevanssi should work with WooCommerce without any issues. Is Relevanssi set to index WooCommerce products? When Relevanssi is enabled, it takes over all searches, and if you haven’t indexed products, no products will be found.

Exactly the same problem as described by gareth with the latest WooCommerce version.

The problem is in search.php file and it is caused by meta_query. My products are defaulty sorted by total_sales postmeta and the meta_query for total_sales created by relevanssi is badly defined – total sales have no “compare” or “value”.

I deleted value and compare from line 995 in search.php and now it is working.

You can edit the meta query with the relevanssi_modify_wp_query filter hook. Or you can change the default sorting with this:

add_filter('relevanssi_orderby', 'rlv_sort_by_relevance');
function rlv_sort_by_relevance($orderby) {
    return "relevance";
}

Relevanssi doesn’t create the meta_query MySQL query – it’s done by WordPress. Can you show me the problematic code?

If you change:
$meta_query[] = array('key' => $query->query_vars["meta_key"], 'value' => $value, 'compare' => $compare);

to

$meta_query[] = array('key' => $query->query_vars["meta_key"]);

on line 995 in search.php – it solves the problem for WooCommerce.

What values of do the $value and $compare get in the problematic searches? Is $value set to null?

I can’t just remove those variables altogether as that’ll break other cases, but I can make some adjustments.

Getting exactly the same issue. Install the Relevanssi plugin and it stops the product search working in WooCommerce. I only need a product search in my ecomm site but need the results to look like the woocommerce product template. Anything with s=something&post_type=product shows No results. I changed the line described by @martin-snajdr and this fixed it – thanks! This will probably get overwritten on the next Relevanssi update though so a bit of a pain. I understand that @msaari maybe can’t make this change because of other cases, but is there something that can be done in the next update please? Thanks.

Since nobody answered my question, there’s little I can do – I’d need to know the answer in order to include a fix for this.

Hi – I’m not sure how to get those values sorry. Happy to try to help if I can – or can give you login to my dev site if that helps?

Hi Mikko,

Yeah, $value is indeed null. $compare is =.

Does this help?

i would like to use relevanissi and woocommerce together and am experiencing the same thing. i am willing to troubleshoot this as well. where is the search.php file that i might make the change suggested above?

a new version of my site is here:
results if i search for rose quartz in our standard search bar:
https://inspiritcrystals.dreamhosters.com/sandbox/?s=rose+quartz&submit=Search

results if i search for rose quartz from the woocommerce pages
https://inspiritcrystals.dreamhosters.com/sandbox/?s=rose+quartz&post_type=product

reading this support link, i add &post_types=product to the end of these urls and see results from my store, but not the other pages from the site and not always the same results.

https://inspiritcrystals.dreamhosters.com/sandbox/?s=rose+quatrtz&post_type=product&post_types=product

i notice what works is &post_types=product instead of &post_type=product that is returned in the url. could it be that the code that generates this url has a typo (&post_type instead of &post_types)? i’m sorry i don’t know enough about how to find the file and test it myself.

is it possible to see results from both posts by category and products in the same search results page?

• This reply was modified 8 years, 2 months ago by emilysparkle.
• This reply was modified 8 years, 2 months ago by emilysparkle.
• This reply was modified 8 years, 2 months ago by emilysparkle.

Yes it is possible to see results from both posts by category and products in the same search results page, in fact this seems to me to be normal behaviour, I would think if it doesn’t work for you it would be a theme issue.

The only wooCommerce issue I have is that when you open a Product from the search results page, search terms in the product short description [wordpress post_excerpt] are not highlighted… but they are found and relevanssi appears to correctly prioritise results between posts and products..