[Skip to main content](#vessel-content) # custom product fields not displaying in emails ## - **[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")** - [![MinnieMouse's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Topic Author - [ Offline](/forum/user/3535-minniemouse) Less More - Posts: 102 - Thank you received: 0 - - 15 years 3 months ago [\#23176](#23176) by [MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile") *[custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23176 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* was created by *[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")* hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")** - [![MinnieMouse's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Topic Author - [ Offline](/forum/user/3535-minniemouse) Less More - Posts: 102 - Thank you received: 0 - - 15 years 3 months ago [\#23178](#23178) by [MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Replied by *[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23178 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* i have tried simply entering the $row->MYFIELD into the cart template and it works in the cart but then is not passed to the email. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 15 years 3 months ago [\#23190](#23190) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23190 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* That information is not loaded in the notification email. Thus you first need to load it from the database: $productClass = hikashop::get('class.product'); $product = $productClass->get($row->product_id); echo $product->MYFIELD; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")** - [![MinnieMouse's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Topic Author - [ Offline](/forum/user/3535-minniemouse) Less More - Posts: 102 - Thank you received: 0 - - 15 years 3 months ago [\#23192](#23192) by [MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Replied by *[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23192 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* i suspected as much.. just wasnt sure how to go about it.. thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")** - [![MinnieMouse's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Topic Author - [ Offline](/forum/user/3535-minniemouse) Less More - Posts: 102 - Thank you received: 0 - - 15 years 3 months ago [\#23194](#23194) by [MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Replied by *[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23194 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* is there a way to retrieve the products category? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 15 years 3 months ago [\#23196](#23196) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23196 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* Everything is possible but that's more complicated. You need to do yourself the MySQL query on the table hikashop_product_category with a left join on hikashop_category in order to get the category data and then display it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")** - [![MinnieMouse's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Topic Author - [ Offline](/forum/user/3535-minniemouse) Less More - Posts: 102 - Thank you received: 0 - - 15 years 3 months ago [\#23197](#23197) by [MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile") Replied by *[MinnieMouse](/forum/user/3535-minniemouse "View MinnieMouse's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23197 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* gotcha.. can i do that query in the template or do i need to add it to one of the helper files? also the code above is not working. i added it in to the template but i dont get any result on it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 15 years 3 months ago [\#23211](#23211) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: custom product fields not displaying in emails](/forum/4-how-to/23176-custom-product-fields-not-displaying-in-emails#23211 "hi, i have the business edition. i would like my custom product table fields to display in the confirmation emails. how do i get that to happen? Liz")* You can do that directly in the template. The code is not working ? are you sure that you have something in $row->product_id ? Otherwise, that won't work... By default, it should be $item->product_id not $row->product_id but I adapted the code as apparently you had $row and not $item. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzMTc2LWN1c3RvbS1wcm9kdWN0LWZpZWxkcy1ub3QtZGlzcGxheWluZy1pbi1lbWFpbHM/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.145 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)