"core_url_rewrite"

Magento URL reindex (core_url_rewrite) duplicates patch

How to fix Magento URL reindex (core_url_rewrite) duplicates bug

There is one annoying problem in Magento – the url rewrite indexer creates tons of unnecessary custom rewrites for products with duplicate url_keys. This happens during every indexer run. As a result, the size of the core_url_rewrite table grows to enormous sizes. Please note that the problem is typical for Magento 1.7 – 1.9 and its above versions. Below, I will explain how to fix this bug with the help of our patch. But first of all let’s start with one real world example. Continue Reading