URL Rewrite Management adds Number in the URL

[vendorskha]

Everytime URL Indexing is done, it adds up 1 number Up to the URL and redirects it.

Can you please advise if this is normal, i would like to keep my URL Same once Indexed so that if the link is shared at some place, it is always available.

[gelanivishal]

Hello @vendorskha,

This is a strange issue. Can you please go to MySQL and clear core_url_rewrite table and after reindex URL rewrite.

--
If you've found one of my answers useful, please give Kudos or Accept as Solution

[MageRakesh]

Hello Vendorskha,

I was facing the same issue as you describe. I tried one script as below link and it working fine for me.

https://www.atwix.com/magento/duplicated-product-url-keys-in-community-edition/

Get help from above link and set the code in the scheduled task.

Thank you