Modifying Prestashop 1.6 Invoice

[icee]

Hello,
 
I know a bit of programming, but not so much php.
 
I need to change the normal order number that appears in the invoice to another column in the SQL table.

 
The table where this new number is located is `ps_orders` and the column is named ' mp_order_id '.

 

The problem is that I dont know how to make the query and what to edit.

 

 

Thank you for help,

[tuk66]

Try this solution

http://stackoverflow.com/questions/20897408/how-to-change-the-order-reference-to-number-reference