Magento: Not able to save data on multiple tables on DB

Question

I've followed some suggestions to have some data copied over from one table to another table on the DB but it's not working.

Based on the response I received on this questions: Magento: How to save data to order_payment and quote_payment

I tried to do the following on the Mage/Sales/etc/Config.xml file

<sales_convert_order_payment>
            <cc_bankname>
                <to_quote_payment>cc_bankname</to_quote_payment>
            </cc_bankname>
</sales_convert_order_payment>

and this

<sales_convert_quote_payment>
            <cc_bankname>
                <to_order_payment>cc_bankname</to_order_payment>
            </cc_bankname>
</sales_convert_quote_payment>

but the bank name is only saved on the sales_flat_quote_payment table and not on the sales_flat_order_payment table which is the one I need to have this new data displayed on the order invoice and on the admin back-end under order/view.

If I manually input the data on the DB (the bank name that is) I'm able to display this information where it's needed but I cannot keep track of every transaction to manually input the data upon order completion since customers get to see their order details once it has been sumbited and they would not be able to view the new data until I have done so myself.

does anyone know why the data is not being carried over to the sales_fat_order_payment table?

I'm having the same issue with a new mobile number attribute I created but I believe if I can solve this one, then I should be able to handle all other similar issues.

Answer 1

That technique (naming it using same name with Mage) won't work for config.xml. How it works? You need to read this article written by Alanstorm http://alanstorm.com/magento_config_declared_modules_tutorial

You need to create your own module by defining it in app/etc/modules (of course you should name it other than Mage).

eg: app/etc/modules/Test_Sales.xml

content:

<?xml version="1.0"?>
<config>
    <modules>
        <Test_Sales>
            <active>true</active>
            <codePool>local</codePool>
        </Test_Sales>
    </modules>
</config>

app/code/local/Test/Sales/etc/config.xml -> define your new config in here

In older version of magento, sales order stored in eav type. In higher version, it has been flatten. Look at the name: sales_flat_quote_payment, sales_flat_order_payment

Magento always keep their data backward compatible, that's why it has attribute name cc_owner in eav_attribute.

In your case, you don't need to create new value in eav_attribute (you just need to add column cc_bankname in sales_flat_quote_payment and sales_flat_order_payment which I'm pretty sure you have already created).

As you have said before, the problem why it is not saved to sales_flat_order_payment is because of cache issue (Magento cache the config.xml so you need to refresh it System > Cache Management > Configuration)