: How to remove duplicate URL in Magento site? 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-20

@Kaufman445

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:-
example.com/2000-2004-vw-sharan-starter-motor

Instead of:-
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.

Vote Up Vote Down

@Gonzalez347

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

Vote Up Vote Down