i have url_rewrite table in my magento 2.1 setup in which i have url structure like this
which is desirable , but many product have the url structure like this
www.exaple.com/name-of-product-sku-2054.html so at the end they contain product sku which is sku-2054
i need to remove all such occurrence from the database where the url is like www.exaple.com/name-of-product-sku-2054.html and what to change them to www.exaple.com/name-of-product.html
i went through url_rewrite which i believe contains these urls and found out that there are around 68k entries that would be needed to change .
can anyone suggest how can i do that without getting into the problem with duplicate urls also will it cause any harm if i do this by replacing the values from the column request_path from table url_rewrite . Do i need to change data from other tables also?