Printable View
My Quick Status Update contribution is now available in the Zen Cart Free Software Add Ons area:
http://www.zen-cart.com/index.php?ma...oducts_id=1862
This mod allows you to update the status of an order from the Customers->Orders screen without having to open the order up. It adds a dropdown list of statuses under the buttons on the right hand side of the screen.
My orders.php file is customized.
How do I just add the codes to add the "Update" button to this file.
Hi Scott,
Thanks for developing this mod. Looks like a handy time saver.
Just a quick question, is it suitable for Zen Cart 1.3.8a or only for the latest version?
Many thanks :smile:
Thanks Scott - this mod should save me some time :smile:Quote:
Originally Posted by swguy
@Green333 and @harry2cool: just look in orders.php for the 2 blocks that start and end with "quick status update." Then place them in your admin/orders.php file in the appropriate places.
Thanks for that! Shall try that later today :smile:Quote:
Originally Posted by swguy
You are a champion:clap:
I realy miss the checkbox for customer notification of the status. I assume the customer does not receive an email of this status change.
Also was wondering this ...additionally, customer's status is not updated to 'delivered' were they were to log in? (as status remains as pending/processing in the status area on the invoice in admin)....just wondering if this is correct?Quote:
Originally Posted by erwin208
Thanks - still a great mod :smile:
No email. Not having to click a checkbox and press the submit button are are part of the whole "quick" thing.
silly question maybe, is this compatible with 1.3.8a? i want to upgrade but cant at the moment, but would like to use this mod if poss in the meantime?
You would have to merge the 1.3.9 version changes into 1.3.8 files, but certainly this could be done.
THANK YOU THANK YOU THANK YOU :clap::laugh:
We have 3-5 status changes between receiving an order and shipment. These are internal only, and clicking on the order, waiting for the edit screen to come up, and REMEMBERING to click "no email" is a pain. You've likely saved me 2-3 hours a week.
Thanks!
Actually, spoke too soon. Is there a way to actually update the DB status at the same time, so it's searchable? Thanks!
thanks for your reply, i went in for the kill and updated my whole site, i thought it pointless to roll back mods i needed and could just as easily use on 1.3.9, anyway the mod is installed and working great, however not as i expected - once i have changed order status and customer checks their order status (cowoa) or they log into to check from within their registered account - it still comes up as processing. no change front end, nor does it change the entry on the invoice notes etc, only notable difference is in the orders page itself where the quick switch is. is this what is supposed to happen?
The situation you're describing sounds like you haven't merged admin/orders.php correctly. This is not how it should work; the change should be visible in all places where the status appears; otherwise it wouldn't be very useful. :)
Hi swguy & bonnit,
I have exactly the same 'results' as bonnit mentioned. (Up to now, I assumed that was how it worked...:blush:)
Installed as per your previous post:
Would you have any other suggestions?Quote:
Originally Posted by swguy
Many thanks
Yes.
a) Back up your files.
b) Use my files.
c) Test. Ensure it works. (If it doesn't work, something else is broken.)
d) Slowly merge your changes back in, testing as you go.
Hi SWGUY
Many thanks for this contribution. It will save us a lot of time.
Like others I can't get it to work fully (it's just not updating the underlying order details) but refuse to give up.
Hopefully this is something dumb I'm doing. I've pasted the two bits of commented code you wrote into our orders.php file which has the EDIT_ORDERS contribution already in it. Then I've double checked everything, and it looks fine.
Thought maybe I'd missed a line or two from elsewhere in the code so used WinMerge to find any other differences and can't see any.
Finally wondered about the line below. Is there a missing 'action=something' where I've put '****'? To be honest grasping at straws now.
zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . '****','NONSSL'));
So then thought I'd just replace my orders.php with the one from the quick_status_update contribution. However that had exactly the same problem. So I guess it's either in the contribution, or in something that the contribution calls.
Any help appreciated.
actually i am stil getting this to, i havent had the time to delve any deeper than re-install and look for obvious conflicts, which to the best of my knowledge there are none screaming out at me?
Okay, sorted (I think)
The problem was that the original contribution updated the ORDERS table but didn't update the ORDERS_STATUS_HISTORY table.
So here is how I got it to work. Please see this as a starting point only as I'm not a Zen Cart expert and there may be unforeseen knock on effects.
What I did was to...
REPLACE THIS:
// eof quick status update
case 'quick_status_update':
$oID = zen_db_prepare_input($_GET['oID']);
$status = zen_db_prepare_input($_POST['status']);
if ($oID) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int)$oID . "'");
}
zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . '', 'NONSSL'));
break;
// eof quick status update
WITH THIS:
// bof quick status update
case 'quick_status_update':
$oID = zen_db_prepare_input($_GET['oID']);
$status = zen_db_prepare_input($_POST['status']);
if ($oID) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int)$oID . "'");
$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int)$oID . "',
'" . zen_db_input($status) . "',
now(),
'" . zen_db_input($customer_notified) . "',
'" . zen_db_input($comments) . "')");
}
zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . '', 'NONSSL'));
break;
// eof quick status update
I've tested it and it seems to work.
However please check it for yourself before trying it... BACKUP FIRST!
Also note that our ORDERS.PHP has been amended so that by default customers are NOT e-mailed on update. Not sure how this would work if customers were e-mailed on update.
OK, I see. Yes, it should update order status history - I thought people were saying order status wasn't updated, which is why I didn't understand what the problem was.
slf3 your code isn't quite right; please grab my fix from Free Software Add Ons. Version 1.1 has been posted.
Thanks for correcting my patch swguy
Yes, I guess $customer_notified and $comments were redundant.
:clap:Thanks to swguy & slf3
Works beautifully :smile:
Updated to support 1.5.0 and fix a bug in the creation of the status update form (missing end tag).
Anyway to just make it default to email customers? Once we get the order in we only update the status once to let the customer know it's shipped.
Even a starting point of how to code that myself would be much appreciated. You make some awesome addons BTW!:smile:
Search down in orders.php for 'update_order'. This has the email logic; copy that back to the 'quick_status_update' case.
Totally works! Thanks! :smile:Quote:
Originally Posted by swguy
In case anyone else needs to do this; all I had to do was pull everything from within the if/then block, and also grab the $check_status, from the same 'update_order' case, and paste it into the 'quick status update' block directly above it.
Viola! (this is from around line 80 or so).
PHP Code:// bof quick status update
case 'quick_status_update':
$oID = zen_db_prepare_input($_GET['oID']);
$status = zen_db_prepare_input($_POST['status']);
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
date_purchased from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
$notify_comments = '';
//send emails
$message =
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
//EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .
EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
EMAIL_TEXT_STATUS_PLEASE_REPLY;
$html_msg['EMAIL_CUSTOMERS_NAME'] = $check_status->fields['customers_name'];
$html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
//$html_msg['EMAIL_TEXT_INVOICE_URL'] = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
$html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
$html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
$html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);
zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
$customer_notified = '1';
//send extra emails
if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
}
if ($oID) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int)$oID . "'");
$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int)$oID . "',
'" . zen_db_input($status) . "',
now(),
'0', '')");
}
zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . '', 'NONSSL'));
break;
// eof quick status update
I tried to run it with super order
Without success .
I assume you mean ALL the code, including the payment transaction feedback and the download timings...the previous post has ignored that.Quote:
Search down in orders.php for 'update_order'. This has the email logic; copy that back to the 'quick_status_update' case.
I have used this, and it is working ok (including the message bar, which the original contribution code does not include)
PHP Code:// bof quick status update
case 'quick_status_update':
$oID = zen_db_prepare_input($_GET['oID']);
$status = zen_db_prepare_input($_POST['status']);
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
date_purchased from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
if ($check_status->fields['orders_status'] != $status) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int)$oID . "'");
$customer_notified = '0';
// if (isset($_POST['notify']) && ($_POST['notify'] == '1')) {
$notify_comments = '';
/* if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && zen_not_null($comments)) {
$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n";
}*/
//send emails
$message = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . //steve
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .
EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
EMAIL_TEXT_STATUS_PLEASE_REPLY;
$html_msg['EMAIL_CUSTOMERS_NAME'] = $check_status->fields['customers_name'];
$html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
$html_msg['EMAIL_TEXT_INVOICE_URL'] = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
$html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
$html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
$html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);
$html_msg['EMAIL_PAYPAL_TRANSID'] = '';
zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
$customer_notified = '1';
// PayPal Trans ID, if any
$sql = "select txn_id, parent_txn_id from " . TABLE_PAYPAL . " where order_id = :orderID order by last_modified DESC, date_added DESC, parent_txn_id DESC, paypal_ipn_id DESC ";
$sql = $db->bindVars($sql, ':orderID', $oID, 'integer');
$result = $db->Execute($sql);
if ($result->RecordCount() > 0) {
$message .= "\n\n" . ' PayPal Trans ID: ' . $result->fields['txn_id'];
$html_msg['EMAIL_PAYPAL_TRANSID'] = $result->fields['txn_id'];
}
//send extra emails
if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
}
} elseif (isset($_POST['notify']) && ($_POST['notify'] == '-1')) {
// hide comment
$customer_notified = '-1';
}
$order_updated = true;
//}
$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int)$oID . "',
'" . zen_db_input($status) . "',
now(),
'1',
'')");
$order_updated = true;
// trigger any appropriate updates which should be sent back to the payment gateway:
$order = new order((int)$oID);
if ($order->info['payment_module_code']) {
if (file_exists(DIR_FS_CATALOG_MODULES . 'payment/' . $order->info['payment_module_code'] . '.php')) {
require_once(DIR_FS_CATALOG_MODULES . 'payment/' . $order->info['payment_module_code'] . '.php');
require_once(DIR_FS_CATALOG_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_module_code'] . '.php');
$module = new $order->info['payment_module_code'];
if (method_exists($module, '_doStatusUpdate')) {
$response = $module->_doStatusUpdate($oID, $status, $comments, $customer_notified, $check_status->fields['orders_status']);
}
}
}
if ($order_updated == true) {
if ($status == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) {
// adjust download_maxdays based on current date
$chk_downloads_query = "SELECT opd.*, op.products_id from " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd, " . TABLE_ORDERS_PRODUCTS . " op
WHERE op.orders_id='" . (int)$oID . "'
and opd.orders_products_id = op.orders_products_id";
$chk_downloads = $db->Execute($chk_downloads_query);
while (!$chk_downloads->EOF) {
$chk_products_download_time_query = "SELECT pa.products_attributes_id, pa.products_id, pad.products_attributes_filename, pad.products_attributes_maxdays, pad.products_attributes_maxcount
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad
WHERE pa.products_attributes_id = pad.products_attributes_id
and pad.products_attributes_filename = '" . $chk_downloads->fields['orders_products_filename'] . "'
and pa.products_id = '" . $chk_downloads->fields['products_id'] . "'";
$chk_products_download_time = $db->Execute($chk_products_download_time_query);
if ($chk_products_download_time->EOF) {
$zc_max_days = (DOWNLOAD_MAX_DAYS == 0 ? 0 : zen_date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS);
$update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . (int)$oID . "' and orders_products_download_id='" . $_GET['download_reset_on'] . "'";
} else {
$zc_max_days = ($chk_products_download_time->fields['products_attributes_maxdays'] == 0 ? 0 : zen_date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + $chk_products_download_time->fields['products_attributes_maxdays']);
$update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . $chk_products_download_time->fields['products_attributes_maxcount'] . "' where orders_id='" . (int)$oID . "' and orders_products_download_id='" . $chk_downloads->fields['orders_products_download_id'] . "'";
}
$db->Execute($update_downloads_query);
$chk_downloads->MoveNext();
}
}
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}
//}
zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . '', 'NONSSL'));
break;
// eof quick status update
need merge orders.php with super_orders.php ?
It's not work.
I only did it for orders, not super orders.
Hi I've just installed this mod and am having a issue where it is not sending an email to customers ,when I change a status it does change but has the open lock instead of the green tick ... If I go into the order and send via there all works OK .Tried on 2 orders with same result.
I do use Fast easy checkout and have joined the 2 files together
File is to big to upload or load ..is there anything I should check for please
thanks
Nothing to check - it does *not* send the email. It's "quick" after all. :)
OK thanks ... I could have sworn it did ..used it a long time ago :)
At the moment we are working hard on modernising our workflow, and I think this module would be great!
Though, not sending e-mail is a problem for us. I don't have the knowledge, but maybe someone can make a config file or menu for this module.
With this we can enable e-mail, or enable the checkbox as visible, make a comment line. (For example, we use this to save our package numbers)
This will still be quicker than the extra click, and add a load of functionality. It should be integrated with ZC...
I've added optional email functionality...been meaning to post it up, I'll try and do that soon.
You can pm me with your email if you can't wait.
I was using this mod on the old version of ZC and had edited the code so that it sent the customer an email. I have tried to duplicated this function with the new ZC and mod and I can't get it to work. If anyone can assist me I would be very grateful.
Quick Status Update has been updated for Zen Cart 1.5.2 and 1.5.3.
Quick Status Update has been updated to Zen Cart 1.5.4.
Quick Status Update has been updated to Zen Cart 1.5.5a.
Quick Status Update has been updated for Zen Cart 1.5.6.
Does it not work for 1.5.5f? I loaded it (the 1.5.5a version, at least) and there was no change whatsoever. I did reload in my backup, just to be safe that there wasn't something I just wasn't seeing, and I don't want to try the 1.5.6 version since it IS supposed to be a different PHP base.
Works fine in 1.5.5f.
Is there a Github for this?
Long ago I expanded this to make it send emails in the same language as the order language (without changing the admin language), which we find very useful...
No Github. I actually designed it not to send emails.
I made the email optional:
Attachment 18210
That would be great. Can you share the code?Quote:
Originally Posted by torvista
My orders.php is heavily modified and I don't have the time to extract the code equivalent for this to ensure it is a drop-in solution for a vanilla ZC1.55f cart: you'll need to compare it yourself to the 1.55f file and extract the code you want.Quote:
Can you share the code?
My store is dual language, so it is also modifed for that (stores the order language with the order).
It is attached as-is.
Many thanks. But I don't see the checkbox. Are you sure that's the correct version of the file?Quote:
Originally Posted by torvista
Quote:
Originally Posted by hairydog
Line 1126 of his file
This functionality is built in to Zen Cart 1.5.7. Thanks to @torvista for the PR!