Post by mememe » Sat May 13, 2017 3:59 am

I have a lot of products in my shop, so I need to search for them in the admin panel when ammending listings, however, the search fuction only seem to return results from the FIRST word in the description title.
eg
I have 4 mint varieties, all with botanical names (Mentha) as the first word, one the first word is "Mint" even though mentha is in the title, this one doesnt show up in search results for "Mentha"

Any ideas?

Newbie

Posts

Joined
Fri Apr 01, 2016 3:44 am

Post by bonkopencart » Sat May 13, 2017 2:46 pm

You may use my modul..
It has additional features you may like too:
- Product ID Filter and Sort
- Manufacturer/Brand Filter and Sort
- Category Filter and Sort
- Tag Filter and Sort
- Enhanced Product and Model Search

Note:
- vqmod required
- developed for opencart v2.2

Attachments


New member

Posts

Joined
Fri Mar 24, 2017 1:53 pm

Post by chrisranjana.com » Fri May 19, 2017 4:53 pm

mememe wrote:
Sat May 13, 2017 3:59 am
I have a lot of products in my shop, so I need to search for them in the admin panel when ammending listings, however, the search fuction only seem to return results from the FIRST word in the description title.
eg
I have 4 mint varieties, all with botanical names (Mentha) as the first word, one the first word is "Mint" even though mentha is in the title, this one doesnt show up in search results for "Mentha"

Any ideas?
In file admin/model/catalog/product.php near line 347

Change

$sql .= " AND pd.name LIKE '" . $this->db->escape($data['filter_name']) . "%'";

to

$sql .= " AND pd.name LIKE '%" . $this->db->escape($data['filter_name']) . "%'";

Chris, Opencart Developers and Programmers,
www.chrisranjana.com


User avatar
Active Member

Posts

Joined
Thu Feb 26, 2009 2:23 am
Location - chennai, India
Who is online

Users browsing this forum: Baidu [Spider] and 66 guests