Add payment date to orders table

[TomPol]

Hi,

 

I've problem, and I can't find any solutions. I want to add extra column to orders table - Payment Date (or date from last status update). Have anyone ideas? how can I add this column?

 

Thanks a lot!

 

Greets,

[TomPol]

Hi,

 

i searched in database and I found in ps_orders table - date_upd column. I think thats ok and i will try to add this column to my orders table.

 

Thanks!

[bellini13]

orders table does not need a payment date, there is already a payment table in prestashop (ps_order_payment), however most payment modules do not use it.

 

however I would suggest you update your payment modules, so that they add a record to the order_payment table, and that table has a date column that you could use to know when payment was made (payments are not always made/completed when orders are created).

 

That will also allow you to see the payment record details in the back office order details page