URL key for specified store already exists. Magento 2.1.11

[chathuramk]

Hi All,

I was trying to import products to Magento store from Dynamics AX using Kingsway Soft. For some products I get below error message when syncing.

The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest, Detailed Message: {"message":"URL key for specified store already exists."})

I think this is a known bug in Magento. Anyone can suggest me a solution for this?? My Magento vesrion is 2.1.11

Thank you 

[Manish Mittal]

@chathuramk

Clean up your database in table url_rewrite (Change the url_key of all category). You can write UpgradeData script for this solution and please follow below urls for more workaround:

https://github.com/magento/magento2/issues/7298

https://github.com/magento/magento2/issues/6671

https://www.human-element.com/url-key-specified-store-already-exists-magento-2/

[monkich]

After a migration and a week digging into the problem the only thing that worked for me was https://www.safemage.com/url-optimization-after-migration-magento-2.html 

I had to downgrade to 2.2.7 to use it. It says it works on 2.3 but it does not.