PHP MySQL – How to Mass Set Up a Custom Customer Attribute

MySQLPHP

Check this out:
enter image description here

I have two custom customer attributes: sms_promo and sms_on_order_change. Both have values only with 0 or 1.

My question is how for example i can set for all customers sms_promo to be 1 and sms_on_order_change to be 0 ?

Thanks in advance!

Best Answer

To set all custome attribuite value to all customer

Create new yourfile.php file in Magento Root Folder

<?php
    require_once realpath(dirname(__FILE__)) . '/app/Mage.php';
    Mage::app('');
    $customers = Mage::getModel('customer/customer')->getCollection();

    foreach($customers as $customer){
        $currentCustomer = Mage::getModel('customer/customer')->load($customer->getId());
        $currentCustomer->setSmsPromo(1);
        $currentCustomer->setSmsOnOrderChange(0);
        $currentCustomer->save();
    }
?>

Then run it on brower by load the following url www.domain.com/yourfile.php

Related Solutions

Magento – PHP – How to get custom customer attribute in order

It's very easy but not simple to understand.

First at all you should create the attribute for a customer. After it check with this code

$customer   = Mage::getModel('customer/customer')->load($customerId);
$customerAttr = $customer->getSmsOnOrderChange();

Then you should update tables sales_flat_quote and sales_flat_order, please add a new column to the tables 'sms_on_order_change'.

Now some magic in your module!

In config.xml you should add this code:

<global>
    <fieldsets>

        <customer_account>
            <sms_on_order_change>
                <to_quote>*</to_quote>
            </sms_on_order_change>
        </customer_account>

        <sales_convert_quote>
            <sms_on_order_change>
                <to_order>*</to_order>
            </sms_on_order_change>
        </sales_convert_quote>

        <sales_convert_order>
            <sms_on_order_change>
                <to_quote>*</to_quote>
            </sms_on_order_change>
        </sales_convert_order>

    </fieldsets>
</global>

No events, no observer. It doesn't require.

How to Fetch Data from MySQL Table and Create a Custom Select Menu

Take a look at Direct SQL Queries In Magento and https://magento.stackexchange.com/a/31329/519

/**
 * Get the resource model
 */
$resource = Mage::getSingleton('core/resource');

/**
 * Retrieve the read connection
 */
$readConnection = $resource->getConnection('core_read');

$query = 'SELECT * FROM ' . $resource->getTableName('extensa_econt_city');
//take a look at your config.xml that added extensa_econt_city table for the correct name   
/**
 * Execute the query and store the results in $results
 */
$results = $readConnection->fetchAll($query);

// display result

foreach($results as $row){
   echo $row['fieldName']
}

Best Answer

Related Solutions

Magento – PHP – How to get custom customer attribute in order

How to Fetch Data from MySQL Table and Create a Custom Select Menu

Related Topic