Simple Configurable Products index price error
Simple Configurable Products module from Organic internet is one of better solution for display configurable products.
However, Magento 1.7.0.2 not supported it completely.
To make it work, you simple should add in file:
app\code\community\OrganicInternet\SimpleConfigurableProducts\Catalog\Model\Resource\Eav\Mysql4\Product\Indexer\Price\Configurable.php
after(:87)
'group_price' => new Zend_Db_Expr('pi.group_price'),
this code:
'base_group_price' => new Zend_Db_Expr('pi.group_price')
and in file:
app\code\community\OrganicInternet\SimpleConfigurableProducts\Catalog\Model\Resource\Eav\Mysql4\Product\Indexer\Price.php
change:
$this->cloneIndexTable(true);
to:
$this->clearTemporaryIndexTable();