Search by SKU? How to do it?

Hi.

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?

Thank you.

zaf wrote:

Hi,

This is not available out of the box, you will need to modify the source code of the nopCommerce in order to achieve this.

Maybe you will be interested in our plugin - Instant search, which has the ability to search by SKU. Here you can see the DEMO and the ADMIN DEMO of the plugin.

Hope this helps!

Search of Sku does work in the Search Page if you check both "Advanced Search" and "Search In product descriptions"

Hi,
Use Microsoft SQL Server Managment Studio, open Stored procedure [ProductLoadAllPaged],
After line (61):
IF ISNULL(@Keywords, '') != ''
   BEGIN

Add this:
set @SearchSku = 1

zaf wrote:

Hi,

Here is a free search plugin you might like to check! This includes search by SKU as well as many advanced search features that I'm sure, your customers will love.

Regards

Thanks nop4you !

Your solution works great. Simple and effective !

Regards

Nop-Templates.com wrote:

I am using 3.60 with default clean theme.

I am looking at your instant search plugin and it seems like a play on words about a resolution to my problem.
I WANT USERS TO BE ABLE TO SEARCH BY SKU. If they type the sku into the search box, the product with that SKU appears.

In your advertising description you state "Show sku in search results".
That doesn't necessarily mean that it searches in the SKU number field.

Example:
For Descriptions you say "Search in Descriptions". That means it searches in the descriptions.  

Simple question: Does your NOP Instant Search it REALLY ALLOW USERS TO SEARCH BY SKU?

Thanks :)

Hi Jackluv,

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.