Magento – Set default value to custom attribute for all products

collection;default valuesmagento-1product-attributeproduct-collection

I have created the custom attribute (test) for products as a text field with default value('test') from admin panel

And assigned that attribute to default attribute set.

Now I can able to see the new custom attribute in product edit page.

When I try to filter with the product collection

Mage::getModel('catalog/product')->getCollection()
       ->addAttributeToSelect('*')
       ->addAttributeToFilter('test', array('like' => 'test'))->getData();

It return the empty array.

My Question is :

Is there any way to set the default value to attributes through installer script?

Why the default value is not set to that attribute?

Is there is any way to add the default values for all products?. I have more than 10,000 products in my store.

Note :

I don't want load the whole product collection and set value for each product.

Best Answer

You could try something like this. I believe the below method is quite efficient.

$attrData = array(
    'attribute_code_here'=> 'Default Value Here',
);
$storeId = 0;
$productIds = Mage::getModel('catalog/product')->getCollection()->getAllIds();
Mage::getModel("catalog/product_action")->updateAttributes(
    $productIds, 
    $attrData, 
    $storeId
);

Related Solutions

Magento – Creating custom attribute programmaticaly default value

default is the correct method for setting default values for the drop down, For example, My custom options are like,

Myoption-1
Myoption-2
Myoption-3
Myoption-4
Myoption-5

And your installer script should be like this,

$installer->addAttribute("customer", "mydropdown",  array(
    "type"     => "int",
    "backend"  => "",
    "label"    => "My Drop down",
    "input"    => "select",
    "source"   => "mymodule/eav_entity_attribute_source_customeroptions14042221240",
    "visible"  => true,
    "required" => false,
    "default" => "2",
    "frontend" => "",
    "unique"     => false,
    "note"       => "This is My Drop down option"

    ));

Here the default having values is 2. That means Myoption-2 is the default option. You may be entered wrong value. check the value of that option that you need to set as a default.

Magento 1.9 – How to Get All Values of a Custom Attribute

@Sukeshini,add groupByAttribute() to get data of unique data and remove null .

public function getAllTestIds() {
    $allValues = array();
    $collection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('*')->addAttributeToFilter('test_id', array(
    'notnull' => true,
    ))->groupByAttribute('test_id');

    foreach($collection as $product) {
        $data = $product->getData();
            $allValues[] = $data['test_id'];
       }
   }
return $allValues;
}

Best Answer

Related Solutions

Magento – Creating custom attribute programmaticaly default value

Magento 1.9 – How to Get All Values of a Custom Attribute

Related Topic