Page 1 of 1
notes and requests about the order
Posted: 04 Jun 2018, 13:49
by 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:-(
Re: notes and requests about the order
Posted: 06 Jun 2018, 21:36
by 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:
TO:
Code: Select all
$d['comment'] = $data['phcomment'];
Jan
Re: notes and requests about the order
Posted: 13 Aug 2018, 23:43
by Jan
Re: notes and requests about the order
Posted: 28 May 2019, 15:28
by 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:-(
Re: notes and requests about the order
Posted: 31 May 2019, 00:28
by 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:
https://www.phoca.cz/documents/116-phoc ... or-vendors
Jan