Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

How to modify product search ?
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: How to modify product search ?

Re: How to modify product search ? 5 years, 11 months ago #44931

Good for the component, but nothing appears in the search bar...


Sorry and thank you
Last Edit: 5 years, 11 months ago by gael30.
The topic has been locked.

Re: How to modify product search ? 5 years, 11 months ago #44956

I tried :
WHERE '.implode(' OR ', $wheres).' OR p.`product_sku` LIKE ' . $db->Quote('%'.$filter.'%').' OR p.`product_barcode` = ' . $db->Quote('%'.$filter.'%').' OR p.`product_isbn` = ' . $db->Quote('%'.$filter.'%'), 0, 50);

But it's the same thing...
The topic has been locked.

Re: How to modify product search ? 5 years, 11 months ago #44988

  • pama
  • OFFLINE
  • Posts: 489
Hello. Version with "%" placeholders needs LIKE clause, not =.
What is your version of VM? And can you confirm that these two columns product_isbn and product_barcode are really in virtuemart *_products table? Thanks.

Edit: you can try to enable Joomla system debug and error reporting to Maximum, so you can see if there are some SQL errors in ajax search.
ARTIO Support Team
Last Edit: 5 years, 11 months ago by pama.
The topic has been locked.

Re: How to modify product search ? 5 years, 11 months ago #44990

Hello, my VM version is 1.1.9
yes, this two colunms are in virtuemart *_products

thanks
The topic has been locked.

Re: How to modify product search ? 5 years, 11 months ago #44992

  • pama
  • OFFLINE
  • Posts: 489
Hi, ah, I was thinking that. You must edit condition branch below for VM1. Like that

else
$db->setQuery('SELECT `product_id` AS `id`,`product_name`, `product_sku`, product_in_stock
FROM `#__vm_product`
WHERE `product_name` LIKE ' . $db->Quote('%' . $filter . '%').' OR `product_sku` LIKE ' . $db->Quote('%' . $filter . '%')
.' OR `product_barcode` = ' . $db->Quote($filter).' OR `product_isbn` = ' . $db->Quote($filter), 0, 50);
ARTIO Support Team
The topic has been locked.

Re: How to modify product search ? 5 years, 11 months ago #44993

Good job, thank you very much.... That' work...
ARTIO = very serious, very good
Thank's & best regards

Gaël
The topic has been locked.
  • Page:
  • 1
  • 2
User Login Empty