I am using nopCommerce 3.60 with DefaultClean theme.
I want customers to be able searching by SKU using search field.
How to do it?
Search of Sku does work in the Search Page if you check both "Advanced Search" and "Search In product descriptions"
Use Microsoft SQL Server Managment Studio, open Stored procedure [ProductLoadAllPaged],
After line (61):
IF ISNULL(@Keywords, '') != ''
set @SearchSku = 1
Thanks nop4you !
Your solution works great. Simple and effective !
For one of our customers we developed plugin, which search only SKU field. If you will be interested, please contact with our support, please add version of nopCommerce you are using.