We are sorry but we cannot offer customer support for this extension, and it is provided "as-is" for free. We use it at a number of big shops and it works well.
Due to bugs in Magento, once an rewrite URL ends with -[number] you get more and more rewrite URLs to the same target. The number gets higher and higher. Indexing gets slower and slower.
This extension is a workaround for this problem. Requires Magento 18.104.22.168 or greater.
How to install using Modman (--copy)
- Make sure you run Magento 1.7 or newer
- Install Modman
cdto your Magento root dir
test -d .modman || modman init
modman clone --copy --force https://github.com/magehost/magehost_rewritefix
- If you keep your Magento code in Git: Add
php shell/mh_rewrite_cleanup.php -- cleanuponce
- Reindex the
Verify if needed
You can verify if your installation has this problem by using this query (presuming no DB prefix). If the largest count is > the number of stores then this is a hint that something is wrong.
SELECT id_path, count(*) as total FROM `core_url_rewrite` group by id_path order by total desc LIMIT 50
Also you can open the id_path with the highest count
select * where id_path = [ID from previous query]
There should be 1 entry per id_path for every store view - and not more - unless you renamed the product URI yourself.