Simple Configurable Products
Is not compatible with Magento 1.7.x version.
The indexer returns an MySQL error:
Product Prices index process unknown error:
exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in /home/users/domain/mydomain.com/lib/Zend/Db/Statement/Pdo.php:228
#0 /home/users/domain/mydomain.com/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement-gt;execute(Array)
#1 /home/users/domain/mydomain.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo-gt;_execute(Array)
#2 /home/users/domain/mydomain.com/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql-gt;_execute(Array)
#3 /home/users/domain/mydomain.com/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement-gt;execute(Array)
#4 /home/users/domain/mydomain.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-gt;query('INSERT INTO `ca...', Array)
#5 /home/users/domain/mydomain.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-gt;query('INSERT INTO `ca...', Array)
#6 /home/users/domain/mydomain.com/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php(133): Varien_Db_Adapter_Pdo_Mysql-gt;query('INSERT INTO `ca...')
#7 /home/users/domain/mydomain.com/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Configurable.php(48): OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Configurable-gt;_prepareFinalPriceData()
#8 /home/users/domain/mydomain.com/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable-gt;reindexAll()
#9 /home/users/domain/mydomain.com/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price-gt;reindexAll()
#10 /home/users/domain/mydomain.com/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract-gt;reindexAll()
#11 /home/users/domain/mydomain.com/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process-gt;reindexAll()
#12 /home/users/domain/mydomain.com/shell/indexer.php(158): Mage_Index_Model_Process-gt;reindexEverything()
#13 /home/users/domain/mydomain.com/shell/indexer.php(198): Mage_Shell_Compiler-gt;run()
May 7, 2012
I had this isntalled on 1.6.2 workign not a problem with custom stock status isntalled, had to do the followign hack 1) In app/code/community/OrganicInternet/SimpleConfigurableProducts/etc/config.xml
Remove or comment-out:
however just updated to 1.7 and reisntalled everything and now im gettign this error Cannot initialize the indexer process.
could be that i tried that paid application by this guy before i found it did not work with 1.7
"So we create a new module with same functionality and it works on 1.5,1.6 and 1.7 alpha.
now im going to reisntall everythign to see if it works without first installign that stupid paid application which is supposed to be better so they claim, did not function as well as this one did. hopefully this still works on 1.7 if not can soemone please fix it. also the newer version is available on git hub
April 26, 2012
This extension makes doing custom work with products really really hard. Trying to pull a list of products for example, or getting price or stock information.
As the associated products are added as configurable options they aren't actual products meaning you have to actually get the configurable options for each product to get the children.
This doesn't make any logical sense when working in the Magento code.
April 20, 2012
works great on 1.6.2 - pictures, prices, short descriptions get updated but the long-description isn't updating - maybe because of my info-tabs, but i think i will figure this out very quicky! very good extension! Thanks!!!
April 12, 2012
Great extension, however there's one strange thing going on. When a configurable product is "most sold" it never shows up in the most sold tab in the admin dashboard. Same is in frontend with most sold extensions. Why?
March 20, 2012
We use Magento for our shop and we also wanted this functionality, but this module did not worked for us.
So we create a new module with same functionality and it works on 1.5,1.6 and 1.7 alpha.
Please feel free to ask additional questions or try our module. We have 14 days refund guarantee.
March 16, 2012
Great Product - I need some customization- Would like add max price in catalog.
March 11, 2012
I'm running Magento 1.6.2 with this extension - everything seems to work properly so far, save for one thing:
When attempting to add a quantity to your cart that is greater than the amount in stock of a configurable product option (ex. adding 12 Tshirts-Blue), the customer is redirected to the child URL, which doesn't exist if you set (as I have) all simple associated products to NOT be visible in the catalog.
Anyone else have this bug?
March 3, 2012
The price for the simple products associated with the configurable products no longer updates dynamically on the product page. I have tried to fix this with the "_clone" removal fix, but that's not working either. This bug is happening on the base/default themes as well as custom themes.
February 25, 2012
The extension works under 1.6.2
But if I add a custom option the website crash.
February 25, 2012