We upgraded to NOP 3.8 and noticed that the partial Sku search stopped working. In researching I saw that it was intended to do an exact match in 3.8.
I did some searching on this and tried a few suggestions but can't seem to get the partial sku searching to work.
I updated the "ProductLoadAllPaged" stored procedure to the below but it didn't seem to work. I've also enabled full text search as well.
--SKU
IF @SearchSku = 1
BEGIN
SET @sql = @sql + '
UNION
SELECT p.Id
FROM Product p with (NOLOCK)
WHERE '
IF @UseFullTextSearch = 1
SET @sql = @sql + 'CONTAINS(p.[Sku], @Keywords) '
ELSE
SET @sql = @sql + 'PATINDEX(@Keywords, p.[Sku]) > 0 '
END
Is this correct OR is this there something else to change to allow partial sku searching?
Thanks for the help.
Toby