Thank you so much for this guide. I have searching this problem for some hours,
There is another way to do this if you want to avoid code.
What i've done is that since the conflict exists with the 'seo' of the product, it is saved in UrlRecord table, so in that table I linked the product with a seoname that I choose to be its numeric code because text follow a format in order to register a valid seoname, for example if my product's name is
'KIT DE FILTROS DESCARTABLES (SEDIMENTO + CARBON ACTIVADO) -AAER-2812' its seoName would be
'kit-de-filtros-descartables-sedimento-carbon-activado-aaer-2812'
but we are free to choose the seoname we want for our product so I prefered to place its numeric code to avoid dramas.
Finally, I made an import from an excel file where I matched the products with a seoname and previosly checked existing rows to know how to complete rightly all field in that table.
After the import finished successfully, I clear the cache from the Admin View and the product were showing now when I clicked them.
Note that in the url is where the seo of the product is showing up.
Hope this can help,
greetings.