notes and requests about the order

[andraspal]

I would like to know where is the data stored when a customer leaves a note about the order.
Label: COM_PHOCACART_NOTES_AND_REQUESTS_ABOUT_ORDER
The problem is I cant find it nor in phpmyadmin neither in notification emails:-(

[Jan]

Hi, it is stored in Phoca Cart Orders (phocacart_orders) table in column "comment" but there is a typo error which will be fixed in next version.

Quick fix:
administrator\components\com_phocacart\libraries\phocacart\order\order.php

line 211
FROM:

Code: Select all

$d['comment'] 				= $data['comment'];

TO:

Code: Select all

$d['comment'] 				= $data['phcomment'];

Jan

[Jan]

Hi, should be OK in version 3.1.1
https://www.phoca.cz/news/984-phoca-car ... 1-released

Jan

[andraspal]

So, I did find it in phpmyadmin and on the backend when opening an individual order in the first column of orders menu.
My question is if its possible to display this checkout comment say in an email or somewhere more visible. Or shipping note or invoice or order receipt?
Having hundreds of orders its rather difficult to see if there was a comment or not. Looking for it in phpmyadmin is hard as that only gives the order IDs.
I got many orders and just noticed in phpmadmin that I received a dozen comments:-(

[Jan]

Hi,

you can add variables to email text - to customer or other users email texts - so e.g. you will set that email to others will be sent to administrator and into text you will add following variable:

Code: Select all

{customercomment}

https://www.phoca.cz/documents/116-phoc ... or-vendors

Jan