Order Number Question

[Ken_Shea]

Trying to determine if I am overlooking something or it is not available or implemented.

 

See no reference to any order number on any email order confirmation, orders in the Admin, invoices or packing slip. Am hoping I've overlooked something, if not need to look into getting this implemented.

 

Thanks

Ken

[Jack_mcs]

The order number may or may not be there, depending upon your version of oscommerce. But one place it has always been is in the order listing section in admin. If you go to admin->orders, for whichever order is selected, the order number will show at the top of the right column. It is difficult to see and there are addons that make it more obvious, Additional Order Info for example. It should also be in the order email but that can get changed if you have installed an addon that changes that part of the code.

[Ken_Shea]

Thanks Jack,

Yes, saw that and it's useful to select specific orders but short of what is needed.

For the time being will just have to do with out that feature.

 

Ken

[mhsuffolk]

To add order numbers to the Orders List in admin:

 

In admin/orders.php Find:

 

<tr class="dataTableHeadingRow">
		 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
		 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
		 </tr>

 

Replace With

<tr class="dataTableHeadingRow">
		 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
		 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_ORDER_ID; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
		 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
		 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
		 </tr>

 

Find:

<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
		 <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
		 <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
		 <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
		 <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
		 </tr>

Replace with:

<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
		 <td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>
		 <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
		 <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
		 <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
		 <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
		 </tr>

 

Martin

[Ken_Shea]

Thanks Martin, very much.

 

It is implemented, will a new order need to be placed to see results or should previous orders show order # now?

Presently the order# are not appearing on current orders.

 

Thanks

Ken

[mhsuffolk]

Sorry, forgot the last step

 

In admin/includes/languages/english/orders.php Find:

 

define('TABLE_HEADING_COMMENTS', 'Comments');
define('TABLE_HEADING_CUSTOMERS', 'Customers');
define('TABLE_HEADING_ORDER_TOTAL', 'Order Total');
define('TABLE_HEADING_DATE_PURCHASED', 'Date Purchased');

Replace with:

define('TABLE_HEADING_COMMENTS', 'Comments');
define('TABLE_HEADING_CUSTOMERS', 'Customers');
define('TABLE_HEADING_ORDER_ID', 'Order No');
define('TABLE_HEADING_ORDER_TOTAL', 'Order Total');
define('TABLE_HEADING_DATE_PURCHASED', 'Date Purchased');

 

It should now show order numbers for all orders old and new

Sorry about the omission

 

Martin

[Ken_Shea]

Martin,

Still no numbers, I'm sorry, it's true, "No good dead goes unpunished"

 

I can revert back to original, if it gets too bothersome.

 

Thanks

[Ken_Shea]

My mistake Martin, was looking at the wrong page, they are showing up just as you said they should.

 

Thanks again

Ken