Magento – Update custom attribute value for all products – Magento1.9

magento-1.9product-attribute

I have a Magento store with products count 70,000 approx. I want to update 5 custom attribute's value for all products.

I have a CSV file which contains SKU and value of custom attributes for all products. Is there any option available to update/set value for all text types attribute either using MySQL query or programmatically?

Thank you.

Best Answer

This should give you an idea for how to run a script to perform a mass update on your products.

/*
 * Script to update custom attributes product values
 */

$_productCollection = Mage::getModel('catalog/product')
                    ->getCollection()
                    ->addAttributeToSelect('*');
$storeId = 0;

foreach($_productCollection as $_product)  {
    $product = Mage::getModel('catalog/product')->load($_product->getId());   
    $data = array(
                'custom_attribute_1' => 'VALUE_OF_ATTRIBUTE1',
                'custom_attribute_2 '=> 'VALUE_OF_ATTRIBUTE2',
    ); 
    Mage::getSingleton('catalog/product_action')->updateAttributes(array($product->getId()), $data, $storeId); 
}

Related Solutions

Magento – Programmatically import products and set custom attribute value

Your code looks like there are PHP syntax errors. For example:

   ->setCategoryIds(array(3, 11))
 $data=array(
   'afmeting' => '180 x 100',
   'afwerkingblad '=> 'Havanna',
   'afwerkingonderstel '=> 'Blank');

Also, when you call

$Simpleproduct->setData($data);

you're replacing the data on the product instance. I think you want to do:

$Simpleproduct->addData($data);

As for the SQL exception, it's a foreign key exception to the eav_attribute_set table. Can you double check that

->setAttributeSetId(4)

there's an attribute set with id 4?

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 – Programmatically import products and set custom attribute value

Magento – Set default value to custom attribute for all products

Related Topic