cgmaster

hey dj, All seems to be working.. will give it a good work out later but so far so good... ps found where that comma was missing, you wouldnt want to blink!! Just like to pass on my thanks for this contribution, it's definitely made my job so much easier!! Thanks :)

Hey dj, just an update... re-checked above and tried... when i click on new order email.. the email goes through with the order number all good, problem is still with the first instance of email update status, just get a blank space where the order number is suppose to be (this is frustrating) as all other instances work but i cant advise client of update!! Found a second problem, this is in admin/orders.php after editing an order and returning to the Orders Details page (orders.php), if I try to update status and advise client i get the following error: 1136 - Column count doesn't match value count at row 1 insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('561', '1', '2007-08-03 20:22:51' '1', 'TEST') [TEP STOP] on checking via adminphp I notice the extra column - orders_status_history_id not listed in the error Have i missed an update here??? Thanks for your help

Hey dj from eo page when updating an order status with customer notify & comments... the email is sent with comments but just cant get it to send the order number in the format i use: using the following EMAIL_TEXT_ORDER_NUMBER . ' ' . tep_trans_id($order->info['date_purchased'],$_POST['oID']) . "\n" . no order number is sent at all, the function is defined in admin/functions/general.php any ideas!!

The function is defined in functions/general.php

Dunno why but now with the above corrections there is no output at all!!!! The status, date & comments all go through but it doesn't seem to be getting the purchase date, any ideas??? cheers

hey guys... i haven't given up on this yet!!!! spent quite a bit of time lookin back over everything, still couldn't get updated shipping quotes, so i removed all OE code and installed the latest version 5, well its all working, fantastic job and thanks to all involved in getting this all together!!! even got my improved order numbers to work in most areas... this may be a simple question, but how can i get the order number to send via the customer update email from edit_orders_ajax.php??? The format i use in the standard admin\orders.php is : . tep_trans_id($order->info['date_purchased'],$oID) . but i have noticed the $_POST thing happening and don't understand how to get my custom order id to send with the email: i use the format 260607-054734-0002 the order number in the database is just a simple number as oID = 2 etc Any help or suggests would be greatly appreciated, Thanks

Hi, Just installed this contribution!! well done, works well to a point, that is if your time zone is in a whole hour ie +2 or -2 but what about if your time zone is +2.5 or -2.5?? I have managed to get the TZ to match from my hosted server... as in correct local time for server, but how do I set this in admin to get the correct local time for orders etc as my times are always 30 mins out with the server time!!! any suggestions or help on this would be great, Thanks

Ok getting somewhere... all seems to be working now up to the Request Real-Time Shipping Quotes: I have 2 AusPost installed (auspost.php & auspostexpress.php) and local delivery (dly.php) I only get AusPost Express quote showing with the image file under Request Real-Time Shipping with no check button nothing else shows and in the drop down list there is only the 2 Auspost modules and Other but no Local Delivery I have checked all files for country code ['country_id'] etc... I even had an order with originally the local delivery and opened in editor... on update it totally dropped local delivery and only made avail the 2 auspost modules and other in the drop down & express under shipping service heading!!! If i select Express in the drop down it does not update to the amount given as the "live quote" amount, any thoughts on whats still screwy here??? Cheers M

Hey J, Yeah mine is the same but if I uncomment the section I posted i get the error order not found!!! but commented i am able to access the (order) edit page!!! however the shipping is still not working properly due to this code not getting the shipping method... The third if statement is the one coursing me grief!! if ($order->info['shipping_method'] == null) {.....etc Any ideas??

Hey J, Well i did have working few days ago.. but updated from your post on the 22nd, and so i worked back, thankfully i just had everything commented out i changed, and what i came up with was this section of code update.. this is giving me the error: //if ($order->info['shipping_method'] == null) { // $Query = "SELECT title FROM " . TABLE_ORDERS_TOTAL . " // WHERE class = 'ot_shipping' // AND orders_id = '" . (int)$oID . "'"; // $result = tep_db_query($Query); // $row = tep_db_fetch_array($result); // $order->info['shipping_method'] = $row['title']; //} when commented out again I get into the edit page no problems, but i cant see why it couldn't find the order??? getting there slowly!!!! any suggestions for this???

in answer to your questions - Atm just orders created by customer and i get ...edit_orders.php?oID=3&osCAdminID=9e7... The order number is 3 so not a complex number I checked the database via myphp and the order number is showing as a simple number 3 also, i believe the order number contribution just outputs the order id with the purchased date. When i load the order it shows as Order Number: 260607-061856-0003 with no problems - gets retrieved to the invoice and packing slip no problems, just when i go to edit order thats when i get the error, so basically i need a hand with retrieving the order id to edit but that also changes the number into the format 260607-061856-0003. I will try the example you have given me above this evening and see how i travel, but will check back here in case you have any further ideas!! I presume i will have the same problem with Order Editor 5.0 so might just get this version working first before updating or would you recommend upgrading to Order Editor 5.0 first! Cheers, M

" Well at least im on the right track... though to be honest i don't have a clue what changes need to be made, for this to get the order id or how to call the functions properly, I did try to follow the similar code as the initial install but im still getting the same error.. Error: No such order. from the contribution the following has been changed: \account.php \account_history.php \account_history_info.php \admin\invoice.php \admin\orders.php \admin\packingslip.php \includes\functions\general.php \admin\includes\functions\general.php The functionality is added by changing places the "ORDER_ID" is printed, and replacing int with the output from an added function "tep_trans_id($raw_date,$order_id) any pointers you can give would be great as far as format of the code, as i know $oID needs to be changed but just don't know how to call the data, does $oID have to be redefined somehow, im just lost on this!!! cheers

hey J, well... update... checked & rechecked every line of code posted and found 1 line not commented!! so i think, excellent here we go! but then went to edit an order and I get an error Error: No such order. so im looking at the code in orders as this appears all good on the site, I realized I am using another contribution - Improved Order Number The functionality is added by changing places the "ORDER_ID" is printed, and replacing int with the output from an added function "tep_trans_id($raw_date,$order_id)" The function for this is: (in case it helps) ------------------------------------------------------------------- // Output Transaction_ID = YYMMDD-SSmmHH-0001 // $raw_date needs to be in this format: YYYY-MM-DD HH:MM:SS // $order_id is passed from the customer order function tep_trans_id($raw_date,$order_id) { if ( ($raw_date == '0000-00-00 00:00:00') || ($raw_date == '') ) return false; $year = (int)substr($raw_date, 2, 2); $month = (int)substr($raw_date, 5, 2); $day = (int)substr($raw_date, 8, 2); $hour = (int)substr($raw_date, 11, 2); $minute = (int)substr($raw_date, 14, 2); $second = (int)substr($raw_date, 17, 2); $cart_id=sprintf("%02d%02d%02d-%02d%02d%02d-%04d",$year,$month,$day,$second,$minute,$hour,$order_id); return $cart_id; } //// -------------------------------------------------------------------------------- so now to get into even see the edit order it has to recognize the order id which it doesn't. It seems I have narrowed it down to this section of code in eo php if ($order->info['shipping_method'] == null) { $Query = "SELECT title FROM " . TABLE_ORDERS_TOTAL . " WHERE class = 'ot_shipping' AND orders_id = '" . (int)$oID . "'"; $result = tep_db_query($Query); $row = tep_db_fetch_array($result); $order->info['shipping_method'] = $row['title']; } I also do not get the order id back in the error just --> Error: No such order. if (!$order->exists) { $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); } Am i right that it has something to do with the -> AND orders_id = '" . (int)$oID . "'"; or do i need to make more changes through the whole edit_orders.php for this to all work? Thanks for any help you can give mate.

Hey J, well I updated all the files I have installed btw I am using Australia Post 2.02c_2 as my postage includes insurance in postage total and I don't need to separate it, as the latest release allows a choice, I dont want that option avail, so I have checked & re-checked all 3 files I am using auspost.php auspostair.php & auspostexpress.php mod files + graphics & language files all in place (ps ausposteconomy no longer used in aust, so is deleted) I am still not getting Request Real-Time Shipping Quotes: and continually get the following error: AusPOST International Parcel Post - AIR AusPOST International Parcel Post - AIR ERROR: The delivery rate for this option cannot be determined at this time If you prefer to use this option as your shipping method, please contact the store owner. (the auspost graphic does show!) I also have a fourth option installed - dly.php for local delivery but that has never shown up in the option drop down (so problem with that too i expect) The OSC flat rate when installed works fine! I haven't touched the dly.php yet - no point until AustPost is working... Any further ideas on this problem?? Cheers

hey J, sorry its taken a bit to test this... i enabled flat rate, dare not disable my auspost as is live store.. I tried using flat rate and updating order... calculation was done & get option to select, so result was: 3. Shipping Service Request Real-Time Shipping Quotes: Flat Rate (Best Way) - $100.00 <---------- price so no one selects (live store) So i tried to get live shipping and i get: 3. Shipping Service Request Real-Time Shipping Quotes: AusPOST International Parcel Post - AIR AusPOST International Parcel Post - AIR ERROR: The delivery rate for this option cannot be determined at this time If you prefer to use this option as your shipping method, please contact the store owner. Flat Rate Best Way $100.00 so it seems to just be the austpost payment modules not working... any more ideas??