Hi I am running 1.9.1.
I have found the solution, the url keys were all the same ..
I am having this same issue, but I am not finding any duplicate product names and/or URL keys. Anyone else see this? Magento 188.8.131.52 is adding the ID number after all my configurable product URL keys. I am importing with Magmi. I have another site importing products the same way and I get clean URLs, so I think something may be up with my feed? But I can't find any duplicates.
Anyone else seeing this?
Thanks in advance!
I put this in another thread - but I'll repeat it here.
I know you said you've checked for duplicate urls - but sometimes they're not entirely obvious.
If you have access to your database you can run the following SQL... this will output 2 columns.. the first column is how many rewrites (urls) exist / have existed for a product.. and the 2nd column will tell you the Product ID. You ideally should edit the individual products in the query and ensure they have unique url keys.
SELECT count(url_rewrite_id), product_id FROM core_url_rewrite WHERE is_system = 0 AND isnull(category_id) GROUP BY product_id ORDER BY count(url_rewrite_id) DESC
Once you've done that.. you can run the following to clear up the rewrites.. after you've ran this the rewrite index should operate a lot faster.
DELETE FROM core_url_rewrite WHERE is_system = 0
Ensure you reindex after; and ensure you take a database backup before running it just in-case anything goes wrong.