Welcome, Guest. Please login or register.
Login with username, password and session length


VirtueMart 1.1.8 - [SECURITY RELEASE] is available! Read more....

  Advanced search

247031 Posts in 67504 Topics- by 258313 Members - Latest Member: Matej.iStraxx
Pages: 1 [2]   Go Down
Print
Author Topic: Order Status Email with Order Status Description  (Read 26529 times)
_fD_
Quality&Testing Team
Full Member
*
Posts: 113


WWW
« 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
Logged

My Virtuemart Hacks (Hacks from hacks normally :-) ):

VM 1.1.x
:: Show lowest Stocks in product.product_inventory.php hacked the version from Toivo Talikka
http://forum.virtuemart.net/index.php?topic=51229 ::

:: Order Email with Order Status Text and Comment ;-)
http://forum.virtuemart.net/index.php?topic=39703.msg124851#msg124851 ::
Emet
Newbie
*
Posts: 1


« 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!
Logged
_fD_
Quality&Testing Team
Full Member
*
Posts: 113


WWW
« 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
Logged

My Virtuemart Hacks (Hacks from hacks normally :-) ):

VM 1.1.x
:: Show lowest Stocks in product.product_inventory.php hacked the version from Toivo Talikka
http://forum.virtuemart.net/index.php?topic=51229 ::

:: Order Email with Order Status Text and Comment ;-)
http://forum.virtuemart.net/index.php?topic=39703.msg124851#msg124851 ::
_fD_
Quality&Testing Team
Full Member
*
Posts: 113


WWW
« 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
Logged

My Virtuemart Hacks (Hacks from hacks normally :-) ):

VM 1.1.x
:: Show lowest Stocks in product.product_inventory.php hacked the version from Toivo Talikka
http://forum.virtuemart.net/index.php?topic=51229 ::

:: Order Email with Order Status Text and Comment ;-)
http://forum.virtuemart.net/index.php?topic=39703.msg124851#msg124851 ::
_fD_
Quality&Testing Team
Full Member
*
Posts: 113


WWW
« 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
Logged

My Virtuemart Hacks (Hacks from hacks normally :-) ):

VM 1.1.x
:: Show lowest Stocks in product.product_inventory.php hacked the version from Toivo Talikka
http://forum.virtuemart.net/index.php?topic=51229 ::

:: Order Email with Order Status Text and Comment ;-)
http://forum.virtuemart.net/index.php?topic=39703.msg124851#msg124851 ::
gtelegadis
Newbie
*
Posts: 17


« 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.
Logged
gtelegadis
Newbie
*
Posts: 17


« 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:
$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:
$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:
$q .= "AND order_status = order_status_code ";

ADD THIS CODE:

Code:
$q .= "AND order_status_description = order_status_description ";

STEP 2:  REPLACE THIS CODE AROUND LINE 372-394:

Code:
// 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:
// 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.
Logged
_fD_
Quality&Testing Team
Full Member
*
Posts: 113


WWW
« 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
Logged

My Virtuemart Hacks (Hacks from hacks normally :-) ):

VM 1.1.x
:: Show lowest Stocks in product.product_inventory.php hacked the version from Toivo Talikka
http://forum.virtuemart.net/index.php?topic=51229 ::

:: Order Email with Order Status Text and Comment ;-)
http://forum.virtuemart.net/index.php?topic=39703.msg124851#msg124851 ::
morob
Newbie
*
Posts: 10


« 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.
Logged
gtech
Newbie
*
Posts: 37


WWW
« Reply #24 on: June 15, 2011, 15:26:50 pm »

Confirmed working on 1.1.7
Thank you for your great work!
Logged

I love what I do  - I do www
Suknie Slubne Suknie Wieczorowe
Pages: 1 [2]   Go Up
Print
Jump to: