Magento – Set dropdown value using text value

eavimportmagento-1.9productproduct-attribute

I have a small import script that will import product to Magento 1.

It works well but there is something not work.If a product attribute happen to be a select type attribute the value will not save. I can determine this cause through eav system and magento would like to have the option id and not text value.

I have:

$product->setColour('red')->save();

But magento want:

$product->setColour(22)->save();

Is a method in magento that will accept the text value and correctly set the option id in the background for me?

Best Answer

This is untested but should work:

$colourId = $product->getResource()->getAttribute("colour")->getSource()->getOptionId("red");
$product->setColour($colourId)->save();

Related Solutions

Magento – Create attribute option if not exists

You would need to check the attribute for the option you are adding, and if it doesn't exist, add it using Mage_Eav_Model_Entity_Setup.

<?php

foreach($productColors as $sku => $color) {

    addAttributeValue('color', $color);

}

function addAttributeValue($attributeCode, $attValue) {

    if (!attributeValueExists($attributeCode, $attValue)) {
        $attr_model = Mage::getModel('catalog/resource_eav_attribute');
        $attr = $attr_model->loadByCode('catalog_product', $attributeCode);
        $attr_id = $attr->getAttributeId();
        $option['attribute_id'] = $attr_id;
        $option['value']['option_name'][0] = $attValue;
        $setup = new Mage_Eav_Model_Entity_Setup('core_setup');
        $setup->addAttributeOption($option);
    }
}

function attributeValueExists($attribute, $value) {
    $attribute_model = Mage::getModel('eav/entity_attribute');
    $attribute_options_model = Mage::getModel('eav/entity_attribute_source_table');
    $attribute_code = $attribute_model->getIdByCode('catalog_product', $attribute);
    $attribute = $attribute_model->load($attribute_code);
    $attribute_options_model->setAttribute($attribute);
    $options = $attribute_options_model->getAllOptions(false);

    foreach ($options as $option) {
        if ($option['label'] == $value) {
            return $option['value'];
        }
    }
    return false;
}

This may need some tweaking for your particular situation, but the general idea works.

Magento 1.9 – Set Date Value to an Attribute in a Custom Model

Try below code for save...

    $dateValue = '2011-03-05'
    $value = date('Y-m-d', strtotime($dateValue));
    $mynewitem->setEndDate($value);

    try{
           $mynewitem->save();
        }catch (Exception $e) {
            Mage::logException($e);
        }

Best Answer

Related Solutions

Magento – Create attribute option if not exists

Magento 1.9 – Set Date Value to an Attribute in a Custom Model

Related Topic