the lifecycle of an order

[crunch]

Hi all - first time prestashop user here - and loving it so far, although I am still finding out a lot of the details of how it functions. Hence this post...

I need to add some functionality to the site for my client whereby I need to create a CSV file of complete orders for each day, to transfer to another server, from which he updates his own separate inventory system. So Im creating a seperate php script which will look at the database and gets the following details for each order in the past 24 hours:

- id of order
- customer name
- street address
- suburb
- postcode
- state
- special instructions
- product reference
- quantity
- price

SO basically I'm looking for any documentation that shows the lifecycle of an order and/or describes the tables used in the database for keeping track of order details.

I'm guessing each 'order' is stored in the 'ps_orders' table, with 'ps_order_details' linking by 'id_order' and listing all products in the order. Im not sure what some other tables like 'ps_order_history' are for.

My main concern is what state should the order be in for me to need its details?
Obviously I only want orders that have been paid for, but do i also grab orders made on this day that have shipped? How do orders get marked as shipped? Is that done manually in the back office? etc etc more questions...

Is there a post or wiki page that can help me? Or is it a case of wading through the code to see how it functions?

Thanks for any advice!