[Skip to main content](#vessel-content) # How to reference a custom field in the vendor table on Front end order/show.php ## - **[TheSiriusLibrary](/forum/user/48849-thesiriuslibrary "View TheSiriusLibrary's Profile")** - [![TheSiriusLibrary's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/48849-thesiriuslibrary "View TheSiriusLibrary's Profile") Topic Author - [ Offline](/forum/user/48849-thesiriuslibrary) Less More - Posts: 14 - Thank you received: 1 - - 6 years 1 month ago [\#323379](#323379) by [TheSiriusLibrary](/forum/user/48849-thesiriuslibrary "View TheSiriusLibrary's Profile") *[How to reference a custom field in the vendor table on Front end order/show.php](/forum/23-market-how-to/900677-how-to-reference-a-custom-field-in-the-vendor-table-on-front-end-order-show-php#323379 "-- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.1.1 -- Joomla version -- : 3.9.20 -- PHP version -- : 7.3.16 -- Browser(s) name and version -- : firefox 78.0.2 on macOS 10.15.5 I have a custom field I added to my vendor table that I want to access the value of that field on order/show.php so it appears on the invoice they can view and print in the My Store Account section. How do I retrieve the value of that field in order/show.php? The field is called 'abn' and I put a value in that field for a specific vendor in HikaMarket->vendors page. Thank you so much for your assistance.")* was created by *[TheSiriusLibrary](/forum/user/48849-thesiriuslibrary "View TheSiriusLibrary's Profile")* -- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.1.1 -- Joomla version -- : 3.9.20 -- PHP version -- : 7.3.16 -- Browser(s) name and version -- : firefox 78.0.2 on macOS 10.15.5 I have a custom field I added to my vendor table that I want to access the value of that field on order/show.php so it appears on the invoice they can view and print in the My Store Account section. How do I retrieve the value of that field in order/show.php? The field is called 'abn' and I put a value in that field for a specific vendor in HikaMarket->vendors page. Thank you so much for your assistance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIzLW1hcmtldC1ob3ctdG8vOTAwNjc3LWhvdy10by1yZWZlcmVuY2UtYS1jdXN0b20tZmllbGQtaW4tdGhlLXZlbmRvci10YWJsZS1vbi1mcm9udC1lbmQtb3JkZXItc2hvdy1waHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 1 month ago [\#323389](#323389) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[How to reference a custom field in the vendor table on Front end order/show.php](/forum/23-market-how-to/900677-how-to-reference-a-custom-field-in-the-vendor-table-on-front-end-order-show-php#323389 "-- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.1.1 -- Joomla version -- : 3.9.20 -- PHP version -- : 7.3.16 -- Browser(s) name and version -- : firefox 78.0.2 on macOS 10.15.5 I have a custom field I added to my vendor table that I want to access the value of that field on order/show.php so it appears on the invoice they can view and print in the My Store Account section. How do I retrieve the value of that field in order/show.php? The field is called 'abn' and I put a value in that field for a specific vendor in HikaMarket->vendors page. Thank you so much for your assistance.")* Hello, It depends where you want to display it exactly and "how". 1 - You can retrieve the current HikaMarket vendor and display the value of the field somewhere in the view (that you need to override). But it will mean that if the main vendor access the order, it won't contain the value of the other vendor. 2 - You can read the order details to read the "order_vendor_id" information and then load the corresponding vendor. Then, from the vendor object, you will have access to the value of the field you want to display. Both solution requires some PHP development. It is possible to use the HikaShop and HikaMarket classes in order to not perform SQL queries, such as the " hikamarket::get('class.vendor') " which own a "get()" function to retrieve the object of a specific vendor. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [TheSiriusLibrary](/forum/user/48849-thesiriuslibrary "View TheSiriusLibrary's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIzLW1hcmtldC1ob3ctdG8vOTAwNjc3LWhvdy10by1yZWZlcmVuY2UtYS1jdXN0b20tZmllbGQtaW4tdGhlLXZlbmRvci10YWJsZS1vbi1mcm9udC1lbmQtb3JkZXItc2hvdy1waHA/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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.186 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)