I'm trying to update configurable associated products. When I save my product I get this error:
Integrity constraint violation: 1062 Duplicate entry '183-137' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID' , query was: INSERT INTO `catalog_product_super_attribute` (`product_id`, `attribute_id`) VALUES (?, ?)<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;"> How can I update the configurable associated products?
i use this code to insert and update configurable product in my custom extention.
where all data get in data variable
$pid is configurable product id.
$aid is attribute id.
before you use this code u set session variable is edit to 0 or 1. 0- if new product , 1- if edit existing product
$data = $this->getRequest ()->getPost(); $pid=Mage::getSingleton('core/session')->getAttributeId(); $aid=Mage::getSingleton('core/session')->getAttributeValue(); Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); $prd = Mage::getModel('catalog/product')->load($pid); try { $totalRow=count($data['product_id']); if($totalRow>0) { $configurable = Mage::getModel('catalog/product')->load($pid); if(!Mage::getSingleton('core/session')->getIsEdit(0)) { $configurable->getTypeInstance()->setUsedProductAttributeIds(array($aid)); } $configurable->save(); $productModel = Mage::getModel('catalog/product'); $configAttributeCode = $productModel->getResource()->getAttribute($aid)->getAttributeCode(); $simpleProducts = Mage::getResourceModel('catalog/product_collection') ->addIdFilter($data['product_id']) ->addAttributeToSelect($configAttributeCode); $configurableProductsData = array(); $configurableAttributesData = $configurable->getTypeInstance()->getConfigurableAttributesAsArray(); for($l=0;$l<$totalRow;$l++) { $_product = Mage::getModel('catalog/product')->load($data['product_id'][$l]); $_product->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE); $_product->getResource()->save($_product); $productModel = Mage::getModel('catalog/product'); $attr = $productModel->getResource()->getAttribute($aid); $att_label = $attr->getSource()->getOptionText($data['attribute_type'][$l]); $productData = array( 'label' => $att_label, //attribute label 'attribute_id' => $aid, //attribute ID 'value_index' => $data['attribute_type'][$l], 'is_percent' => '0', //fixed/percent price for this option 'pricing_value' => $data['product_price'][$l] //value for the pricing ); $configurableProductsData[$_product->getId()] = $productData; $configurableAttributesData[0]['values'][$l] = $productData; } $configurable->setConfigurableProductsData($configurableProductsData); $configurable->setConfigurableAttributesData($configurableAttributesData); Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); $configurable->setCanSaveConfigurableAttributes(true); $configurable->setStatus(1); $configurable->save(); } } catch(Exception $e) { echo $e->getMessage(); } 