Magento – Bulk adding & updating product attribute

magento-1.9product-attributesql

[M1]

I have over 2000 products in my Magento store. I want to add a new attribute called 'Warranty Terms' to display it on the frontend. This is going to be the same for all products. I know how to add a new attribute, but how do I mass update it for all products? Warranty terms attribute is going to require WYSIWYG editor.

I added a new attribute & tried bulk updating it through Catalog > Products > Select All > Update attributes, however, this new attribute is not displaying in the list of attributes that could be mass updated. Is there a way using codes or maybe through SQL query?

Best Answer

Why its not showing on list of attributes for mass update? Try re-index and clean cache, also check is your attribute added to all attribute sets.

If you want do this programaticaly check:

https://stackoverflow.com/questions/39664957/mass-update-of-product-attribute-text

Magento : Fastest way to update a product attribute

Related Solutions

Magento – Handling grouped product attributes

This should be what you need:

$product->getResource()->getAttribute('attribute_code')->getStoreLabel();

Magento – Set default value to custom attribute for all products

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
);

Best Answer

Related Solutions

Magento – Handling grouped product attributes

Magento – Set default value to custom attribute for all products

Related Topic