Magento – Too many URL Rewrites

bugce-1.7.0.2producturlurl-rewrite

As you can see in the attached image, foreach product in my store I have too many rewrite rules.

I would like to have only one rule with the following syntax: mydomain.com/product-category/product-name-sku.html

How can I clear all the rules and make this new one?

url rewrite rule for single product

Best Answer

You can truncate the core_url_rewrite table in the database and run the URL Rewrite Index which will rebuild all the URLS. Keep in mind that any custom rewrite you might have added will be gone.

Related Solutions

Magento – URL Rewrite Management problem with rewrites

I think the Catalog URL system is creating an URL for the product and the rewrite being created by you is not working because of that.

Do this: 1. remove the custom rewrite you created manually. 2. go to product and create the rewrite from there. This means adding as URL key the string you want to use. For example, if you want www.domain.com/magento-2 put only magento-2 in the URL key field.

URL – Case Sensitive URL Rewrites

A huge amount of digging and I've found a single, tiny fix to get this to work.

Essentially, this is a drawback of MySQL as a data medium. MySQL is typically case insensitive. The field that stores the request paths has a 'UNIQUE' constraint upon it, meaning it can only store one of the below:

Category/ProductName.html
Category/productname.html

It treats both items the same, so the UNIQUE key disallows the second one, due to the presence of the first.

What I was able to do was change the COLLATION of the request_path field in the core_url_rewrite table from utf8 (the table default) to utf8_bin which makes it case sensitive.

Best Answer

Related Solutions

Magento – URL Rewrite Management problem with rewrites

URL – Case Sensitive URL Rewrites

Related Topic