Just a short note for now. We were having issues on a site with 19 stores 500 products and way too many attributes.

Layered navigation would not finish / update properly.

We tested the script by

//# Magento Layered Nav - Badger || Duck

//# @author: Chris McKee [chrismckee.co.uk]

it would leave the nav missing some attributes and we could not get all the stores to update.

Ended up with a basic script like the following, ran it in the shell and it did the trick.

require_once("app/Mage.php"); Mage::app('admin'); Mage::setIsDeveloperMode(true); mage::log("Clear Cache "); Mage::app()->cleanCache(); $flag = Mage::getModel('catalogindex/catalog_index_flag')->loadSelf(); if ($flag->getState() == Mage_CatalogIndex_Model_Catalog_Index_Flag::STATE_RUNNING) { $flag->delete(); mage::log("Delete Flag".$flag->getState()); } Mage::getSingleton('catalogindex/indexer')->plainReindex(null, null, null);