[Skip to main content](#vessel-content) # Inserting DB info to custom emails ## - **[jacorr27](/forum/user/626-jacorr27 "View jacorr27's Profile")** - [![jacorr27's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/626-jacorr27 "View jacorr27's Profile") Topic Author - [ Offline](/forum/user/626-jacorr27) Less More - Posts: 136 - Thank you received: 1 - - 15 years 7 months ago [\#11331](#11331) by [jacorr27](/forum/user/626-jacorr27 "View jacorr27's Profile") *[Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11331 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* was created by *[jacorr27](/forum/user/626-jacorr27 "View jacorr27's Profile")* Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. <?php echo JText::sprintf('HI_CUSTOMER',@$data->customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1<?php echo JText::sprintf('HI_CUSTOMER',@$data->customer->name); ?> </br> Test 2<?php echo $data->customer->name; ?></br> Test 3<?php echo $data->customer->user_email; ?> </br> Name: <?php echo $data->recipient_name; ?></br> Voucher #: <?php echo $data->order_id; ?><br /> And finally..... <?php /* Goals: to display both the purchaser's name and the gift recipients' name */ //$productClass = hikashop::get('class.users'); //echo JText::sprintf('HI_CUSTOMER',@$data->customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . "<br />"; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance, [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_03_19_at_6.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_03_19_at_6.png "[img") - [ ![Screen_shot_2011_03_19_at_6.png](/forum/attachment/752) ](/forum/attachment/752 "...03_19_at_6.png") [ ](/forum/attachment/752?download=1 "...03_19_at_6.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 15 years 7 months ago [\#11332](#11332) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11332 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Hi you want to display the name of the buyer then $data->customer->name should work. If you want to display the name of the recipient, it will depend on how you added the input box to ask the name of the recipient... If you created a custom order field, then you can do like this: echo $data->CUSTOM_FIELD_COLUMN_NAME; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joelstad](/forum/user/1677-joelstad "View joelstad's Profile")** - [![joelstad's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1677.png)](/forum/user/1677-joelstad "View joelstad's Profile") - [ Offline](/forum/user/1677-joelstad) Less More - Posts: 38 - Thank you received: 0 - - - - 15 years 7 months ago [\#11392](#11392) by [joelstad](/forum/user/1677-joelstad "View joelstad's Profile") Replied by *[joelstad](/forum/user/1677-joelstad "View joelstad's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11392 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Hello. I'm trying to do something very similar but I'd like the details of the user placing the order sent to the admin instead. Right now I have been able to add the e-mail address but I'd like the admin notification e-mail to also show the name and city of the user placing the order (and possibly some other details). How can this be done? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 15 years 7 months ago [\#11393](#11393) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11393 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* You can find on that post [ www.hikashop.com/en/support/forum/5-supp...e-commande.html#8788](http://www.hikashop.com/en/support/forum/5-support-en-francais-french-support-/3360-email-au-vendeur-lors-dune-commande.html#8788) the content to put in the order admin notification email if you want the admin to receive all the order details, like in the email sent to the user. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joelstad](/forum/user/1677-joelstad "View joelstad's Profile")** - [![joelstad's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1677.png)](/forum/user/1677-joelstad "View joelstad's Profile") - [ Offline](/forum/user/1677-joelstad) Less More - Posts: 38 - Thank you received: 0 - - - - 15 years 7 months ago [\#11394](#11394) by [joelstad](/forum/user/1677-joelstad "View joelstad's Profile") Replied by *[joelstad](/forum/user/1677-joelstad "View joelstad's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11394 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Blazing fast support, thanks so much! I'm a very happy user. :0) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slickgj](/forum/user/829-slickgj "View slickgj's Profile")** - [![slickgj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/829-slickgj "View slickgj's Profile") - [ Offline](/forum/user/829-slickgj) Less More - Posts: 20 - Thank you received: 0 - - 15 years 7 months ago [\#11468](#11468) by [slickgj](/forum/user/829-slickgj "View slickgj's Profile") Replied by *[slickgj](/forum/user/829-slickgj "View slickgj's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11468 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Hello Nicolas, What file do we modify to include custom DB fields for administrators. I'm having trouble finding the correct file. thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slickgj](/forum/user/829-slickgj "View slickgj's Profile")** - [![slickgj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/829-slickgj "View slickgj's Profile") - [ Offline](/forum/user/829-slickgj) Less More - Posts: 20 - Thank you received: 0 - - 15 years 7 months ago [\#11469](#11469) by [slickgj](/forum/user/829-slickgj "View slickgj's Profile") Replied by *[slickgj](/forum/user/829-slickgj "View slickgj's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11469 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Hello Nicolas, What file do we modify to include custom DB fields for administrators. I'm having trouble finding the correct file. thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 15 years 7 months ago [\#11471](#11471) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11471 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* echo $data->customer->CUSTOM_FIELD_COLUMN_NAME; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slickgj](/forum/user/829-slickgj "View slickgj's Profile")** - [![slickgj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/829-slickgj "View slickgj's Profile") - [ Offline](/forum/user/829-slickgj) Less More - Posts: 20 - Thank you received: 0 - - 15 years 7 months ago [\#11474](#11474) by [slickgj](/forum/user/829-slickgj "View slickgj's Profile") Replied by *[slickgj](/forum/user/829-slickgj "View slickgj's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11474 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* Thanks, but in what file is the format for the admin notification email located? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 15 years 7 months ago [\#11475](#11475) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Inserting DB info to custom emails](/forum/4-how-to/11331-inserting-db-info-to-custom-emails#11475 "Hi guys, I've heavily modified the Order_status_notification email to send details to the buyer. I've sent a few forum posts to you which have been incredibly helpful! I need to repeat the customer user name but am unable to get it to display again. I've tried various things as listed below. customer->name); ?> - copied the code you have in the beginning of the email. Then tried these..... Test 1customer->name); ?> Test 2customer->name; ?> Test 3customer->user_email; ?> Name: recipient_name; ?> Voucher #: order_id; ?> And finally..... customer->user); //echo $data->customer->user_id; $class = hikashop::get('class.order'); echo "This is the user_id in hikashop>order table: " . $data->order_user_id . ""; //echo $data->customer->user_id; //$class = hikashop::get('class.user'); //echo "name " .$data->customer->user; ?> How can I display the user name? I hope this is enough detail, I have also attached a screenshot of the mock up layout. I have the majority of the information now, it's just a matter of getting the user name or gift recipient to display. Thank you in advance,")* You need to go in the menu System->Emails and edit the email "order admin notification". That functionality is available in the business edition of hikashop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzExMzMxLWluc2VydGluZy1kYi1pbmZvLXRvLWN1c3RvbS1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.167 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)