Search Sku

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

Hi Steve,

Please submit a ticket and we will advise what are the options.