I've been pulling my hairs to figure out what's going on with my Magento store (1.7.0.2 version). 80% url-keys are appended with strange numbers in two different forms. Some are like this http://www.example.com/product-name-2886-351.html, random numbers assigned after my dress style numbers, but these randomly-assigned numbers are not changing after added by the system.
Another version URL with strange numbers are like this: http://www.example.com/product-name-2926.html. Notice the style number "2926" is assigned by the system. "2886" was originally input on the URL key section when we added this product.
Some SEO people told me it's because we uploaded the CSV again and again without truncating the url_rewrite
table, so it created the duplicate version of products. That's why Magento does this to differentiate products. We uploaded CSV many times at the initial stage but there are some products are not affected by this. I'm not technical at all. I'm very confused by all this, but I don't quite believe this is the reason happening here.
After reading some threads, I know there are some real experts out there. Could you please help? If we upgrade to Magento 1.8, would this problem go away?