Customer Comments on Invoice

Hi

In previous versions of ZenCart (1.2.6) I had the Invoice configured to show customer comments. I think Dr Byte gave me the info and was as follows

<!--add comment starts--> <tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td> </tr> <!--add comment ends-->

Having just upgraded to 1.3.7 this code no longer works. I have been playing with it for ages now and nothing is working so I thought I would throw this one out to the Community to see if anyone has an answer

Cheers
Brinley

Worked it out!

I fogot to add the select query to the page

So for anyone else who wants to do this the below goes above the $order_check statement in Invoice.php in Admin

//--Add comments starts--
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added limit 1");
//--Add comments ends--

Also add the below code to the page -

<!--add comment starts--> <tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td> </tr> <!--add comment ends-->

Cheers
Brinley

thank you : )

Update on your helpful suggestion, just in case someone's wondering, this is the first part of your code, but I added the <?php, ?> to it..

<?php //--Add comments starts-- $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . zen_db_input($oID) . "' order by date_added limit 1"); //--Add comments ends-- ?>

Haven't tried it out yet though, but looks helpful.

very helpfull for us because we ship off these.

This was one of the answers I came looking for. Thank you. Gonna go try it out.

NOTE: this feature has been added as an option in the upcoming Zen Cart v1.3.8 ...

Display Order Comments on Admin Invoice
Do you want to display the Order Comments on the Admin Invoice?
0= OFF
1= First Comment by Customer only
2= All Comment for the Order

And of course for the Packing Slip as well ... :smile:

Ajeh:

NOTE: this feature has been added as an option in the upcoming Zen Cart v1.3.8 ...

And of course for the Packing Slip as well ... :smile:

Awesome! Thank you! ^_^

Quick update on this one - remove the limit 1 from the SQL statement then add the following code to display all the customer comments on the packing slip - not just the first...

<?php
	while (!$orders_history->EOF) {
		echo(zen_date_long($orders_history->fields['date_added']) . ": " . $orders_history->fields['comments'] . "<br>"); 
		$orders_history->MoveNext();
	}

?>

Hope this helps someone...

Another Thank You.
I came looking for this answer -- and found it here :smile:

Thank you! I added the code at the very end of the code, just before the </body> tag so that the comment shows up on the bottom of the invoice instead of the top--it was easier for me to see that way. Just thought I'd post it for anyone else.

But THANK YOU to the OP! This is very helpful to me!

Thanks for posting this useful modification, welshop.com !

Note: in v1.3.8a there are now Order Comments on the orders, packingslip and invoice as desired:
http://www.zen-cart.com/forum/showthread.php?t=81696

Look in the settings for Configuration ... Shipping/Packaging ...

Display Order Comments on Admin Invoice
Do you want to display the Order Comments on the Admin Invoice?
0= OFF
1= First Comment by Customer only
2= All Comments for the Order

Display Order Comments on Admin Packing Slip
Do you want to display the Order Comments on the Admin Packing Slip?
0= OFF
1= First Comment by Customer only
2= All Comments for the Order

Note: be sure to keep up to date on any quirks and tweaks on v1.3.8a ...
http://www.zen-cart.com/forum/showthread.php?t=81696

Very useful for those of us on V1.3.7

thanks