In Magento, when any customer buys product from front-end, then at last customer goes through order placing.
According to my need, I have created one CUSTOM TABLE in Magento database. So my requirement is that I need to copy same data from Magento which goes in Magento database when we click on Place Order button.
I know it's little complex to understand, so here is the detailed scenario:
When any customer place Order in Magento, then all values (like Customer Name, shipping address, billing address, order no. etc.) are stored in Magento database.
I need that data which store in Magento (MySQL) database after clicking on place order button (Please see diagram 1).
I have created one custom table in Magento And I need to save all data that are going to Magento from Step 2.
Also can anybody give me some idea like how can I customize code or which files I need to update?
Also If anybody knows where should that data goes which is used for placing Order (I mean in which table)?
Or please give me some Magento database ideas, such as how or which files I need to customize for my requirements?