if your using module OrganicInternet SimpleConfigurableProducts for price display there is issue in displaying price in frontend
for that there is quick fix for this issue
'group_price' => new Zend_Db_Expr('pi.group_price'),
add this line
'base_group_price' => new Zend_Db_Expr('pi.group_price')
save it and clear cache
that’s it !!!!!!
There is one more issue in this module while doing re-indexing or saving product you will get this error
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘4-0-1’ for key ‘PRIMARY’, SQL error when updating products
for that follow this steps
Class: OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price
Method: public function catalogProductSave(Mage_Index_Model_Event $event)
_prepareFinalPriceData function replace below code
$select->columns(array( 'entity_id' => new Zend_Db_Expr('e.entity_id'), 'customer_group_id' => new Zend_Db_Expr('pi.customer_group_id'), 'website_id' => new Zend_Db_Expr('cw.website_id'), 'tax_class_id' => new Zend_Db_Expr('pi.tax_class_id'), 'orig_price' => new Zend_Db_Expr('pi.price'), 'price' => new Zend_Db_Expr('pi.final_price'), 'min_price' => new Zend_Db_Expr('pi.final_price'), 'max_price' => new Zend_Db_Expr('pi.final_price'), 'tier_price' => new Zend_Db_Expr('pi.tier_price'), 'base_tier' => new Zend_Db_Expr('pi.tier_price'), 'group_price' => new Zend_Db_Expr('pi.group_price'), 'base_group_price' => new Zend_Db_Expr('pi.group_price'), ));
for reindex issue use above code or replace attached file
I am getting the error:
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn’t match value count at row 1
when I try to re-index the product prices (all of the other indexes seem to be working fine)
if magneto version is 1.7 you have to add this code
'group_price' => new Zend_Db_Expr('pi.group_price'),
else no need of that row at all to cross check which are the fields in price index go to database and open catalog_product_index_price table cross check the fields they used in re-indexed time
