how to create option for grid column select in magento

how to create option for grid column select in magento

October 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
how to create option for grid column select in magento

Creating a select type column for a grid in Magento admin panel involves using the addColumn() function within your _prepareColumns() method. Here’s how you can achieve this:

Step 1: Understanding the addColumn() Function

The addColumn() function takes an array of parameters to define the column properties. Some important parameters include:

  • header: The label for the column header
  • index: The database field name that the column will display
  • type: The type of column (e.g., text, select, date)
  • options: An associative array containing the options for a select type column

Step 2: Defining Options for Select Type Column

For a select type column, you need to provide an array of options. These options can be static or dynamic.

Static Options

Static options are predefined and don’t change based on other data in your system. To define them:

$options = array(
    1 => 'Option 1',
    2 => 'Option 2',
    3 => 'Option 3'
);

$this->addColumn('my_select_column', array(
    'header' => Mage::helper('catalog')->__('My Select Column'),
    'index' => 'position', // The database field
    'type' => 'select',
    'options' => $options,
));

In this example, the column will have three options: Option 1, Option 2, and Option 3.

Dynamic Options

Dynamic options are generated based on data in your system. You can use a helper class to generate these options.

public function getMySelectOptions()
{
    $options = array();
    // Assume you fetch options from a database or other data source
    foreach ($this->getCategory()->getProducts() as $product) {
        $options[$product['entity_id']] = $product['name'];
    }
    return $options;
}

$this->addColumn('my_select_column', array(
    'header' => Mage::helper('catalog')->__('My Select Column'),
    'index' => 'position',
    'type' => 'select',
    'options' => $this->getMySelectOptions()
));

In this example, the options for the select column are generated dynamically based on the products in the current category.

Step 3: Combining Multiple Grid Columns

You can also combine multiple grid columns into a single select type column using the renderer option. This allows you to display more complex data in your grid.

$this->addColumn('my_select_column', array(
    'header' => Mage::helper('catalog')->__('My Select Column'),
    'index' => 'position',
    'type' => 'select',
    'options' => $this->getMySelectOptions(),
    'renderer' => 'adminhtml/widget_grid_column_renderer_input'
));

Conclusion

Creating a select type grid column in Magento involves using the addColumn() function and providing an array of options for the column. You can define these options statically or generate them dynamically based on your system’s data.

Remember to always test your grid columns thoroughly after making changes, as they are a critical part of the admin panel’s functionality.

For more advanced customizations like adding new grid types or creating complex grid filters, consider checking out our guide on Advanced Magento Grid Customization at LaravelCompany.

Catalog Database Admin Import/Export

Our network