dporteous Posted March 24, 2006 Posted March 24, 2006 I need to be able to display the system generated order number at the confirmation stage of order processing. This is so customers who pay by check or bank transfer can enter the order number as a reference on their payment so that I can reconcile their payment as being received. I made changes on my invoice.php and packingslip.php files using a contribution from the forums and tried to use the same code in the catalog/checkout_confirmation.php but just can't figure out why the $oID variable doesn't seem to work or display. Can anyone help? Regards, Dave. Code is below: /* This should get the order number from the database and assign it to the variable $oID ??? */ $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 . "'"); /* And this should let me display it. */ <tr> <td class="main"><b><?php echo ENTRY_ORDER_NUMBER; ?></b></td> <td class="main"><?php echo $oID; ?></td> </tr>
Guest Posted March 24, 2006 Posted March 24, 2006 I need to be able to display the system generated order number at the confirmation stage... Look here... http://www.oscommerce.com/community/contributions,2499 Part of what this does is add the order number to the confirmation page. If you ignore the bits about actually scrambling the order number (which is what the contribution is primarily about) then you should see what you need to do just to add the number in the approapriate place. Rich.
dporteous Posted March 25, 2006 Author Posted March 25, 2006 Look here... http://www.oscommerce.com/community/contributions,2499 Part of what this does is add the order number to the confirmation page. If you ignore the bits about actually scrambling the order number (which is what the contribution is primarily about) then you should see what you need to do just to add the number in the approapriate place. Rich. Thanks for the suggestion but I'm struggling to extract the exact code. Can you pin point where I need to look?
echolalia Posted April 5, 2006 Posted April 5, 2006 Thanks for the suggestion but I'm struggling to extract the exact code. Can you pin point where I need to look? Hey dporteous, did you have any luck with working out how to add the order number to confirmation stage of order processing? I'm looking at doing the same thing. thanks
boxtel Posted April 5, 2006 Posted April 5, 2006 Hey dporteous, did you have any luck with working out how to add the order number to confirmation stage of order processing? I'm looking at doing the same thing. thanks Not sure about the mentioned contribution but normally the order number is generated AFTER order confirmation as before then there technically is no order and realistically there never may be. The order is generated my your database upon insertion. This implies that you can only show it on the subsequent pages like checkout success. Treasurer MFC
Recommended Posts
Archived
This topic is now archived and is closed to further replies.