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();

Leave a reply

Your email address will not be published.