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?
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
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
In file admin/model/catalog/product.php near line 347mememe wrote: ↑Sat May 13, 2017 3:59 amI 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?
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
Who is online
Users browsing this forum: No registered users and 90 guests