Magento adding new options to a drop down attribute

Magento adding new options to a drop down attribute

August 1, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento adding new options to a drop down attribute

Adding New Options to Magento Dropdown Attributes

Hello! I’m currently working on a product synchronization script for Magento, and I’ve faced a similar challenge regarding managing dropdown attributes like size options. Let me guide you through the process of adding new options to an existing attribute.

Understanding Magento Attributes

In Magento, attributes are managed in the database under the eav_attribute table and the corresponding option values reside in the eav_attribute_option and eav_attribute_option_value tables.

When a new size is encountered during your product sync process, you’ll need to ensure it’s added as an option for the appropriate attribute. This involves inserting new records into these database tables.

Step-by-Step: Adding New Size Options

  1. Identify the Attribute

First, find the ID of the attribute you want to modify. You can query the eav_attribute table:

SELECT entity_type_id, attribute_code, attribute_id FROM eav_attribute WHERE attribute_code = 'size';
  1. Prepare the New Option Data

Create an associative array containing the new option data:

$new_option_data = [
    'attribute_id' => $attribute_id,
    'value'       => 'Large',
];
  1. Insert the New Option Record

Now, insert a new record into the eav_attribute_option table with the following SQL query:

INSERT INTO eav_attribute_option (attribute_id, sort_order) VALUES ($attribute_id, 10);
  1. Get the Inserted ID for the New Option Value

The inserted option will have its own unique option_id. You can retrieve this using the last insert id feature of your database:

  • For MySQL: $last_option_id = $connection->lastInsertId();
  • For PostgreSQL: $last_option_id = pg_last_oid($connection);
  1. Add a Value to the New Option

Finally, add a value for the new option in the eav_attribute_option_value table:

INSERT INTO eav_attribute_option_value (option_id, store_id, value) VALUES ($last_option_id, 0, 'Large');

Best Practices

  • Always use the appropriate database engine and indexing to improve performance.
  • Consider using Magento’s attribute API (Mage::getSingleton('eav/config')->addAttribute) for a cleaner integration with the core functionality.
  • Ensure your sync script handles conflicts gracefully (i.e., doesn’t overwrite existing options) by implementing a check before inserting new ones.

Conclusion

Adding new size options to Magento dropdown attributes requires a combination of SQL queries and careful management of database records. By following this guide, you can seamlessly integrate the discovered sizes into your existing product attribute sets during the sync process.

Remember that effective management of your e-commerce platform’s attributes is crucial for maintaining data consistency across products. I recommend exploring more advanced features like Laravel’s database query builder to streamline your sync script further.

Happy coding, and let me know if you have any other questions!

Catalog Database Orders

Our network