Take the 2-minute tour ×
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It's 100% free, no registration required.

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

share|improve this question
Did you manage to clean up your table? –  Sander Mangel Mar 31 at 18:20

1 Answer 1

up vote 5 down vote accepted

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.

share|improve this answer
you could exclude custom rewrites from the truncate by checking the is_system column or check for category or product id being set –  David Manners Mar 31 at 17:18
Thanks for the reply.. How can I see all the custom rules currently active? –  Luca Coppola Apr 1 at 9:28
Check DavidManners comment. You can check the table for is_system value 0 items, those are custom –  Sander Mangel Apr 1 at 9:30
thanks a lot guys! really great help –  Luca Coppola Apr 3 at 7:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.