Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Organic Internet Simple Configurable Products module issue in price display in magento 1.7
 
pradeep_kumar67
Sr. Member
 
Avatar
Total Posts:  160
Joined:  2010-06-24
Bangalore
 

Hi,

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

you have follow this steps

1. open

app\code\community\OrganicInternet\SimpleConfigurableProducts\Catalog\Model\Resource\Eav\Mysql4\Product\Indexer\Price\Configurable.php

after line no 87 that is after this line

'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)

file path is

app\code\community\OrganicInternet\SimpleConfigurableProducts\Catalog\Model\Resource\Eav\Mysql4\Product\Indexer\Price.php

Change:

$this->cloneIndexTable(true);
on line 58 to:
$this->clearTemporaryIndexTable();

Enjoy

File Attachments
Price.php  (File Size: 7KB - Downloads: 166)
Configurable.php  (File Size: 7KB - Downloads: 159)
 
Magento Community Magento Community
Magento Community
Magento Community
 
pradeep_kumar67
Sr. Member
 
Avatar
Total Posts:  160
Joined:  2010-06-24
Bangalore
 

in

app\code\community\OrganicInternet\SimpleConfigurableProducts\Catalog\Model\Resource\Eav\Mysql4\Product\Indexer\Price\Configurable.php

in

_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

File Attachments
Configurable.php  (File Size: 7KB - Downloads: 128)
 
Magento Community Magento Community
Magento Community
Magento Community
 
YWSW
Jr. Member
 
Total Posts:  1
Joined:  2012-07-17
 

None of these solutions seems to work for me.

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)

 
Magento Community Magento Community
Magento Community
Magento Community
 
pradeep_kumar67
Sr. Member
 
Avatar
Total Posts:  160
Joined:  2010-06-24
Bangalore
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
yshop
Jr. Member
 
Total Posts:  10
Joined:  2011-12-14
 

Works perfect! THANKS!

 
Magento Community Magento Community
Magento Community
Magento Community
 
decorinteriors
Jr. Member
 
Total Posts:  3
Joined:  2013-05-13
 

I’ve made all of the edits to the configurable.php and price.php files, but the cart still displays the lowest price, rather than the actual price for the selected associated product.

After looking at the comments in the configurable.php file, it looks like stock figures into the price used. Seems like lowest price used if no stock. We DO NOT manage stock, so our quantities are generally zero.

We have thousands of associated products, so this extension would save us a ton of time and effort if we can get it working properly.

Any help would be greatly appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
agolder89
Jr. Member
 
Total Posts:  2
Joined:  2014-01-06
 

Everything seems to work now, but when I try to reindex price data it goes to my host’s stock 404 page. Hitting the back button shows that the price data has been reindexed but the 404 error is still there any time I try to reindex. Has anyone had any luck getting this to work with community edition 1.8? I would appreciate any help with this as I am not a coder. Others seem to have this same issue but no website has pointed towards a fix yet.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top