Help with _SKU search

Hi Ernest,

Thanks for your reply – many of our existing customers and staff will search our site using our 5-digit product codes such as:

240-01
290-01
260-01
740-01
741-01

…with the convention being three digits / hyphen / 2 digits. This product code format is also used as the SKU on the product pages within WooCommerce. When the above (and other) codes are searched for they don’t yield any results. Searching for the title of the product seems to work fine but it seems like the SKU is not searchable?

The attached screenshot shows our Mechanisms Trainer, searching for ‘Mechanisms Trainer’ works fine but searching for 260-01 does not yield any results – the code I have circled is our Product Code and is used in the WooCommerce SKU custom field.

Many thanks
Stewart

Hey Ernest,

Thanks for that, I probably need to go into a bit more detail about the original plugin and the reason for upgrading to your Pro version. Alongside a web-design agency, we redesigned our website from a Joolma site to WordPress site.

The new WordPress site used your Ajax Lite to perform searches and, originally, it was able to search custom fields to find our Product and SKU codes. We thought that maybe the ‘Custom Field’ functionality had moved from your Lite version across to the Pro version?… as the ability to find products by SKU had stopped working.

What I have done temporarily is switched the site back to the Lite version to show how the search originally worked (and how we’d ideally like it to continue to work).

Screenshot 1: Search using the magnifying glass at the top
Screenshot 2: Search screen where code is input
Screenshot 3: Result screen showing the search term (circled at top) and how the results are displayed. The second circle shows the product code/SKU of the product searched for. In this example, the 292-01 code searched for is also referenced in the other product pages shown which is probably why there are additional results.

So the new ‘plug-in search bar’ version of search (with the red banner in your previous screenshot) is not how the site previously worked with Ajax Lite. I don’t know if that’s something in the settings or some custom code form the agency but the ‘_SKU’ doesn’t pick up an results. Maybe our database is not being indexed correctly.

Sorry for the rather long post, if you need any clarification on anything please let me know.

Thanks for your assistance.

Stewart

Ah, that has fixed the way the search displays results – which is great, unfortunately it’s still not picking up the SKU results for the products. It works for an occasional one, possibly due to other text on the page but I don’t think it is picking up the SKUs such as the codes mentioned earlier:
240-01
290-01
260-01
740-01
741-01

Thanks
Stewart

Thanks Ernest,

I need out IT team to organise this next week – It will probably be a beta version of the site but I’ll get details over to you as soon as I can.

Thanks
Stewart