What database tables are updated when an order is placed?

[llmills]

Hi All

 

Does anyone know or how can I find out what tables are updated when I do the following please -

 

 

1 - create a new customer

2 - place an order as an existing customer

 

i have a lot of orders that i can export to a csv and i am looking to very quickly dump them into a database - i appreciate that i would have to tweek the csv or ceate multiple files to dump them into the db tables, but it would be quicker than spending 1/2 hours manually adding them!!!

 

I am using prestashop 1.4

[math_php]

Hi you,

 

Order, order_details,order_tax that you will have to link to product, product_lang, customer, address, order_state, payment...

This would be a lot of work to track all.

 

Think of a module which could be called for each new order (automaticaly or manually) and could generate a zip file with all csv or a xml file to directly add it to your billing system.

 

I can make it for few cookies.

 

Regards