magento 给customer添加属性 给order添加属性

//给 customer加
$installer->addAttribute('customer', 'cpsfrom', array(
		'label'         	=> 'Cpsfrom',
		'type'         		=> 'varchar',
		'input'         	=> 'text',
		'visible'       	=> true,
		'required'      	=> false,
		'position'			=> 1004,
		'sort_order'		=> 1004,
));

1. customer是添加到eav_attribute表里的 然后和相关表关联

2. order 是直接添加到了sales_flat_order 表里

//给order加属性 需要在Sales里
<?php
$installer = $this;
$installer->startSetup();

$installer->addAttribute('order', 'cpsfrom', array(
		'label'         	=> 'Cpsfrom',
		'type'         		=> 'varchar',
		'input'         	=> 'text',
		'visible'       	=> true,
		'required'      	=> false,
		'position'			=> 1004,
		'sort_order'		=> 1004,
));

$installer->endSetup();

setup 需要Mage_Sales_Model_Mysql4_Setup

//如果order里的属性加入完了 但是用不了 请更新产品属性索引

删除属性用  

$installer->startSetup();
$installer->removeAttribute('customer', 'is_school');
$installer->endSetup();

参考文档:

http://stackoverflow.com/questions/23775867/removing-a-custom-attribute-in-magento-via-an-installer-script

http://magento.stackexchange.com/questions/53991/unable-to-save-custom-order-attribute