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?
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:-
www.example.com/2000-2004-vw-sharan-starter-motor
Instead of:-
www.example.com/catalog/product/view/id/910/category/3
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.
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `core_url_rewrite`;
SET FOREIGN_KEY_CHECKS = 1;
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.
