Magento – Magento2 : Change custom attribute scope not working

magento2product-attributescope

I create a product custom attribute programatically. The scope was WEBSITE. But now I just realised that this attribute must have the scope as STORE, because I need different values according to the store view.

I changed the scope in backend, clean the cache, and when I went to edit the product, the scope was correct [STORE]. Then I change store, view so I can insert the value for the store view and the scope changed to [WEBSITE].

I went back and the scope was wrong again [WEBSITE].

I went again to the attribute (Stores > Attributes > Product), choose my attribute, and the attribute had the right scope. I didn't change anything, only save the attribute again and clean the cache. Then I edit the product and the scope was correct [STORE], then I change store view and the scope was wrong again [WEBSITE].

I check database and the attribute is ok.

Did this happening to anyone?
Anyone has a clue about this?

Thank you

Best Answer

You've probably solved your problem, but here is solution for people coming here from google as me. I've managed it by editing it straight in database.

It's not recommended to do such things - the safest way is to delete this attribute and add it again, but sometimes you have no choice. This is e.g. how to change attribute scope to GLOBAL.

UPDATE catalog_eav_attribute SET is_global = 1, apply_to = 'simple,virtual,configurable' WHERE attribute_id = YOUR_ATTRIBUTE_ID;

And then refresh cache.

Related Solutions

Magento – Super attribute scope change error

Store View Scope means you can have a value for the Default Scope (Global) and a different value for the Store view.

You have the following situation:

Store view: Global Scope Value, Store View Value:

store view 1: A,B

store view 2: A,C

If you change the scope from Store View to Global and you have products that already have values sets, Magento doesn't know what to do with the values. What values should we keep? A (the global one), B (the store view one). That is why you get the message.

The check is in Mage_Catalog_Model_Resource_Eav_Attribute::_beforeSave():

[...]
     if (($this->_data['is_global'] != $this->_origData['is_global'])
                && $this->_getResource()->isUsedBySuperProducts($this)) {
                Mage::throwException(Mage::helper('catalog')->__('Scope must not be changed, because the attribute is used in configurable products.'));
            }
[...]

You do have the following options:

if you didn't use that attribute yet, just delete it and create it again
if you are using it, create a new one and use import/export to update the values

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.

Best Answer

Related Solutions

Magento – Super attribute scope change error

Magento – Product images use default value

Related Topic