Floob Posted September 25, 2002 Posted September 25, 2002 Hi, I am in the admin section http://www.(yourdomain).com/admin/orders.p....php?oID=(ORDER NO)&action=invoice Replace () with valid values. I am interested in changing the details under SOLD TO: and SHIP TO: I want to rearrange the details from: Name Street Address Town, Postcode County, Country To: Name Street Address Town County Postcode Country Can I do this easily, is there 1 place to do it, or is it stored in different places? Any help much appreciated. Thanks Floob.
Mark Evans Posted September 25, 2002 Posted September 25, 2002 Can I do this easily, is there 1 place to do it, or is it stored in different places? Look at the address_format table in the database :) Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
Floob Posted September 25, 2002 Author Posted September 25, 2002 Thanks - that looks great. Can you explain where/how "address_summary" is used? I presume address_format_id 1 is the one I need to change Do I alter it at the db level? Is there documentation for this table? Cheers, Floob.
Mark Evans Posted September 25, 2002 Posted September 25, 2002 Can you explain where/how "address_summary" is used?I presume address_format_id 1 is the one I need to change Do I alter it at the db level? This is used in the tep_address_format() function which can be found in includes/functions/general.php Yes at the moment you need to edit it a DB level. If you look in the countries table you will find a field called address_format_id. Look at the value in this field for the country the order is going to that will tell you which record you need to edit :) Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
Floob Posted September 25, 2002 Author Posted September 25, 2002 Thats great. Works a treat. Thanks! Is there any way I can add "date of order" and the "order number" on the invoice page? Cheers Floob.
Ajeh Posted September 26, 2002 Posted September 26, 2002 Find the area in invoice.php for the last part of the code. <?php // BOF: WebMakers.com Added: Show Order Info ?> <!-- add Order # // --> <tr> <td class="main"><b>Order # </b></td> <td class="main"><?php echo tep_db_input($oID); ?></td> </tr> <!-- add date/time // --> <tr> <td class="main"><b>Order Date & Time</b></td> <td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td> </tr> <?php // EOF: WebMakers.com Added: Show Order Info ?> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> And the last part of the code in orders.php <?php // BOF: WebMakers.com Added: Show Order Info ?> <!-- add Order # // --> <tr> <td class="main"><b>Order # </b></td> <td class="main"><?php echo tep_db_input($oID); ?></td> </tr> <!-- add date/time // --> <tr> <td class="main"><b>Order Date & Time</b></td> <td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td> </tr> <?php // EOF: WebMakers.com Added: Show Order Info ?> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr>
Floob Posted September 26, 2002 Author Posted September 26, 2002 That worked great thanks. Although I only edited orders.php I couldnt find an invoice.php - was it important? I use 2.2 from early June 2002 Cheers, Floob.
Ajeh Posted September 26, 2002 Posted September 26, 2002 No, but should you bring your site current, that's the code for the invoice.php file :D
Recommended Posts
Archived
This topic is now archived and is closed to further replies.