Post by mrrific » Sat Dec 13, 2014 5:48 pm

hi anyone can help me to display the custom column from tbl_order in admin orders table page. My column name is customorder_no. Thanks



Sat Dec 13, 2014 5:29 pm

Post by villagedefrance » Sat Dec 13, 2014 6:52 pm

ok but why do you need a custom order number?

Where is this number originating from? order creation at checkout (catalog) or Admin order creation (admin)?
If it is originating from Catalog, then you need to edit the "/sale/order.php" model file and add your new column in the Sql queries. Same principle for Admin if it is the case.

As you want to display it in your list, then you will have to edit the "getOrders" query as well, by adding your new column in the search array().
Then you need to also update the controller, the language and the template to display the new column header and content.

Not that easy. Good luck!

OpenCart custom solutions @

User avatar
Active Member


Wed Oct 13, 2010 10:35 pm
Location - UK
Who is online

Users browsing this forum: grgr and 61 guests