magento adding custom customer field by mysql insert queries
Add a custom boolean customer field in Magento by directly inserting values into Magento mysql database.
INSERT INTO `eav_attribute` (`attribute_id`, `entity_type_id`, `attribute_code`, `backend_model`, `backend_type`, `frontend_input`, `frontend_label`, `source_model`, `is_required`, `is_user_defined`, `default_value`) VALUES ('999', '1', 'yes_no_flag', NULL, 'int', 'boolean', 'Yes No Flag', 'eav/entity_attribute_source_boolean', '0', '1', '0'); INSERT INTO `customer_form_attribute` (`form_code`,`attribute_id`) VALUES ('customer_account_edit', '999'), ('adminhtml_customer', '999'); INSERT INTO `customer_eav_attribute` (`attribute_id`, `is_visible`, `input_filter`, `validate_rules`, `is_system`, `sort_order`, `is_used_for_customer_segment`) VALUES ('999', '0', NULL, 'a:0:{}', '0', '999', '0'); INSERT INTO `eav_entity_attribute` (`entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`) VALUES ('1', '1', '1', '999', '1000');
Load customer, and set the custom customer field.
$customer = Mage::getModel('customer/customer')->load(12345);//load by id $customer->setData('yes_no_flag', 1); $customer->save();
Search within Codexpedia
Custom Search
Search the entire web
Custom Search
Related Posts