URL Issues reindexing data - Numbers showing on URL strings!
I've been facing URL issues each time I reindex data in admin, Every time I do so I get numbers at the end of all the URLs. I recently discovered I could go into MYSQL in "core_url_rewrite" and remove all these URL redirects which worked perfectly but as soon as i reindex i am facing the same issue again. My site has hundred of products stretched across 12 stores so its a pretty big job every time I need to reindex data.
I have also tried searching in URL Rewrite management with the url_rewrite_id to delete them but there not showing in here.