[Skip to main content](#vessel-content) # Custom field values in Product table in Order ## - **[acymru](/forum/user/35350-acymru "View acymru's Profile")** - [![acymru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35350-acymru "View acymru's Profile") Topic Author - [ Offline](/forum/user/35350-acymru) Less More - Posts: 4 - Thank you received: 0 - - 11 years 10 months ago [\#183744](#183744) by [acymru](/forum/user/35350-acymru "View acymru's Profile") *[Custom field values in Product table in Order](/forum/31-development/873735-custom-field-values-in-product-table-in-order#183744 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 I have a number of custom fields in the product table that I would like to also display in the backend Order>Show view and the Order>Invoice view. I've found discussions on the board, but nothing's worked so far. I'm guessing I'm missing how to jump data between tables. I've found the relevant view files and have confirmed that edits are read properly.")* was created by *[acymru](/forum/user/35350-acymru "View acymru's Profile")* -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 I have a number of custom fields in the product table that I would like to also display in the backend Order>Show view and the Order>Invoice view. I've found discussions on the board, but nothing's worked so far. I'm guessing I'm missing how to jump data between tables. I've found the relevant view files and have confirmed that edits are read properly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3MzczNS1jdXN0b20tZmllbGQtdmFsdWVzLWluLXByb2R1Y3QtdGFibGUtaW4tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 10 months ago [\#183777](#183777) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Custom field values in Product table in Order](/forum/31-development/873735-custom-field-values-in-product-table-in-order#183777 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 I have a number of custom fields in the product table that I would like to also display in the backend Order>Show view and the Order>Invoice view. I've found discussions on the board, but nothing's worked so far. I'm guessing I'm missing how to jump data between tables. I've found the relevant view files and have confirmed that edits are read properly.")* Hi, You will have to add custom code, for example in the view "order / show_products" add: Code: $cids = array(); foreach($this->order->products as $prod){ if($prod->product_id != '0') $cids[]=$prod->product_id; } $productClass = hikashop_get('class.product'); $productClass->getProducts($cids); Before: Code: foreach($this->order->products as $k => $product) { And: Code: <?php if(in_array($product->product_id,array_keys($productClass->products))){ echo $productClass->products[$product->product_id]->CUSTOMFIELD_NAME; } ?> In the desired <td> in the foreach. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3MzczNS1jdXN0b20tZmllbGQtdmFsdWVzLWluLXByb2R1Y3QtdGFibGUtaW4tb3JkZXI/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.161 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)