Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

  1. 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.

  2. I need that data which store in Magento (MySQL) database after clicking on place order button (Please see diagram 1).

  3. I have created one custom table in Magento And I need to save all data that are going to Magento from Step 2.

  4. Also can anybody give me some idea like how can I customize code or which files I need to update?

  5. Also If anybody knows where should that data goes which is used for placing Order (I mean in which table)?

  6. Or please give me some Magento database ideas, such as how or which files I need to customize for my requirements?

share|improve this question

closed as too localized by jcolebrand Feb 28 '12 at 22:40

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.