Magento 1.9 – Create Dropdown Attribute for Products

databasemagento-1.9product-attribute

I want to create Dropdown Attribute for Products and want to fetch data from the database in created Dropdown Attribute.

Best Answer

$attribute = Mage::getModel('eav/config')->getAttribute( Mage_Catalog_Model_Product::ENTITY ,'attribute_code');
        $options = $attribute->getSource()->getAllOptions();
        print_r ($options);

<select name="some name">
<?php foreach($options as $option): ?>
  <option value="<?php echo $option['value'] ?>"><?php echo $option['label'] ?></option>
 <?php endforeach;?>
</select>

My updated answer to you

load your table collection by $coll = Mage::getModel('yourModel')->getCollection();

And foreach loop in your collection add all your option in $option as lable and value pair for each option

$attribute_model        = Mage::getModel('eav/entity_attribute');
$attribute_code         = $attribute_model->getIdByCode('catalog_product', 'your_attribute_code');
$attribute              = $attribute_model->load($attribute_code);
 $attribute->setData('option',$option);
        $attribute->save();

Try above code and let me know if it is not working

Related Solutions

Magento 1.9 – Create Custom Dropdown Attribute for Customer

Try this:

<?php
require_once('app/Mage.php');
Mage::app('default');

$installer = new Mage_Customer_Model_Entity_Setup('core_setup');
$installer->startSetup();
$entityTypeId     = (int)$installer->getEntityTypeId('customer');
$attributeSetId   = (int)$installer->getDefaultAttributeSetId($entityTypeId);
$attributeGroupId = (int)$installer->getDefaultAttributeGroupId($entityTypeId, $attributeSetId);

$installer->addAttribute('customer', 'track_device', array(
    'type'               => 'int',
    'label'              => 'Customer Device',
    'input'              => 'select',
    'forms'              => array('customer_account_edit','customer_account_create','adminhtml_customer','checkout_register'),
    'source'             => 'eav/entity_attribute_source_table',
    'required'           => false,
    'visible'            => 1,
    'user_defined'       => true, /* To display in frontend */
    'position'           => 110,
    'option'             => array('values' => array('Web', 'App'))
));

$installer->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'track_device', 100);

$oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'track_device');
$oAttribute->setData('used_in_forms', array('customer_account_edit','customer_account_create','adminhtml_customer','checkout_register'));
$oAttribute->save();

$installer->endSetup();


?>

Magento 1.9 – Set Custom Dropdown Attribute for Customer

You did not create Customer attribute properly.

As you have create a dropdown Customer attribute so you need to define source model for this attribute.

 "source"   => "[module_Model_Prefix]/source_option",

basically at this source class you have define option for that attribute

Also need to remove 'option' => array('values' => array('Inactive', 'Candidate', 'Certified')),

Source class

<?php
class [ModuleNameSpace]_[ModuleName]_Model_Source_Option extends Mage_Eav_Model_Entity_Attribute_Source_Abstract
{
    /**
     * Retrieve all options array
     *
     * @return array
     */
    public function getAllOptions()
    {
        if (is_null($this->_options)) {
            $this->_options = array(

                array(
                    "label" => Mage::helper("eav")->__("Inactive"),
                    "value" =>  1
                ),

                array(
                    "label" => Mage::helper("eav")->__("Candidate"),
                    "value" =>  2
                ),

            );
        }
        return $this->_options;
    }

    /**
     * Retrieve option array
     *
     * @return array
     */
    public function getOptionArray()
    {
        $_options = array();
        foreach ($this->getAllOptions() as $option) {
            $_options[$option["value"]] = $option["label"];
        }
        return $_options;
    }

    /**
     * Get a text for option value
     *
     * @param string|integer $value
     * @return string
     */
    public function getOptionText($value)
    {
        $options = $this->getAllOptions();
        foreach ($options as $option) {
            if ($option["value"] == $value) {
                return $option["label"];
            }
        }
        return false;
    }

Best Answer

Related Solutions

Magento 1.9 – Create Custom Dropdown Attribute for Customer

Magento 1.9 – Set Custom Dropdown Attribute for Customer

Source class

Related Topic