VirtueMart Forum

Hello everybody

I need absolutely to change the behaviour of search product

It's no possible that a product that should be evolute like virtuemart2, doesn't manage search with keyword made of 2 words or more ( please see example below ).

Which option I have other than edit the core code ( solution that I would avoid, obviously )?

THanks



Search with "argentina":

http://www.modacalcio.it/en/?option=com_virtuemart&view=category&search=true&limitstart=0&virtuemart_category_id=0&keyword=argentina&low-price=&hight-price=&manu_str=00&cat_str=

search with "argentina tracksuit":

http://www.modacalcio.it/en/?option=com_virtuemart&view=category&search=true&limitstart=0&virtuemart_category_id=0&keyword=argentina%20tracksuit&low-price=&hight-price=&manu_str=00&cat_str=

I do not understand what you mean. I can search for "hand shovel" and find all products with "hand" + "shovel". There is also absolutly no need to hack the core, because you can replace the sql with a trigger "plgVmAddToSearch".

The described page does not use the default search. There is a search suggestion included, what is not the default way, the default search plugin uses. So my suggestion would be to first deactivate that and try it with the default search.

I agree with franzpeter. I just tried your search plugin from ossolutions on this demo website: http://vma.ext4joomla.com/
Over there it doesn't even find "Virtuemart", although their VM product search is shown on the same page.
If you are using the Firefox browser, I would strongly suggest that you install the free "Firebug" plugin, which will help you to find problems on your website, because you have created several problems, especially javascript conflicts. You should try to load only one version of jQuery. If you load more than one and different versions, you will have problems. Personally I would also suggest to get rid loading code from Googleapis (at least use only one which loads a certain jQuery). It's unreliable and ofter very slow. (Remember that Google offers these only because it's an easy way for them to collect information about your website and how your customers are using it)

Thanks for suggestions, appreciate all replies obviously

The search of a product should work, in my opinion this way

Keywords=> "argentina tracksuit"  = QUERY => " product_name LIKE '%argentina%tracksuit% OR product_name LIKE '%tracksuit%argentina%" 

while in virtuemart code ( seen from debug queries )

[....]

WHERE ((`product_name` LIKE "%argentina tracksuit%" OR `product_s_desc` LIKE "%argentina tracksuit%" OR `category_name` LIKE "%argentina tracksuit%" OR `category_description` LIKE "%argentina tracksuit%" OR `mf_name` LIKE "%argentina tracksuit%" OR `product_price` LIKE "%argentina tracksuit%" OR `product_availability` LIKE "%argentina tracksuit%")
  AND p.`published`="1"

That means that if the in "argentina tracksuit" product name  are not consecutive, always no product are found, but how customers know which words are contiguos and which not ?   It's the same behaviour also in backend, that makes hard to find products too.

For your commodity I have enabled also a vm search standard module, down in the page now ( find : "VM - SEARCH IN SHOP") : http://www.modacalcio.it/en/

Using that standard module you have same ( no ) results with argentina tracksuit while it should retrieve at least 2 products ( you can try with argentina )

Hope now it can be more clear?

Thanks

p.s.
About javascript fixing , yes you are right. But is useless to fix fine js tuning, while the base functionality still doesn't work :((  I have also lot of hassles on child product management, that at the end I still can't use. Thanks anyway for suggestions

And also where is it possible to configure in which fields to search ? ( I want just product_name )

Thanks