I've create a custom module that create two custom attributes for the order.
etc.xml
<?xml version="1.0"?>
<config>
<modules>
<Companyname_modulename>
<version>1.0.1</version>
</Companyname_modulename>
</modules>
<global>
<helpers>
<modulename>
<class>Companyname_modulename_Helper</class>
</modulename>
</helpers>
<models>
<modulename>
<class>Companyname_modulename_Model</class>
<resourceModel>modulename_mysql4</resourceModel>
</modulename>
</models>
<fieldsets>
<sales_convert_quote>
<custom_field_one><to_order>*</to_order></custom_field_one>
</sales_convert_quote>
<sales_convert_order>
<custom_field_one><to_quote>*</to_quote></custom_field_one>
</sales_convert_order>
</fieldsets>
<resources>
<modulename_setup>
<setup>
<module>Companyname_modulename</module>
<class>Mage_Sales_Model_Mysql4_Setup</class>
</setup>
<connection>
<use>core_setup</use>
</connection>
</modulename_setup>
<modulename_write>
<connection>
<use>core_write</use>
</connection>
</modulename_write>
<modulename_read>
<connection>
<use>core_read</use>
</connection>
</modulename_read>
</resources>
</global>
</config>
SQL Script
<?php
$installer = $this;
$installer->startSetup();
$installer->addAttribute('order', 'custom_field_one', array(
'type' => 'varchar',
'backend_type' => 'varchar',
'frontend_input' => 'varchar',
'is_user_defined' => true,
'label' => 'Custom Field One',
'visible' => true,
'required' => false,
'user_defined' => false,
'searchable' => false,
'filterable' => false,
'comparable' => false,
'default' => ''
));
$installer->addAttribute('quote', 'custom_filed_one', array(
'type' => 'varchar',
'backend_type' => 'varchar',
'frontend_input' => 'varchar',
'is_user_defined' => true,
'label' => 'Custom Field One',
'visible' => true,
'required' => false,
'user_defined' => false,
'searchable' => false,
'filterable' => false,
'comparable' => false,
'default' => ''
));
$installer->addAttribute('order', 'custom_field_two', array(
'type' => 'varchar',
'backend_type' => 'varchar',
'frontend_input' => 'varchar',
'is_user_defined' => true,
'label' => 'Custom Field Two',
'visible' => true,
'required' => false,
'user_defined' => false,
'searchable' => false,
'filterable' => false,
'comparable' => false,
'default' => ''
));
$installer->addAttribute('quote', 'custom_field_two', array(
'type' => 'varchar',
'backend_type' => 'varchar',
'frontend_input' => 'varchar',
'is_user_defined' => true,
'label' => 'Custom Field Two',
'visible' => true,
'required' => false,
'user_defined' => false,
'searchable' => false,
'filterable' => false,
'comparable' => false,
'default' => ''
));
$installer->endSetup();
Then when save a value into this two custom attributes the value not saving ex:
Load the quote by customer ID:
$quote = Mage::getModel('sales/quote') ->loadByCustomer($customerId);
Save value in custom attributes:
$quote->setCustomFieldOne("ValueOne");
$quote->setCustomFieldtwo("ValueTwo");
The custom_field_one attribute is saved But the custom_filed_two attribute not saving any suggestions please?