product search box tooltip

[alibey]

i’m trying to add a tooltip to the search box on the menu bar to make clear to viewers that this is a product search vs the post search on my blog page

any ideas or example code on how to do this?

i tried using before and after pseudo classes on the search icon

something like this but it did not work

`sf-icon-search:hover:after{
background: white;
content: attr(title) “Search products”; //…more of the usual tooltip type code here `

you can get a box with text in it using pseudo classes but it proving very hard to make everything align properly including some little pointer cutout in the :before pseudo class

[David Martin – Support]

Hi,

Looks like you have got this working, if I hover I get see your :after content appear.

Thanks.

[alibey]

almost … i want to change the font to the font you guys use
in the shopping cart drop down box…is that font family Satisfy that i need to put in my styling code?

there is another more substantive issue
i take it this is a search box woocommerce developed?

i gather the widget search posts box is from wp

and the search box on the menu is from woocommerce that you guys simply styled and put on the menu for this theme?

the problem is this… it does not search SKUs — just goes by product name

i want a more powerful searching capability. ideally by sku, product size, or product name

(i already implemented search by product category, as you can see, in the sidebar, with the help of a widget — customers are loving this!)

basically i want my site to the easiest site in this space for finding a product and buying it at the click of a button or tap of a finger

any ideas how2 i might do either of those things? (ie, font + better searching)

[David Martin – Support]

Hi,

The font family you would want is font-family: 'Karla';.

The deafult WP search will not search by SKU. I know the plugin Relevanssi https://en-gb.wordpress.org/plugins/relevanssi/ can do this, however this is not a plugin and play setup and it requires some time investment to read their docs and set the plugin up to search the product SKU custom field.

Thanks.

[alibey]

thanks david. i will change the css and look into relevanssi.

[David Martin – Support]

No problem!

Thanks.

[alibey]

david

i changed the font, size, and color… and i think it looks pretty good, but boxy.

i would appreciate your opinion. do you think it is a stylistic value add
to have a tiny triangle point down toward the magnifier?

would that be a no no since this does not happen anywhere else on atelier and the gods of UI design would shoot me at dawn for doing this?

[David Martin – Support]

Great, I guess it’s subjective – for me I’d say the down arrow would be leaning towards a dropdown menu. But the context and user interpretation of your clientele could think otherwise also.

Thanks,
David.

[alibey]

re relavanssi i remember now researching this widget some months back

my recollection from the time tells me that it adds huge indexing tables to mysql and basically slows everything down to a crawl

what i am looking for is the ability to query the SKU column only in the whatever table contains this field

so you would have an SKU widget that you can stick in the sidebar… coolness for an ecommerce site!

so the pseudo code stored query would be on the order of SELECT [product] from some_table where sku=[some user input value]

i would disallow any form of wild card searching for obvious reasons

so i’ll see if there is a single function specific widget that performs string matching searches just off the sku column

for an ecommerce site the overhead of the widget might be worth it if the code is clean and efficient

[alibey]

now here is a talented young uk programmer who actually seems to get ecommerce.

http://www.mattyl.co.uk/2012/12/11/woocommerce-plugin-to-search-products-by-sku/

i have contacted him just now re compatibility with latest versions of wp.

[David Martin – Support]

Relavanssi is extremely powerful, well supported and documented search plugin.

It would require resources such as a decent server and a web developer/PHP knowelege to properly configure it. But you get out what you put it.

That is just my recomendation on what I have used previously and what many other of our customers use.

Thanks,
David.

[alibey]

k so i installed relevanssi… and attempted to build an index which apparently is necessary to use it
and this happened

Relevanssi Search Options

Fatal error: Call to undefined function wc_print_notices() in /home/adminIDxxx/public_html/wp-content/themes/atelier/woocommerce/wishlist.php on line 78

i known. this is not an atelier problem. we have to hire a web developer to make a plug in work.

oh well. it was nice while it lasted.

what is rankling about this whole SKU thing is that this is a basic elementary query that is nothing more
than an sql select of a column from a product table (ignoring for the moment the reality pf tje contorted non normalized weirdness that is the entire wp / woocommerce sql schema, not to mention the absence of a simple data dictionary that enables an admin or developer to find where needed data is located)

that turns into this incredibly complicated song and dance involving something like relanssi to perfrom a rudimentary lookup function…. one that to make matters worse fails for some unknown reason to index the wp database and now i have to waste time figuring out why this failure occured instead of tending to customer needs

woocommerce should have the ability to query skus available out the box already, and by that i mean the ability to have a ready made search box that does this in a simple and straighforward manner. i checked their user forum (which they have apparently shut down, incredible as that is) and people have been asking for this for 3 years now. but i guess they dont want to hear this so they shut the user forum down.

absolutely incredible.

i have changed my mind about going to their austin conf.

[David Martin – Support]

Hi,

You maybe able to contact them this way: https://support.woothemes.com/hc/en-us.

That error is likely caused by the WP error debug settings. In your wp-config.php is this constant true or false for you? define('WP_DEBUG', false);.

Thanks.

[alibey]

hi david. i guessed it had to do with the YIT Wishlist plugin. So I turned it off. Then I indexed
my DB. Turned YIT back on, and that fixed the problem.

So I was then able to test if Relevanssi could retrieve SKU and Products Names. As I have it configured, with the non premium version, the answer is no.

So I went to the trouble of finding out exactly where the SKUs are stored, and how precisely to retrieve a user specificed SKU using standard SQL.

I then sent Mikko the developer of Relevanssi the following email, and await his answer. You may be interested in this, as you spoke highly of this widget.

All I want is the ability of this widget to execute a function that produces the same result. My professional background happens to be relational database technology, so it was quite simple to examine the WP/WC schema and derive the correct SQL query.

This is not an Atelier issue per se, but I think many Atelier users would like to be able to have this functionality available to their customer base.

==================> start of email:

hi mikko

the result set i want for my sku search is satisfied by the following query

SELECT p.post_title, s.meta_value
FROM wp_posts p, wp_postmeta s
WHERE p.ID = s.post_id
AND p.post_type= ‘product’
AND s.meta_key = ‘_sku’
AND s.meta_value LIKE ‘%some user defined value%’
ORDER BY p.post_title ASC

what this query does is return the product name and sku based on some user defined parameter
as typed in a search box
but blocking the ability of the user to pass dangerous characters favored by hackers
i have tested this using a database front end and it works correctly 100%

can Relevanssi execute such a query or execute some PHP function that achieve the same result?
What does the administrator have to do in terms of setting indexing options in the widget for this to work?
Please note I have already set your widget to only index woocommerce Products
I am NOT interested in searching posts, comments, etc
only Product Names and Product SKUs

the Premium ($49) version of Relevanssi seems has the following features

Search post categories, tags and custom taxonomies – X X
Search custom fields – X X
would these be used to enable SKU searching? If so, how?

Thanks!

ali

[David Martin – Support]

The Relevanssi search plugin will allow you to include the SKU in the search index.

This plugin will require you to configure the search options:

1) “Indexing options” include “Product”.

2) “Custom fields to index:” please add _sku,sku.

3) Save the options and build the index.

I have tried this on my dev version and can confirm it works.

Thanks