Author Topic: Order Status Email with Order Status Description  (Read 42003 times)

_fD_

  • Jr. Member
  • **
  • Posts: 118
    • Printdesign :: Joomla! CMS Webdesign :: Apple Computer Support
Re: Order Status Email with Order Status Description
« Reply #15 on: June 10, 2010, 09:14:07 am »
Is there anybody cn pass me the hack to apply since I got other hack I can not just use the ps order file you posted.
Virtuemart 1.1.4
Many thanks great hack

Hello,

Do you still need help on this?

Best regards, Urs

Emet

  • Beginner
  • *
  • Posts: 1
Re: Order Status Email with Order Status Description
« Reply #16 on: August 19, 2010, 19:08:41 pm »
Hi!

Thanks for the hack. Im actually desperate to find a way for the customer to click 'order received' on the status page somehow so that the merchant knows. Is there a solution to this??

THANKS!

_fD_

  • Jr. Member
  • **
  • Posts: 118
    • Printdesign :: Joomla! CMS Webdesign :: Apple Computer Support
Re: Order Status Email with Order Status Description
« Reply #17 on: August 19, 2010, 20:03:23 pm »
Hi Ernet,

with VM you can setup maybee an e-mail link into the payment part for the html code.

For a better solution you have to hack the code.

Best regards,
Urs

_fD_

  • Jr. Member
  • **
  • Posts: 118
    • Printdesign :: Joomla! CMS Webdesign :: Apple Computer Support
Re: Order Status Email with Order Status Description
« Reply #18 on: February 07, 2011, 23:45:02 pm »
Hello all

The new file is ready for download.

Have somebody an idea, how to fix the following bug:

I write in the text in the order status description field in VM admin, save it. Then i open it and the line ends goes away.

Please help for it. Many thanks.

Best regards,
Urs

Download the file here:
http://www.frefeldigital.com/joomla-cms/komponenten-module-plugins-fuer-das-joomla-cms/virtuemart-hacks.html

_fD_

  • Jr. Member
  • **
  • Posts: 118
    • Printdesign :: Joomla! CMS Webdesign :: Apple Computer Support
Re: Order Status Email with Order Status Description
« Reply #19 on: February 07, 2011, 23:46:57 pm »
Hi!

Thanks for the hack. Im actually desperate to find a way for the customer to click 'order received' on the status page somehow so that the merchant knows. Is there a solution to this??

THANKS!

Hello Emet,

did you found a solution for it?

Would be an nice feature for some people to have it ;-).

Best regards,
Urs

gtelegadis

  • Beginner
  • *
  • Posts: 24
Re: Order Status Email with Order Status Description
« Reply #20 on: March 25, 2011, 17:03:03 pm »
Urs,

Do you have the old 1.1.4 version of ps_order.txt hack?  Or if you know if the 1.1.7 hack works with 1.1.4?  I'm not sure if you found a solution for the problem you are having, but I'm presuming the problem didn't happen on the 1.1.4 hack and since that's the version I'm running that version of the hack would be ideal for me.

FYI, I'm about 95% sure that this solution is going to be a perfect fit for anyone running Webgility's ECC software.  This acts as a bridge betweeen v/m and quickbooks (as well as other accounting software) in that it auto pulls the order details, auto creates invoices by auto pushing details to quickbooks, and if you are using fedex (ground, express, smartpost) it will auto push the details to create a fedex label and then post the tracking label on both quickbooks invoice and back to the virtuemart store.  Because virtuemart for some reason has no field code for tracking numbers, ECC will auto change the status to SHIPPED and puts the tracking number (I'm confirming this) in the order_status_description field when it posts back to virtuemart.  So if this hack takes the info from the commment field in the order history comment field in the back end individual order screen, AND since you can set up v/m to send an auto e-mail to the customer when the product ships, then effectively with this hack you will have an automated process where the customer receives an e-mail with tracking info when the product ships.

gtelegadis

  • Beginner
  • *
  • Posts: 24
Re: Order Status Email with Order Status Description
« Reply #21 on: March 25, 2011, 18:12:09 pm »
Nevermind, Urs.  I was able to figure it out:

For those who want to know what is JUST THE CODE to replace (in the event you already have hacks in place to ps_order.php:

STEP 1:  REPLACE THIS CODE AROUND LINE 364

Code: [Select]
$q = "SELECT first_name,last_name,user_email,order_status_name FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";
WITH THIS CODE:

Code: [Select]
$q = "SELECT first_name,last_name,user_email,order_status_name,order_status_description FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";
AND RIGHT AFTER THIS PRE-EXISTING CODE A FEW LINES FURTHER DOWN:

Code: [Select]
$q .= "AND order_status = order_status_code ";
ADD THIS CODE:

Code: [Select]
$q .= "AND order_status_description = order_status_description ";
STEP 2:  REPLACE THIS CODE AROUND LINE 372-394:

Code: [Select]
// MAIL BODY
$message = $VM_LANG->_('HI',false) .' '. $db->f("first_name") . ($db->f("middle_name")?' '.$db->f("middle_name") : '' ). ' ' . $db->f("last_name") . ",\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_1',false)."\n\n";

if( !empty($d['include_comment']) && !empty($d['order_comment']) ) {
$message .= $VM_LANG->_('PHPSHOP_ORDER_HISTORY_COMMENT_EMAIL',false).":\n";
$message .= $d['order_comment'];
$message .= "\n____________________________________________________________\n\n";
}

$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2',false)."\n";
$message .= "____________________________________________________________\n\n";
$message .= $db->f("order_status_name");

if( VM_REGISTRATION_TYPE != 'NO_REGISTRATION' ) {
$message .= "\n____________________________________________________________\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_3',false)."\n";
$message .= $url;
}
$message .= "\n\n____________________________________________________________\n";
$message .= $dbv->f("vendor_name") . " \n";
$message .= URL."\n";
$message .= $dbv->f("contact_email");

WITH THIS CODE FROM URZ' V. 1.1.7 (ALSO WORKS IN 1.1.4):

Code: [Select]
// MAIL BODY Geändert von ub Zeile 308 ergänzt mit oder_status_description und Zeilen 330 hinzugefügt
$message = $VM_LANG->_('HI',false) .' '. $db->f("first_name") . ($db->f("middle_name")?' '.$db->f("middle_name") : '' ). ' ' . $db->f("last_name") . ",\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_1',false) .' '. $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2',false)."\n\n";
$message .= $db->f("order_status_name")."\n\n";
$message .= $db->f("order_status_description")."\n\n";
if( !empty($d['include_comment']) && !empty($d['order_comment']) ) {
$message .= $VM_LANG->_('PHPSHOP_ORDER_HISTORY_COMMENT_EMAIL',false).":\n";
$message .= $d['order_comment'];
$message .= "\n____________________________________________________________\n\n";
}

$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2',false)."\n";
$message .= "____________________________________________________________\n\n";
$message .= $db->f("order_status_name");

if( VM_REGISTRATION_TYPE != 'NO_REGISTRATION' ) {
$message .= "\n____________________________________________________________\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_3',false)."\n";
$message .= $url;
}
$message .= "\n\n____________________________________________________________\n";
$message .= $dbv->f("vendor_name") . " \n";
$message .= URL."\n";
$message .= $dbv->f("contact_email");

For those who aren't completely following where the field entry is located, you go to the admin backend of v/m, Orders, List Orders, click the actual order link you want to edit, look at the top right of the screen and you will see 2 tabs.  Click the first tab:  Order Status Change and you will see Order Status drop down and a Comment box where you can input text.

Using my tracking example above, after installing the hack, the manual process would be to change the status to Shipped, and enter in the tracking number in the comments box (might want to also give the customer the URL of your shipper's tracking page where they could enter in the tracking number) and make sure the check box next to Notify Customer and Include This Comment is checked.  Then click Update and the customer will now receive an e-mail with the tracking ID in it.

I'm looking into trying to figure out how to hack the e-mail itself, as it's pretty unfriendly on it's face.  Will get back if I figure out a way.

_fD_

  • Jr. Member
  • **
  • Posts: 118
    • Printdesign :: Joomla! CMS Webdesign :: Apple Computer Support
Re: Order Status Email with Order Status Description
« Reply #22 on: March 25, 2011, 18:33:00 pm »
Hi gtelegadis,

that sounds good. You mean, with this hack, the line ends gone away?

I take tomorrow a look into it and give you then feedback here.

Thank you for your effort on it.

Best regards
Urs

morob

  • Beginner
  • *
  • Posts: 10
Re: Order Status Email with Order Status Description
« Reply #23 on: April 12, 2011, 15:18:18 pm »
Hi all, I'm trying to implement the above step by step code changes posted by gtelegadis with VM 1.1.8 but I ended up with the system not sending any emails regarding orders. Is there something different perhaps at VM 1.1.8? Thanks.

gtech

  • Beginner
  • *
  • Posts: 46
    • Suknie slubne
Re: Order Status Email with Order Status Description
« Reply #24 on: June 15, 2011, 15:26:50 pm »
Confirmed working on 1.1.7
Thank you for your great work!
I love what I do  - I do www
Suknie Slubne Suknie Wieczorowe

gajdam

  • Beginner
  • *
  • Posts: 1
Re: Order Status Email with Order Status Description
« Reply #25 on: August 20, 2011, 18:23:09 pm »
Hi!
Is it working on VM 1.1.9 ?? Have sb tried?
Best regards!

maxispin

  • Jr. Member
  • **
  • Posts: 174
Re: Order Status Email with Order Status Description
« Reply #26 on: January 01, 2012, 11:31:05 am »
1.1.7 hack works also on 1.1.9. Tested this: http://www.frefeldigital.com/media/virtuemart-hacks/ps_order.txt
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9

grupavs

  • Beginner
  • *
  • Posts: 1
Re: Order Status Email with Order Status Description
« Reply #27 on: February 06, 2013, 14:04:06 pm »
1.1.8 vm mail I send html code. The customer sees the example below. Please help crack head now

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Hi Anna Name,

the status of your order No. 251 has been changed. The new status is:

The term of the


<p>Lorem Ipsum is simply dummy text of the </p>
<p><strong>Lorem Ipsum is simply dummy text of the </strong></p>
<p><br /><a href="http://companyname.com"><strong>Lorem Ipsum is simply dummy</strong></a></p>

If you want to see the order details, click this link (or copy the address into your browser):
http://www.companyname.com/index.php?option=com_virtuemart&page=account.order_details&order_id=251&Itemid=176

____________________________________________________________
company name

info@companyname.com

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

thank you in advance for any help