Data base entry to identify that an order was completed

Hello,

I am wondering what piece of data in the database would allow me to clearly know that an order was completed - i.e. confirmed.

Is it order status or perhaps date of purchase field in orders?

thanks,

Daniel

Hello,

OK, i think i found it ...

Basically it appears that an order record is only generated once a customer confirms the order. At that time a record is generated with an order status and a purchase date. The order status, so it appears, can changed, as the order tucks along ...

Basically, if i want to know whether a customer has placed an order for a specific item, i must look:

1. the product id of the product in question
2. the order id associated with the product exists

The result can be several order ids. The purchase date for an order could then help distinguish between them.

thank you,

Daniel

3. the customer's ID will match the customer_id field in the orders table
4. orders_status in the orders table will match whatever the payment module set the order to upon payment authorization. In many cases, this is "Processing"
5. The most recent orders_status_history record for that order id will show the most recent status update, and in some cases, the payment module will also add some payment authorization details to the comments field.