If your store is on any latin language (such as spanish) your users will have problems searching for products if they don't put the exact accents, in order for the search products stored procedure to return matches disregarding accents make this change in the Nop_ProductLoadAllPaged procedure:



-- search standard content
patindex(@Keywords, p.name COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0
or patindex(@Keywords, pv.name COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0
or patindex(@Keywords, pv.sku) > 0
or (@SearchDescriptions = 1 and patindex(@Keywords, p.ShortDescription COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)
or (@SearchDescriptions = 1 and patindex(@Keywords, p.FullDescription COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)
or (@SearchDescriptions = 1 and patindex(@Keywords, pv.Description COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)          
-- search language content
or patindex(@Keywords, pl.name) > 0
or patindex(@Keywords, pvl.name) > 0
or (@SearchDescriptions = 1 and patindex(@Keywords, pl.ShortDescription COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)
or (@SearchDescriptions = 1 and patindex(@Keywords, pl.FullDescription COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)
or (@SearchDescriptions = 1 and patindex(@Keywords, pvl.Description COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) > 0)