[hotfix] Product Search
diff --git a/erpnext/templates/pages/product_search.py b/erpnext/templates/pages/product_search.py
index 93773bd..0641702 100644
--- a/erpnext/templates/pages/product_search.py
+++ b/erpnext/templates/pages/product_search.py
@@ -18,14 +18,14 @@
# search term condition
if search:
- query += """and web_long_description like %(search)s
+ query += """ and (web_long_description like %(search)s
or description like %(search)s
or item_name like %(search)s
or name like %(search)s)"""
search = "%" + cstr(search) + "%"
# order by
- query += """order by weightage desc, modified desc limit %s, %s""" % (start, limit)
+ query += """ order by weightage desc, modified desc limit %s, %s""" % (start, limit)
data = frappe.db.sql(query, {
"search": search,