Ive just added around 100 url rewrites directly into the url_rewrites db table but Magento doesn't use them, Ive reindexed and cleared the cache but really don't know what to do next - what am i missing ?
I would suggest that, Please do remove those from database and do install below extension... so it will do provide an to generate new URL, generate new and keep OLD etc.
Please do review below extension from github for more details... https://github.com/olegkoval/magento2-regenerate_url_rewrites
Problem solved? Please give 'Kudos' and accept 'Answer as Solution'