Magento – Change Attribute Status Scope to Global

attributesmultistoreproduct-attribute

I have a magento single store website with multiple store views.
Sometimes I see attributes values of products like status are not set on default so generate confusion between store views.
Are there possible problems if I change the scope of the attribute "status" from Website to Global?
Thanks

Best Answer

It's possible, but you will have to remove existing website specific entries in the attribute value tables manually otherwise they'll just stay there and keep being used.

You can use a query like this (make a backup first!)

DELETE FROM catalog_product_entity_int WHERE store_id > 0 and attribute_id = 4711

Replace 4711 with the attribute id and int with the value type. You can look up both in the eav_attributes table.

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 – change the scope of product’s “status” attribute to store level

To hide products on different stores, normally the Visibility is used which works on store level.

I don't think it is a good idea to change the status scope to storeview, because indexing and other things are working with this value.

Best Answer

Related Solutions

Magento – Super attribute scope change error

Magento – change the scope of product’s “status” attribute to store level

Related Topic