chrometweaks.org

Whats a free web iPage hosting service that has no banners or ads?

Click Here To View All Answers...


First question I have is Whats a free web iPage hosting service that has no banners or ads? Looking forward for any answer. My 2nd question... Hi,.

When I place an order and I look in admin/customers/orders at the invoice I notice that osCommerce doesn't give the invoice a unique number. I need my invoices numbered for administrational purposes for one and as reference for my customers. Is it possible to add a reference number or a invoice number or something of the sort to the stock invoice system of osCommerce and if so, how do I do that?.

Thanks as always!..

Comments (58)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some investigation and get back to you if I find an anything. You should email the people at iPage as they probably know..

Comment #1

Yep, that did the trick. At least on the invoice and on the packing slip pages. Thanks Draven!.

However I've tried to put it on the orders.php page aswell, but there it doesn't seem to work. Does anybody have a solution for that one? Would like to display the invoice number there as well..

Thanks...

Comment #2

For clarification:.

I've inserted the code Draven mentioned in orders.php exactly the same way - and in the same place just above the payment method - as in invoice.php and packingslip.php. As said it works for invoice and packing slip, but not for orders. Strangely enough, even though I've put code in and create a new cell in the HTML table, it doesn't give me any error messages either. It just stays exactly the same as before I inserted the code. Which I find odd..

Anyone have an idea?.

Thanks...

Comment #3

Fixed. Fell for an obvious mistake.... was changing the test files again and testing in the live version. Problem solved now. Thanks!..

Comment #4

You can also have it display on the order summary page where all orders are displayed. In admin/orders.php, around line 470:.

Find:.

               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

Replace with:.

               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ORDERID; ?></td>.

               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

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>&nbsp;'$orders['customers_name']; ?></td>.

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>&nbsp;'$orders['orders_id']; ?></td>.

               <td class="dataTableContent"><?php echo $orders['customers_name']; ?></td>.

A few lines down, find:.

<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

Change to:.

<td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

Finally, add this line to /admin/includes/languages/english/orders.php:.

Define('TABLE_HEADING_ORDERID', 'Order ID');..

Comment #5

Hi,.

When I place an order and I look in admin/customers/orders at the invoice I notice that osCommerce doesn't give the invoice a unique number. I need my invoices numbered for administrational purposes for one and as reference for my customers. Is it possible to add a reference number or a invoice number or something of the sort to the stock invoice system of osCommerce and if so, how do I do that?.

Thanks as always!..

Comment #6

Actually, it does add an invoice number for each order, but for some odd reason, it does not display it by default..

I believe this query exists at the top of /catalog/admin/invoice.php:.

 $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"'");.

If so, this would get the invoice number on the page:.

<?php echo $oID;?>..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.