Magento 1.8 Product Attributes – Use Default Value for All Products

attributesmagento-1.8productstatus

I did a bulk action, to enable and disable all products for a storeview in my product overview.

But now all the products are not using the default value anymore for status.
Is there way to check the "Use Default Value" back again?

Best Answer

Quick and dirty way.
Identify the status attribute id.

SELECT 
    attribute_id
FROM 
    eav_attribute
WHERE
    attribute_code = 'status' AND 
    entity_type_id = (SELECT 
                entity_type_id 
              FROM 
                eav_entity_type
              WHERE
                entity_type_code = 'catalog_product'
            )

with the value you get from the above query run this (I got 273):

DELETE FROM 
    catalog_product_entity_int
WHERE 
    attribute_id = 273 AND
    store_id <> 0

This will delete the records for status attribute for all other store views except the default values.

Make sure you reindex when you are done.
And back up the db before trying it.

Related Solutions

Magento – Product Collections: Get ALL products even though “Show products that are out of stock” set to NO

Very weird. Can't really tell why, but removing ->addFinalPrice() fixed the issue. Obviously addFinalPrice() removes all products that aren't saleable/in stock.

Set Attributes to ‘Use Default Value’ for a List of Products

Basically, setting an attribute value to 'Use default values' means that you have to delete the row in the database for that attribute, for the specific product, for a store id.
Here is a simple solution that does that. It requires altering the database directly and some people will say that this is a big 'No-No' but it works.

$attrArray=array('thumbnail','small_image','image');
$products = array(170,171,172);
$stores = array(17,18,19);
$productsAsString = implode(',', $products);
$storesAsString = implode(',', $stores);
//get access to the resource
$resource = Mage::getSingleton('core/resource');
//get access to the db write connection
$connection = $resource->getConnection('core_write');
//model for retrieving attributes
$eavConfig = Mage::getModel('eav/config');
$tables = array();
//get the association between attribute ids and the tables where their values are stored
//group them by table name so you will run a single query for each table
foreach ($attrArray as $attributeCode){
    $attribute = $eavConfig->getAttribute('catalog_product', $attributeCode);
    if ($attribute){
        $tableName = $resource->getTableName('catalog/product') . '_' . $attribute->getBackendType();
        $tables[$tableName][] = $attribute->getId();
    }
}
//for each table delete the attribute values in the specified store for the specified products
foreach ($tables as $tableName => $attributeIds){
    $attributeIdsAsString = implode(',', $attributeIds);
    $q = "DELETE FROM {$tableName}
                WHERE
                    attribute_id IN ({$attributeIdsAsString}) AND
                    entity_id IN ({$productsAsString}) AND
                    store_id IN ({$storesAsString})";
    $connection->query($q);
}

This should be it. But in case I'm over-confident and this doesn't work, back-up your database first.

Best Answer

Related Solutions

Magento – Product Collections: Get ALL products even though “Show products that are out of stock” set to NO

Set Attributes to ‘Use Default Value’ for a List of Products

Related Topic