Order numbers?

[peego]

In the admin>orders section, how do I get the order numbers for all the orders to show on the page? the only way to see order number is to click on an order, and it shows near the top right corner.

 

what I really need is to be able to see ALL order numbers for the orders in some sort of column (ie. beside the customer name for that order) is this possible?

 

also, how can I get order numbers to show on the invoices that gets printed? that's a nuisance when the customer don't even see their order number on the invoice... even tho its in the confirmation email.

 

thanks.

[Acheron]

I modified mine to look like this in admin/invoice.php:

 

          <tr>
           <td class="main"><b>Order ID:  </b><?php echo $oID;?><b><br><br><?php echo ENTRY_SOLD_TO; ?></b></td>
         </tr>
         <tr>
           <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>

 

I can't recall if the $oID variable was in there by default or if I created it. If not, here's the query to add to get it working:

 

  $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
 $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");