Close

Search Sku

zenithcreations
4 months ago
#15631 Quote
Avatar
  • 4
Hello,

I have changed my standard SP ProductLoadAllPaged to include this:

  --SKU (exact match) partial sku search
    IF @SearchSku = 1
    BEGIN
      SET @sql = @sql + '
      UNION
      SELECT p.Id
      FROM Product p with (NOLOCK)
      WHERE p.[Sku] LIKE ''%'  + @OriginalKeywords + '%'''
    END

But this doesn't work with Ajax filters on, I have noticed there is a SP specific to ajax filters. Is there a way to make the partial sku search as I need it for my site but also want to use the filters.

Regards,
Steve
Boyko
4 months ago
#15632 Quote
Avatar
  • Moderator
  • 1437
Hi Steve,

Please submit a ticket and we will advise what are the options.
Regards,
Boyko Stanev
Nop-Templates.com