Posted on 10/04/2019 17:52:06
Hi Martin
I looked at the solution and can see the reason is that you have 2 types of spaces in your product names. See the dump #1.
So you have regular spaces and you have non-breaking spaces. Probably coming from an integration.
We did update the URL name sanitizer this summer, so that might be the reason you see this issue.
To fix a quick solution is to run a database replace on that character - something like this:
UPDATE EcomProducts SET ProductName = REPLACE(ProductName, NCHAR(0x00A0), ' ')
I will also make a fix for url sanitizer to handle all types of whitespace.
Sorry about the inconvenience, Nicolai