Flatstanley Posted May 11, 2011 Share Posted May 11, 2011 I am trying to find where I can find in the Prestashop database tables the "Order Statuses" flag. I am trying to create a SQL script that exports order details that include the current "Order Status" for each order. Any ideas where I can find this info? Link to comment Share on other sites More sharing options...
xbfish Posted May 11, 2011 Share Posted May 11, 2011 If i am not wrong, it's under ps_order_history table. The field is id_order_state.You have to link up with ps_order table to get the big picture. For more information regarding id_order_state field, do refer to the table ps_order_state_lang. Link to comment Share on other sites More sharing options...
Flatstanley Posted May 12, 2011 Author Share Posted May 12, 2011 Thank you very much for such a quick response to my question. I will investigate it further. I will let you know how I go. ;-) Link to comment Share on other sites More sharing options...
xbfish Posted May 12, 2011 Share Posted May 12, 2011 Yes no problem. Please marked it as solve when it's done ! Link to comment Share on other sites More sharing options...
Flatstanley Posted May 12, 2011 Author Share Posted May 12, 2011 What I have found is...Table: ps_order_state_langid_order_state id_lang name template 2 1 4 - Payment accepted payment 3 1 1 - New Order 4 1 2 - Picking Slip Invoice 12 1 3 - Completed order awaiting payment Table: ps_order_historyid_order_history id_employee id_order id_order_state date_add77 0 46 3 40662.401577 0 46 12 40662.41067So it works!This history reflects all the changes made in the id_order_state for any order.Thank you very much ;-) Link to comment Share on other sites More sharing options...
xbfish Posted May 12, 2011 Share Posted May 12, 2011 No problem Glad it was of help Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts