Order status update - Include order total

[loostaq]

Hello,

I need the order total to be automatically included in order status update email that customer receives. I have searched the solution in this forum and I know that I should modify the admin/orders.php file, but my only problem is that I don't know how to get the total to be printed in the email.

Any help would be much appreciated.

[loostaq]

EDIT: There are following lines in the orders.php:

//send emails
$message = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" .
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;

I believe this block needs to be edited, I just don't know how to add the order total in here.

[Ajeh]

You could add the field from the orders table to the select statement around line 90:

        $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                      date_purchased, order_total from " . TABLE_ORDERS . "
                                      where orders_id = '" . (int)$oID . "'"); 

Then you can use it with:
$check_status->fields['order_total']

And add the currency conversion for that and add it to the TEXT and HTML email below that ...

[loostaq]

THANK YOU!! That worked perfectly.

[Ajeh]

You are most welcome ... glad that this worked for you ...

[raimond]

You could add the field from the orders table to the select statement around line 90:

        $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                      date_purchased, order_total from " . TABLE_ORDERS . "
                                      where orders_id = '" . (int)$oID . "'"); 

Then you can use it with:
$check_status->fields['order_total']

And add the currency conversion for that and add it to the TEXT and HTML email below that ...

I can't get it work, what am I missing?

        $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) || zen_not_null($comments)) {
          $db->Execute("update " . TABLE_ORDERS . "
                        set orders_status = '" . zen_db_input($status) . "', last_modified = now()
                        where orders_id = '" . (int)$oID . "'");

          $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" .
          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] ) . "\n\n" . $check_status->fields['order_total'] . "\n\n" . 
          EMAIL_TEXT_STATUS_PLEASE_REPLY;

Is that also possible for just one particular order status update?

[raimond]

The best should be for me that the first email (order notification) is without all payment instruction and the second one (first order update) will be like the normal order notification. So order status mail with order total.

And the rest of the order status just the way it is.

I need that this way, because I must change the deliverycost later. I use the edit order module for it.

To much different products, weight, size to automize this with shipping costs.