Search by SKU Product Code

jcavanaugh wrote:

I also edited around line 3256

searchSku: false,

to

searchSku: true,

so autocomplete also searches part numbers.

Thank You for the reply I'm only able to work in the sql database at this time. I changed the ProductLoadAllPaged searchsku true what it seems I'm missing is the parameter to make the search and autocomplete to use the setting.

Thanks

drhine wrote:

Oooops sorry about that, not sure how I missed it.

Hi

Can you provide step by step instructions?

Thanks

Hi
why is the searchSku set to false in  

C:\Projects2013\ChannelManager\Main\Source\ChannelManager\Presentation\Nop.Web\Controllers\CatalogController.cs
public ActionResult SearchTermAutoComplete(string term)

Code:
var products = _productService.SearchProducts(
                storeId: _storeContext.CurrentStore.Id,
                keywords: term,
                searchSku: false,

Heres what I did in version 3.4

Using SQL Management Studio, connect to the database
Open the stored procedure '[ProductLoadAllPaged]'
insert the following around line 57  :
  SET @SearchSku = 1

This resulted in the simple search finding the products by entering the SKU

Also here is how I dealt with the simple products not displaying the SKU in the template

When adding products, we enter the SKU in the short description like this:
<b>SKU:</b> 12345

We also still enter the sku in the sku field but I edited the product templates so that it does not display anywhere.
Instead we just show it as the short description

We enter the product description in the full description which the client likes because it is easier to add HTML formatting using the WYSIWYG editor.

I also modified the product templates to ensure the display order is correct:
Short Description (actually SKU)
Full Description

wow thanks

you really helped me

i tried all the other stuff and it didn't work.


thanks so much for your help.

Thanks! Added to Version 3.5 to search SKU.
Added "SET @SearchSku = 1" After "SET @SearchKeywords = 1" using MS SQL management studio on Stored Procedure ProductLoadAllPaged.