yatgirl

I have found a work around. If I go into product bulk edit and dont make any changes but click the update button, then I can at least update 50 products at once, which then gets the category set in the Relevanssi search index, which then allows them to be searchable by plurals. So many workarounds….

I am using the stock woocommerce import products – built right into woocommerce – I think it started to be a stock feature of woocommerce earlier this year. I set the product category in the csv import along with the product info. Is there any solution for that?
My Relevanssi index is too large to rebuild without running into issues unless I really have to and I am adding new products all the time via the stock woocommerce import products tool.

I am wondering if the search is accepting the plural from the category that the products are in. Because the category is called signs but the products within it just say ‘sign’. But what I said above is true, I have tested it with several separate product imports now. If I import (via csv) a product called ‘sign’ (which is in the ‘signs’ category) it will find the product under the search for ‘signs’, ONLY if I rebuild the index or click on each product individually on the product page to update it.

I dont have Relevanssi Premium. I dont know what stemming is.
I am not doing anything custom to index the imported products – Relevanssi is indexing them automatically.
I thought at first that Relevanssi wasnt indexing the new imported products automatically because the searches I tried were with plurals – but the search index is incrementing when I import products and searches for the non-plural of words is working well.

I havent done anything with stripping plurals. One of the main reasons I installed Relevanssi is because the regular woocommerce search wasnt including the plural versions of words in searches.

Hi Mikko,
When uploading products via the bulk import feature in woocommerce – the products are automatically added to the search index, however, stripping plurals are not working. I have tried Continue Indexing – it doesnt help because the imported products have already been added to the index.
So if I bulk upload a group of products which have the product title of ‘sign’. When doing a search – ‘sign’ brings up the new products in the search results but a search for ‘signs’ does not include the new products in the search result. I either have to go into each product and click Update or reindex the whole site in order for them to appear in the ‘signs’ search result.
Is there a code snippet i can add so this does work properly, or will this definitely be fixed in the future versions you mention in your post ? – When would that be ?

My settings are
Default Operator : AND – require all terms
Disable OR fallback has a check mark in the box
Dont use fuzzy search
Limit Searches has a check mark in the box

garden would have well over 6000 results alone.

I will look forward to the updates you advise – slow is not great, but better than fatal errors.

Thanks

So I guess maybe thats the solution – put a check mark in the Disable Or fallback – and dont provide results for partial words….thats better than fatal errors….

I am using the setting AND – require all terms
If i put a check mark in the Disable OR fallback – I get no results at all in the search for the partial word search – but I dont get a fatal error either.

Re your code var_dump(count($hits)); exit();
With the code snippet sort by title enabled or disabled and using my partial word search I get a blank screen with int(1370) at the top left corner of the screen. I dont get a fatal error. (it doesnt bring back any results either for any search, other than the blank screen)

I think you may have misunderstood – the 123 results are for the whole word results – that work. The searches that gives a fatal error – I just get a blank screen.
I am using the setting AND – require all terms
Disable or Fallback does not have a check mark beside it.
I have using the setting Relevance (highly recommended)
I am using the setting ‘Don’t use fuzzy search’
Limit Searches does have a check mark beside it.
Nothing else in the settings has a check mark beside it.

But what you said made me think – I dont think the ‘limit searches’ is working all the time even tho I have it enabled. Perhaps this is the reason partial searches are resulting in a fatal error when the sort by title code snippet is enabled.

When the code snippet to sort results by title is deactivated – sometimes I get the limit of 500 results – other times I am getting 870 results, 1000, 1088 results for a partial word search I just did.(if the code snippet to sort by title is activated – I get a fatal error)

I found your code snippet from here https://www.relevanssi.com/user-manual
so I thought I would try that, but it also gives the same fatal error with partial word search – same as the other code snippet I was using

add_filter('relevanssi_modify_wp_query', 'rlv_sort_by_title');
function rlv_sort_by_title($q) {
	$q->set('orderby', 'post_title');
	$q->set('order', 'asc');
	return $q;
}

the partial word search brings back mostly irrelevant results even though I am using the AND option, it doesnt seem to be using that with partial words. aus garden brings back all kinds of results that aus is not in – seems to be like a fuzzy search even tho I dont have the fuzzy search option turned on. Using the whole word australian brings back the correct results.

But I can live with all that, if I could find a way to sort the results alphabetically.

I get this weird code at the top left of the page -> int(123) the 123 is the amount of results. I tried deactivated my alphabetical code snippet and then reactivated it and tried searches both ways. Its the same results as before. whole word searches work, partial word searches give a fatal error if the alphetical sort is activated.

Not really sure what you expected me to see and so it is hard to say….

I think I have found the reason. I have a code snippet so that search results are sorted alphabetically – I deactivated this and it is now not timing out. This did seem to work fine before, perhaps some updates are making it now not work. Is there something I can change in the code snippet below or a new code snippet so that results are sorted alphabetically by product name ?

// SEARCH RESULTS – sort by TITLE OR NAME

add_action(‘pre_get_posts’,’sortby_title_query’);

function sortby_title_query($query) {
if ( isset($_REQUEST[‘s’]) ) {
$query->set(‘orderby’, ‘title’);
$query->set(‘order’, ‘ASC’);
}
}

There is a check mark in the box beside ‘Limit Searches’
I am using the setting ‘Don’t use fuzzy search’
Default order for results: Relevance (highly recommended)

I have done a bit of further testing. I have also applied the code snippet to throttle the results to 250 but unfortunately the same error happens. This happens when using a portion of a word instead of a whole word. For example – If I just put in ‘aus garden’ instead of ‘australian garden’ the search times out and I get a fatal error. I am hoping this is just a setting or something that can be fixed.
I am using default operator AND – and I dont use fuzzy search and I have limit searches checked off. I dont have custom excerpts/snippets check off.