Magento – how to add customer attribute with default values set for all existing entities

attributesmagento-1.9

I have code like this :

    $setup->addAttribute('customer', 'my_custom_attr', array(
            "type" => "text",
            "backend" => "",
            "label" => "Languages for filter in layered filter.",
            "input" => "text",
            "source" => "",
            "visible" => false,
            "required" => false,
            "default" => "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15",
            "frontend" => "",
            "unique" => false,
            "note" => "Imploded with comma array of language id's."
        )

attribute adds successfully but the default value is not avaliable for all existed entity:

    Mage::getModel('customer/customer')->getCollection()->getFirstItem()->getMyCustomAttr(); // null

but attribute exists, and i am able to update it, etc.

is it possible to set it as default or I need to update all existed records manually ?

I found this Set default value to custom attribute for all products but here it is Mage::getModel("catalog/product_action") model is used to update attributes, is there some way of doing it for customer entities ?

Best Answer

Please create attribute like below -

$setup->addAttribute('customer', 'your_attribute_code_here', array(
    'input'         => 'text', //or select or whatever you like
    'type'          => 'int', //or varchar or anything you want it
    'label'         => 'Attribute description goes here',
    'visible'       => 1,
    'required'      => 0, //mandatory? then 1
    'user_defined' => 1,
));

OR following working for me.

$installer = $this;
$installer->startSetup();

 $setup->addAttribute('customer', 'my_custom_attr', array(
            "type" => "text",
            "backend" => "",
            "label" => "Languages for filter in layered filter.",
            "input" => "text",
            "source" => "",
            "visible" => **true**,
            "required" => false,
            "default" => "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15",
            "frontend" => "",
            "unique" => false,
            "note" => "Imploded with comma array of language id's."
        )
 $attribute   = Mage::getSingleton("eav/config")->getAttribute("customer", "my_custom_attr");

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

When adding the product attribute, set used_in_product_listing, used_for_sort_by and filterable to true.

You can do that with the following update script:

$installer = Mage::getResourceModel('catalog/setup', 'catalog_setup');
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'product_type', 'used_in_product_listing', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'used_for_sort_by', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'is_filterable', 1);
$installer->endSetup();

Thats all, if if you are NOT using the flat catalog.

If you enable the flat catalog product feature, then you need to ensure that your custom source model implements the methods getFlatColums(), getFlatIndexes() and getFlatUpdateSelect().
If they are missing, your attribute won't be included in the generated flat tables, even if used_in_product_listing is enabled.
Have a look at the class Mage_Eav_Model_Entity_Attribute_Source_Boolean for an example. You can probably copy over the methods with minimal adjustments into your custom source model from there. Otherwise, please ask a new question.

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 – Create a sortable and filterable custom attribute to stand-alone entity

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

Related Topic