Hi there.

I'm Erfan - a full-stack Magento developer and consultant living in Perth, Australia. I'm the organiser of Western Australia's Magento meetup and at the moment I'm working at SPEQS, a startup that will revolutionise how people buy eyewear online.

A lot of times I’ve found the need to create a “Shop” page that shows the root category as an anchor (with layered navigation, for example). There are also a couple questions floating around on Stackexchange about how to have root categories be shown like normal categories.
By default Magento won’t show...

There are at least three issues with the catalog URL rewrite indexer and URL rewrite management in Magento:
A reindex will add a new rows for products with duplicate url_key's - every single time you reindex
Disabled products generate new rows
Products that are not-visible individually generate new...