Magento – Why Product URL is Duplicating

adminproducts-managementurl

I am using magento 1.7. i am faceing strange problem. magento making duplicate product url with random number with wrong url key please my attached screenshot

I also empty table rewrite_urls and reindex urls but still i am getting wrong urls. please help me to solve this problem. if you are unable to view images in question then please click on links duplicate product urls and Product in admin panel

Duplicate product urls , actual product

Let me make understand u with example

Like i have one product named "example" and url key is "example" Url will be

www.example.com/example

and now i have created new product "xyz and url key is "xyz" and url should be

www.example.com/xyz

but magento generating url

www.example.com/example-123

Best Answer

This seems to be a bug in 1.7. If you have multiple simple products with the same url key as the configurable product (e.g. all names are the same), than magento always creates a new url rewrite on every index process. Example:

First index:

myproducturl (config product)
myproducturl-id (simple product with its id appended, so far so good)

Second index:

myproducturl (config product)
myproducturl-randomnumber (simple product with random number, BAD)
myproducturl-id --> myproducturl-randomnumber (rewrite to the new url)

And on every new index process the last step will be repeated, so always a new random url key is generated. If magento would check, that a url key with the id for that product already exists, this should be no problem.

After a few months, you will have a really big url_rewrite table, because nothing will be deleted and on every run, at least 1 record for every product with the same url key will be created.

Step 1

Make sure the URL you’re trying to achieve is in fact unique.

There is a reason Magento appends these numbers to the end of your URLs, because it actually already exists. It’s like creating two categories with the same name in WordPress, the second category will have the URL “/category-2/”.

Step 2

Do a database backup

Open up PHPMyAdmin or something similar.

Find the core_url_rewrite table.

Search for your url in the request path. In my example I typed: "hats%"
this will find anything beginning with hats in the url.

Step 3

Just remember if you hard linked this page it will now 404. So if there is a risk of this, make sure you create a new redirect after this for that page.

Delete all rows from the search results.

Step 4

Reindex your Catalog URL rewrites.

Step 5

Go back to the category or product and click save.

Your urls should now be as desired!

The upgrade will help with the underlying cause of this, but will not correct it. You will still need to run through this process regardless.

Magento EE 1.13.1 – URL Rewrites Not Working and Indexing Issues

Try to reindex your URL rewrites. You are able to do it using shell in Magento EE 13+

cd [magento_root]/shell
php indexer.php --reindex catalog_url

If it didn't help:
Try to open some of the products in admin panel for editing and try to save it. Then, try to check the product's URL in the rewrite tables once again. Maybe the reason is the products were imported incorrectly somehow. If that way is solving your issue : You can make a script - just get products collection and save each product without making changes

$products = Mage::getModel('catalog/product')->getCollection();
foreach ($products as $_product) {
    $_product->save();
}

Also, you can add a try..catch structure in case if you have a problem with the product's saving.