Mr.Fitz

Hey Mikko,
That last code you gave worked great. I’ve got some tweaking to do but I like what I’m seeing.

Thank you so much for your help!

Greg

“The search is also restricted to just products, as is usual for WooCommerce.”
This perhaps is the problem. I do not want woocommerce to restrict searches to products.
I’d like to include posts and pages.

I checked the added code to the functions.php

add_filter( ‘relevanssi_modify_wp_query’, ‘rlv_force_post_product’ );
function rlv_force_post_product( $query ) {
$query->query_vars[‘post_types’] = ‘post,product’;
return $query;
}

It looks just like above

Can’t help but feel I’m missing something – :o(

Ok Mikko,
I did the the two steps, nothing jumps out as being wrong but then, I’m not sure what i’m looking at. So I just pasted them in –

This is the search results from “Look at the parameters Relevanssi is getting”

array(71) { [“s”]=> string(15) “Hospital sheets” [“post_type”]=> string(7) “product” [“error”]=> string(0) “” [“m”]=> string(0) “” [“p”]=> int(0) [“post_parent”]=> string(0) “” [“subpost”]=> string(0) “” [“subpost_id”]=> string(0) “” [“attachment”]=> string(0) “” [“attachment_id”]=> int(0) [“name”]=> string(0) “” [“static”]=> string(0) “” [“pagename”]=> string(0) “” [“page_id”]=> int(0) [“second”]=> string(0) “” [“minute”]=> string(0) “” [“hour”]=> string(0) “” [“day”]=> int(0) [“monthnum”]=> int(0) [“year”]=> int(0) [“w”]=> int(0) [“category_name”]=> string(0) “” [“tag”]=> string(0) “” [“cat”]=> string(0) “” [“tag_id”]=> string(0) “” [“author”]=> string(0) “” [“author_name”]=> string(0) “” [“feed”]=> string(0) “” [“tb”]=> string(0) “” [“paged”]=> int(0) [“meta_key”]=> string(0) “” [“meta_value”]=> string(0) “” [“preview”]=> string(0) “” [“sentence”]=> string(0) “” [“title”]=> string(0) “” [“fields”]=> string(0) “” [“menu_order”]=> string(0) “” [“embed”]=> string(0) “” [“category__in”]=> array(0) { } [“category__not_in”]=> array(0) { } [“category__and”]=> array(0) { } [“post__in”]=> array(0) { } [“post__not_in”]=> array(0) { } [“post_name__in”]=> array(0) { } [“tag__in”]=> array(0) { } [“tag__not_in”]=> array(0) { } [“tag__and”]=> array(0) { } [“tag_slug__in”]=> array(0) { } [“tag_slug__and”]=> array(0) { } [“post_parent__in”]=> array(0) { } [“post_parent__not_in”]=> array(0) { } [“author__in”]=> array(0) { } [“author__not_in”]=> array(0) { } [“orderby”]=> string(9) “relevance” [“order”]=> string(4) “DESC” [“meta_query”]=> array(0) { } [“tax_query”]=> array(2) { [“relation”]=> string(3) “AND” [0]=> array(4) { [“taxonomy”]=> string(18) “product_visibility” [“field”]=> string(16) “term_taxonomy_id” [“terms”]=> array(1) { [0]=> int(1418) } [“operator”]=> string(6) “NOT IN” } } [“wc_query”]=> string(13) “product_query” [“posts_per_page”]=> int(24) [“ignore_sticky_posts”]=> bool(false) [“suppress_filters”]=> bool(false) [“cache_results”]=> bool(false) [“update_post_term_cache”]=> bool(true) [“lazy_load_term_meta”]=> bool(true) [“update_post_meta_cache”]=> bool(true) [“nopaging”]=> bool(false) [“comments_per_page”]=> string(2) “50” [“no_found_rows”]=> bool(false) [“search_terms_count”]=> int(2) [“search_terms”]=> array(2) { [0]=> string(8) “Hospital” [1]=> string(6) “sheets” } [“search_orderby_title”]=> array(2) { [0]=> string(168) “wrd_posts.post_title LIKE ‘{7a79222a4ef29dd29e2141ffc9afea18f84b04677bd6e665beeea14e482cb3bd}Hospital{7a79222a4ef29dd29e2141ffc9afea18f84b04677bd6e665beeea14e482cb3bd}'” [1]=> string(166) “wrd_posts.post_title LIKE ‘{7a79222a4ef29dd29e2141ffc9afea18f84b04677bd6e665beeea14e482cb3bd}sheets{7a79222a4ef29dd29e2141ffc9afea18f84b04677bd6e665beeea14e482cb3bd}'” } }

Search results from MySQL query

string(667) “SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 8 + relevanssi.content * 2 + relevanssi.comment * 0.75 + relevanssi.tag * 1 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 1 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf FROM wrd_relevanssi AS relevanssi WHERE relevanssi.term = ‘choosing’ AND relevanssi.doc NOT IN (SELECT DISTINCT(tr.object_id) FROM wrd_term_relationships AS tr WHERE tr.term_taxonomy_id IN (1418)) AND ( relevanssi.doc IN ( SELECT DISTINCT(posts.ID) FROM wrd_posts AS posts WHERE posts.post_type IN (‘product’) ) )”

And the third steo – “Look at the results” –

array(5) { [1056]=> float(182.003433521) [1221]=> float(91.0017167605) [1292]=> float(91.0017167605) [1337]=> float(91.0017167605) [7484]=> float(91.0017167605) }

What do you see? Any errors? Something missing? Anything wrong?
Suggestions?

I do appreciate you time,
Greg

Thank you Mark, that’s a great help.

Done

I have a custom theme built for me by Kickstart Media. It is a responsive site however, I think I would like to streamline it somewhat to help gain a better user experience when viewed with phones and tablets.
I would probably remove the slider and maybe some blog photos. The main thing is simple navigation (true also for the full site) to locate and purchase products. Convenience.

I’ve looked at GoMobi.
I’ve looked at Dudamobile. Right now I’m leaning toward Dudamobile.But I’m open to suggestions.

Anyone?

Caregiver-Aid.Com