Search by SKU? How to do it?

Posted: November 27, 2015 at 2:25 AM Quote #155506
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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: November 27, 2015 at 2:44 AM Quote #155509
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!
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.Nop-Templates.com - the best place for nopCommerce themes and plugins

Follow us on
Facebook: http://www.facebook.com/NopTemplates
Twitter: http://twitter.com/NopTemplates
Blog: http://www.nop-templates.com/blog

www.Nop-Templates.com
nopCommerce Solution Partners
Posted: November 27, 2015 at 8:15 AM Quote #155522
Search of Sku does work in the Search Page if you check both "Advanced Search" and "Search In product descriptions"
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: November 27, 2015 at 8:20 AM Quote #155524
Hi,
Use Microsoft SQL Server Managment Studio, open Stored procedure [ProductLoadAllPaged],
After line (61):
IF ISNULL(@Keywords, '') != ''
   BEGIN

Add this:
set @SearchSku = 1
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
nopCommerce Solution Partner
https://www.nop4you.com - The biggest nopCommerce plugins marketplace
https://www.grandnode.com - Free, open source, multi platform e-commerce solution on NoSQL Database MongoDB
--------------------------------------------------------------------------------
Posted: November 27, 2015 at 8:39 AM Quote #155526
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Pls up-vote the answer, if it helps you! :)

nopAccelerate - Faster, Reliable & Scalable nopCommerce

http://www.nopAccelerate.com | http://www.xcellence-it.com | http://shop.xcellence-it.com

Need any professional assistance? Drop us your requirements on sales(at)nopaccelerate.com
Posted: December 12, 2015 at 3:45 AM Quote #156696
Thanks nop4you !

Your solution works great. Simple and effective !

Regards
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: April 16, 2016 at 8:12 AM Quote #165863
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 :)
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
TW
NOP User, Not Developer :)
Posted: April 18, 2016 at 5:16 AM Quote #165907
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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
nopCommerce Solution Partner
https://www.nop4you.com - The biggest nopCommerce plugins marketplace
https://www.grandnode.com - Free, open source, multi platform e-commerce solution on NoSQL Database MongoDB
--------------------------------------------------------------------------------
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.