Search by SKU? How to do it?

4 years ago
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.
4 years ago
zaf wrote:
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.


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!
4 years ago
Search of Sku does work in the Search Page if you check both "Advanced Search" and "Search In product descriptions"
4 years ago
Hi,
Use Microsoft SQL Server Managment Studio, open Stored procedure [ProductLoadAllPaged],
After line (61):
IF ISNULL(@Keywords, '') != ''
   BEGIN

Add this:
set @SearchSku = 1
4 years ago
zaf wrote:
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.


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
4 years ago
Thanks nop4you !

Your solution works great. Simple and effective !

Regards
4 years ago
Nop-Templates.com wrote:
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.

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!


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 :)
4 years ago
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.