Sorting attribute options

Question

I am adding new options to some existing attributes using the method below.

$option['attribute_id'] = $attribute->getId();
$option['value'][$value][0] = $value;
Mage::getModel('eav/entity_attribute')->addAttributeOption($option);

This is working fine but how can I insert a position/sort value for the option.

Answer 1

This is function addAttributeOption($option) in app/code/core/Mage/Eav/Model/Entity/Setup.php

    public function addAttributeOption($option)
    {
    $optionTable        = $this->getTable('eav/attribute_option');
    $optionValueTable   = $this->getTable('eav/attribute_option_value');

    if (isset($option['value'])) {
        foreach ($option['value'] as $optionId => $values) {
            $intOptionId = (int) $optionId;
            if (!empty($option['delete'][$optionId])) {
                if ($intOptionId) {
                    $condition = array('option_id =?' => $intOptionId);
                    $this->_conn->delete($optionTable, $condition);
                }
                continue;
            }

            if (!$intOptionId) {
                $data = array(
                    'attribute_id'  => $option['attribute_id'],
                    'sort_order'    => isset($option['order'][$optionId]) ? $option['order'][$optionId] : 0,
                );
                $this->_conn->insert($optionTable, $data);
                $intOptionId = $this->_conn->lastInsertId($optionTable);
            } else {
                $data = array(
                    'sort_order'    => isset($option['order'][$optionId]) ? $option['order'][$optionId] : 0,
                );
                $this->_conn->update($optionTable, $data, array('option_id=?' => $intOptionId));
            }

            // Default value
            if (!isset($values[0])) {
                Mage::throwException(Mage::helper('eav')->__('Default option value is not defined'));
            }
            $condition = array('option_id =?' => $intOptionId);
            $this->_conn->delete($optionValueTable, $condition);
            foreach ($values as $storeId => $value) {
                $data = array(
                    'option_id' => $intOptionId,
                    'store_id'  => $storeId,
                    'value'     => $value,
                );
                $this->_conn->insert($optionValueTable, $data);
            }
        }
    } else if (isset($option['values'])) {
        foreach ($option['values'] as $sortOrder => $label) {
            // add option
            $data = array(
                'attribute_id' => $option['attribute_id'],
                'sort_order'   => $sortOrder,
            );
            $this->_conn->insert($optionTable, $data);
            $intOptionId = $this->_conn->lastInsertId($optionTable);

            $data = array(
                'option_id' => $intOptionId,
                'store_id'  => 0,
                'value'     => $label,
            );
            $this->_conn->insert($optionValueTable, $data);
        }
    }
}

You can using array have index 'sort_order' to sort attribute. If it not setup, it have value as 0.