Magento – Programmatically Update a Single Attribute in Store View Scope

product-attributeprogrammaticallysavescope

If you load a product in Store View scope, all the inherited data ("Use Default Values") comes with it… which makes perfect sense, so far so good.

$_product = Mage::getModel('catalog/product')->setStoreId($storeId)->load($productId);

My problem is, if you then change one attribute and save, everything is saved at Store View scope.

$_product->setName($storeSpecificName)->save();

Now, if I look at the product in the admin, every "Use Default Values" checkbox is unticked 🙁

It doesn't help if I do $_product->save() or $_product->getResource()->save($_product). I even tried:

$_resource = $_product->getResource();
$_resource->isPartialSave(true);
$_resource->save($_product);

Maybe I'm misunderstanding what isPartialSave() does.

So, how do I change one (or more, but not all) attributes at Store View scope?

Best Answer

Load is pretty expensive memory wise.
You can use this for a faster update:

Mage::getSingleton('catalog/product_action')->updateAttributes(
    array($productId),
    array('name' => $storeSpecificName),
    $storeId
);

Related Solutions

Magento – Product images use default value

The scope of the attribute media_gallery is is_global = 1 which means it is global. You can try to change the scope, I don't know what the side effects are:

Just add to your sql update script:

$this->updateAttribute(
    Mage_Catalog_Model_Product::ENTITY,
    'media_gallery',
    'is_global',
    Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE
);

Good luck.

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

The problem was caused from another part of the script which loaded the product again to set the store view specific values. And the problem was to set the store id before loading the product.

My old code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->setStoreId('1')
    ->load($id)
    ... // set some store view specific data
    ->save();

The fixed code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->load($id)
    ->setStoreId('1')
    ... // set some store view specific data
    ->save();

Now only one entry get's inserted in the catalog_product_entity_* table – with store_id = 0.

Strange because I've seen it in the other order e.g. here: http://www.webguys.de/magento/produkte-mehrsprachig-importieren/ (german website)

Don't know if this is a bug, or there is a reasonable explanation for this behaviour.

Best Answer

Related Solutions

Magento – Product images use default value

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

Related Topic