I have Magento site and there are so many 301 redirected pages.

For example, www.example.com/catalog/product/view/id/910/category/3 is redirected to www.example.com/engine-parts/2000-2004-vw-sharan-starter-motor. After this type of all pages redirect for www.example.com/2000-2004-vw-sharan-starter-motor.

My website redirect pages above 2000. So how to remove all the redirects in Magento site?

2 Answers 2


If you are looking at the auto-generated rewrites in Magento's 'URL Rewrite Management' page then all of those URL re-writes are actually necessary in order for Magento to serve your products/categories at search engine friendly URL's.

For example:-


Instead of:-


If you wish to remove any custom / redundant URL rewrites, you can empty the core_url_rewrite table in the database (using the below SQL query). Once emptied, Magento will reinstate all the necessary URL rewrites that the system requires based on your store configuration.

TRUNCATE TABLE `core_url_rewrite`;

You can not reduce the amount of auto-generated redirects that Magento requires as this is how the system is built. Instead, you should make use of canonical URL's in Magento to ensure that search engines only pay attention to you desired URL display on your website.


Please browse through https://magento.stackexchange.com/questions/4169/remove-unnesessary-url-rewrites once. This URL should help you in removing duplicate/unnecessary URL.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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