Integrity constraint violation: Duplicate entry for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID' The Next CEO of Stack OverflowError When Adding Attribute: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 1dynamic key => value pair adminhtml setting for custom moduleConfigurable product super attribute Integrity constraint violation errorMagento exception Integrity constraint violation: 1048 Column 'value' cannot be null' in libZendDbStatementPdo.php:234Magento: using duplicate product button, but emptying Url KeyMagento How to add configurable product while placing order programatically?Magento uses <h1> for the logo on EVERY page - Duplicate h1 tags
Elegant way to replace substring in a regex with optional groups in Python?
Is it possible to search for a directory/file combination?
Why does the UK parliament need a vote on the political declaration?
Multiple labels for a single equation
Interfacing a button to MCU (and PC) with 50m long cable
In excess I'm lethal
What benefits would be gained by using human laborers instead of drones in deep sea mining?
How to solve a differential equation with a term to a power?
Can I equip Skullclamp on a creature I am sacrificing?
How to count occurrences of text in a file?
How fast would a person need to move to trick the eye?
What can we do to stop prior company from asking us questions?
Anatomically Correct Strange Women In Ponds Distributing Swords
Why don't programming languages automatically manage the synchronous/asynchronous problem?
What does convergence in distribution "in the Gromov–Hausdorff" sense mean?
What exact does MIB represent in SNMP? How is it different from OID?
Would a galaxy be visible from outside, but nearby?
How did people program for Consoles with multiple CPUs?
Preparing Indesign booklet with .psd graphics for print
How to Reset Passwords on Multiple Websites Easily?
What happens if you roll doubles 3 times then land on "Go to jail?"
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
What is the result of assigning to std::vector<T>::begin()?
Limits on contract work without pre-agreed price/contract (UK)
Integrity constraint violation: Duplicate entry for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'
The Next CEO of Stack OverflowError When Adding Attribute: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 1dynamic key => value pair adminhtml setting for custom moduleConfigurable product super attribute Integrity constraint violation errorMagento exception Integrity constraint violation: 1048 Column 'value' cannot be null' in libZendDbStatementPdo.php:234Magento: using duplicate product button, but emptying Url KeyMagento How to add configurable product while placing order programatically?Magento uses <h1> for the logo on EVERY page - Duplicate h1 tags
I cant save the super attribute because i get error
$pricesByAttributeValues = array();
$baseCode = Mage::app()->getBaseCurrencyCode();
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
$rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToFilter('sku', array('like' => 'Miila-CV'));
foreach ($collectionConfigurable as $_configurableproduct)
$_configurableproduct->getId();
$_configurableproduct->getName();
$moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
//Get precio moneda base
foreach ($rates as $rate=>$value)
if (strcmp ($rate , $moneda_base ) == 0)
$moneda_base = $value;
//Precio y Ofertas
$precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
$descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
$desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
$_configurableproduct->setPrice($precio);
$_configurableproduct->setSpecialPrice($descuento);
$_configurableproduct->setDesde($desde);
//Configurables
$attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
$i = 0;
foreach ($attributes as $attribute)
$prices = $attribute->getPrices();
foreach ($prices as $price)
$pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
$pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
$pricesByAttributeValues[$i]['label'] = $price['label'];
$pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
$pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
$pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
$pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
$pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
$pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
$i++;
try
$_configurableproduct->setCanSaveConfigurableAttributes(true);
$_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
$_configurableproduct->save();
catch (Exception $e)
echo 'Excepción capturada: ', $e->getMessage(), "n";
magento-1 superattribute
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I cant save the super attribute because i get error
$pricesByAttributeValues = array();
$baseCode = Mage::app()->getBaseCurrencyCode();
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
$rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToFilter('sku', array('like' => 'Miila-CV'));
foreach ($collectionConfigurable as $_configurableproduct)
$_configurableproduct->getId();
$_configurableproduct->getName();
$moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
//Get precio moneda base
foreach ($rates as $rate=>$value)
if (strcmp ($rate , $moneda_base ) == 0)
$moneda_base = $value;
//Precio y Ofertas
$precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
$descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
$desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
$_configurableproduct->setPrice($precio);
$_configurableproduct->setSpecialPrice($descuento);
$_configurableproduct->setDesde($desde);
//Configurables
$attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
$i = 0;
foreach ($attributes as $attribute)
$prices = $attribute->getPrices();
foreach ($prices as $price)
$pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
$pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
$pricesByAttributeValues[$i]['label'] = $price['label'];
$pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
$pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
$pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
$pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
$pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
$pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
$i++;
try
$_configurableproduct->setCanSaveConfigurableAttributes(true);
$_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
$_configurableproduct->save();
catch (Exception $e)
echo 'Excepción capturada: ', $e->getMessage(), "n";
magento-1 superattribute
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I cant save the super attribute because i get error
$pricesByAttributeValues = array();
$baseCode = Mage::app()->getBaseCurrencyCode();
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
$rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToFilter('sku', array('like' => 'Miila-CV'));
foreach ($collectionConfigurable as $_configurableproduct)
$_configurableproduct->getId();
$_configurableproduct->getName();
$moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
//Get precio moneda base
foreach ($rates as $rate=>$value)
if (strcmp ($rate , $moneda_base ) == 0)
$moneda_base = $value;
//Precio y Ofertas
$precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
$descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
$desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
$_configurableproduct->setPrice($precio);
$_configurableproduct->setSpecialPrice($descuento);
$_configurableproduct->setDesde($desde);
//Configurables
$attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
$i = 0;
foreach ($attributes as $attribute)
$prices = $attribute->getPrices();
foreach ($prices as $price)
$pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
$pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
$pricesByAttributeValues[$i]['label'] = $price['label'];
$pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
$pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
$pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
$pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
$pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
$pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
$i++;
try
$_configurableproduct->setCanSaveConfigurableAttributes(true);
$_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
$_configurableproduct->save();
catch (Exception $e)
echo 'Excepción capturada: ', $e->getMessage(), "n";
magento-1 superattribute
I cant save the super attribute because i get error
$pricesByAttributeValues = array();
$baseCode = Mage::app()->getBaseCurrencyCode();
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
$rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToFilter('sku', array('like' => 'Miila-CV'));
foreach ($collectionConfigurable as $_configurableproduct)
$_configurableproduct->getId();
$_configurableproduct->getName();
$moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
//Get precio moneda base
foreach ($rates as $rate=>$value)
if (strcmp ($rate , $moneda_base ) == 0)
$moneda_base = $value;
//Precio y Ofertas
$precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
$descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
$desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
$_configurableproduct->setPrice($precio);
$_configurableproduct->setSpecialPrice($descuento);
$_configurableproduct->setDesde($desde);
//Configurables
$attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
$i = 0;
foreach ($attributes as $attribute)
$prices = $attribute->getPrices();
foreach ($prices as $price)
$pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
$pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
$pricesByAttributeValues[$i]['label'] = $price['label'];
$pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
$pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
$pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
$pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
$pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
$pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
$i++;
try
$_configurableproduct->setCanSaveConfigurableAttributes(true);
$_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
$_configurableproduct->save();
catch (Exception $e)
echo 'Excepción capturada: ', $e->getMessage(), "n";
magento-1 superattribute
magento-1 superattribute
edited Apr 13 '16 at 7:55
Siarhey Uchukhlebau
9,92693058
9,92693058
asked Apr 12 '16 at 5:21
Manuel MattarManuel Mattar
62
62
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.
For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:
$_configurableproduct->getId();
$_configurableproduct->getName();
...don't do anything at all, they're just useless.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110458%2fintegrity-constraint-violation-duplicate-entry-for-key-unq-catalog-product-sup%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.
For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:
$_configurableproduct->getId();
$_configurableproduct->getName();
...don't do anything at all, they're just useless.
add a comment |
I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.
For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:
$_configurableproduct->getId();
$_configurableproduct->getName();
...don't do anything at all, they're just useless.
add a comment |
I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.
For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:
$_configurableproduct->getId();
$_configurableproduct->getName();
...don't do anything at all, they're just useless.
I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.
For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:
$_configurableproduct->getId();
$_configurableproduct->getName();
...don't do anything at all, they're just useless.
answered Apr 13 '16 at 7:47
simonthesorcerersimonthesorcerer
3,56721127
3,56721127
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110458%2fintegrity-constraint-violation-duplicate-entry-for-key-unq-catalog-product-sup%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown