Configurable Products With Group Pricing

[Designs540]

Im trying to setup a confirguarble product with group pricing not just on the base price but also on the simple associated products. I understand and have configurable products working correctly but I dont see a field or option to add a different price increase for the simple products.

Example:

-Product A sells for $5 to consumers and $2.5 to dealers

-Product A in Large is an extra $1 for consumers and $.50 for dealers

-Product A in medium is an extra $.80 for consumers and $.40 for dealers

I want dealers to log into the site and order product for their store but I dont want to clutter the site with hundreds of simple products, I also dont want a seperate database for a consumer site and dealer site.

Is there a way to do this in Magento? Maybe an extension?

[iweb_p3mbo]

Hi,

Magento doesn't support this out of the box the way you want it to work. I think you could create a shipping cart / catalog price rule for every product but that will get unmanagaeable on a large catalog.

There is an extension that may do what you want...

http://www.magentocommerce.com/magento-connect/simple-configurable-products.html

[Designs540]

I installed that extension and it solves my problem but now indexing prices is failing.

Are there any known issues? Looks like it is trying to update a column that does not exist. I am using magento 1.9.x.......Any help on this would be great.

Below is the output from and index:

Product Attributes index was rebuilt successfully in 00:00:03
Product Prices index process unknown error:
exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does n ot match column list: 1136 Column count doesn't match value count at row 1' in / usr/www/users/fred4151/epicGear/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /usr/www/users/fred4151/epicGear/lib/Zend/Db/Statement/Pdo.php(228): PDOState ment->execute(Array)
#1 /usr/www/users/fred4151/epicGear/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /usr/www/users/fred4151/epicGear/app/code/core/Zend/Db/Statement.php(291): Va rien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /usr/www/users/fred4151/epicGear/lib/Zend/Db/Adapter/Abstract.php(480): Zend_ Db_Statement->execute(Array)
#4 /usr/www/users/fred4151/epicGear/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Z end_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#5 /usr/www/users/fred4151/epicGear/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Ze nd_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#6 /usr/www/users/fred4151/epicGear/app/code/community/OrganicInternet/SimpleCon figurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Config urable.php(133): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#7 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Catalog/Model/Resource/Pr oduct/Indexer/Price/Configurable.php(48): OrganicInternet_SimpleConfigurableProd ucts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Configurable->_prep areFinalPriceData()
#8 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Catalog/Model/Resource/Pr oduct/Indexer/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_ Configurable->reindexAll()
#9 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Indexer/Abstr act.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#10 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Process.php( 212): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Process.php( 260): Mage_Index_Model_Process->reindexAll()
#12 /usr/www/users/fred4151/epicGear/shell/indexer.php(168): Mage_Index_Model_Pr ocess->reindexEverything()
#13 /usr/www/users/fred4151/epicGear/shell/indexer.php(216): Mage_Shell_Compiler ->run()
#14 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[21S01]: Inse rt value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price_final_idx` S ELECT `inner`.`entity_id`, `inner`.`customer_group_id`, `inner`.`website_id`, `i nner`.`tax_class_id`, `inner`.`orig_price`, `inner`.`price`, `inner`.`min_price` , MAX(inner.max_price) AS `max_price`, `inner`.`tier_price`, `inner`.`base_tier` FROM (SELECT e.entity_id AS `entity_id`, pi.customer_group_id AS `customer_grou p_id`, cw.website_id AS `website_id`, pi.tax_class_id AS `tax_class_id`, pi.pric e AS `orig_price`, pi.final_price AS `price`, pi.final_price AS `min_price`, pi. final_price AS `max_price`, pi.tier_price AS `tier_price`, pi.tier_price AS `bas e_tier` FROM `catalog_product_entity` AS `e`
LEFT JOIN `catalog_product_super_link` AS `l` ON l.parent_id = e.entity_id
INNER JOIN `catalog_product_entity` AS `ce` ON ce.entity_id = l.product_id
INNER JOIN `catalog_product_index_price_idx` AS `pi` ON ce.entity_id = pi.entit y_id
INNER JOIN `core_website` AS `cw` ON pi.website_id = cw.website_id
INNER JOIN `core_store_group` AS `csg` ON csg.website_id = cw.website_id AND cw .default_group_id = csg.group_id
INNER JOIN `core_store` AS `cs` ON csg.default_store_id = cs.store_id AND cs.st ore_id != 0
CROSS JOIN `cataloginventory_stock` AS `cis`
LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_ id AND cisi.product_id = ce.entity_id
LEFT JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = ce.entity_id AND tad_status.attribute_id = 96 AND tad_status.store_id = 0
LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = ce.entity_id AND tas_status.attribute_id = 96 AND tas_status.store_id = cs. ORDER BY IF(IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock), 1, 0) DESC, pi.final_price ASC, pi.price ASC) AS `inner` GR
`inner`.`customer_group_id`,
`inner`.`website_id` ON DUPLICATE KEY UPDATE `tax_class_id` = VALUES(`tax_class_id`), `orig_price` = VALUES(`orig_price`), `price` = VALUES(`price`),price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`), `base_tier` = VALUES(`base_tier`), `group_price` = VALUES(`group_price`), `base_group_pricwww/users/fred4151/epicGear/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /usr/www/users/fred4151/epicGear/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /usr/www/users/fred4151/epicGear/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /usr/www/users/fred4151/epicGear/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /usr/www/users/fred4151/epicGear/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /usr/www/users/fred4151/epicGear/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /usr/www/users/fred4151/epicGear/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Con_Mysql->query('INSERT INTO `ca...')
#6 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Configurable.php(48): OrganicInternet_SimpleConfigurableP_Product_Indexer_Price_Configurable->_prepareFinalPriceData()
#7 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Pri
#8 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Process.php(212): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /usr/www/users/fred4151/epicGear/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#11 /usr/www/users/fred4151/epicGear/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#12 /usr/www/users/fred4151/epicGear/shell/indexer.php(216): Mage_Shell_Compiler->run()
#13 {main}

[iweb_p3mbo]

Hi,

I've never had that issue myself when using that plugin so not sure as to the problem.

Could you try on a base install with just that plugin and test it - just to rule out any conflicts with any other plugins?

[piyumishra86]

Hi Designs540,

The plugin you used is compatiable only upto Magento ver 1.5, to make it working on latest Magento it need some customizations. 

Let me know if you need any help regarding this. 

Skpye : deepakmishra83

[Designs540]

Yes, could you please help with this issue.