[Skip to main content](#vessel-content) # Category display in order's at admin panel ## - **[reeker](/forum/user/23625-reeker "View reeker's Profile")** - [![reeker's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-13.jpg)](/forum/user/23625-reeker "View reeker's Profile") Topic Author - [ Offline](/forum/user/23625-reeker) Less More - Posts: 8 - Thank you received: 1 - - - - 13 years 3 months ago - 13 years 3 months ago [\#111982](#111982) by [reeker](/forum/user/23625-reeker "View reeker's Profile") *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#111982 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* was created by *[reeker](/forum/user/23625-reeker "View reeker's Profile")* Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work ![:(](/media/kunena/emoticons/5.png ":(") How to do it? Thanks. Last edit: 13 years 3 months ago by [reeker](/forum/user/23625-reeker "View reeker's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#112054](#112054) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112054 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Hi there, First you have to load the categories because they are not present in this form. Just add this code: Code: foreach($this->order->products as $k => $product){ $ids[]=$product->product_id; } $db = JFactory::getDBO(); $query='SELECT * FROM '.hikashop_table('product_category').' as pc LEFT JOIN '.hikashop_table('category').' as c ON c.category_id=pc.category_id WHERE product_id IN ('.implode(',',$ids).')'; $db->setQuery($query); $categories = $db->loadObjectList('product_id'); before this line: Code: foreach($this->order->products as $k => $product) { Then add these lines: Code: <td class="hikashop_order_item_category_value"><?php echo $categories[$product->product_id]->category_name;?></td> before: Code: <td class="hikashop_order_item_edit_value" style="text-align:center"> And Code: <th class="hikashop_order_item_category_title title titletoggle"><?php echo JText::_('CATEGORY'); ?></th> before: Code: <th colspan="2" class="hikashop_order_item_remove_title title"><?php echo JText::_('ACTIONS'); ?></th> The following user(s) said Thank You: [reeker](/forum/user/23625-reeker "View reeker's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[reeker](/forum/user/23625-reeker "View reeker's Profile")** - [![reeker's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-13.jpg)](/forum/user/23625-reeker "View reeker's Profile") Topic Author - [ Offline](/forum/user/23625-reeker) Less More - Posts: 8 - Thank you received: 1 - - - - 13 years 3 months ago [\#112199](#112199) by [reeker](/forum/user/23625-reeker "View reeker's Profile") Replied by *[reeker](/forum/user/23625-reeker "View reeker's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112199 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Thabk you very much ![:)](/media/kunena/emoticons/8.png ":)") Maybe you can help me with individual discount prices for every user? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) 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: 86316 - Thank you received: 14276 - - 13 years 3 months ago [\#112202](#112202) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112202 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* You can create a user group for each user via the joomla user management and then restrict each discount to each user group. Then, based on the user group of the user the discount will be selected by Hikashop automatically Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[reeker](/forum/user/23625-reeker "View reeker's Profile")** - [![reeker's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-13.jpg)](/forum/user/23625-reeker "View reeker's Profile") Topic Author - [ Offline](/forum/user/23625-reeker) Less More - Posts: 8 - Thank you received: 1 - - - - 13 years 3 months ago [\#112207](#112207) by [reeker](/forum/user/23625-reeker "View reeker's Profile") Replied by *[reeker](/forum/user/23625-reeker "View reeker's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112207 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Thanks, but now i use a free version of Hikashop ![:(](/media/kunena/emoticons/5.png ":(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#112234](#112234) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112234 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Since it's the only solution, you will understand that we can't help you anymore ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[reeker](/forum/user/23625-reeker "View reeker's Profile")** - [![reeker's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-13.jpg)](/forum/user/23625-reeker "View reeker's Profile") Topic Author - [ Offline](/forum/user/23625-reeker) Less More - Posts: 8 - Thank you received: 1 - - - - 13 years 3 months ago - 13 years 3 months ago [\#112355](#112355) by [reeker](/forum/user/23625-reeker "View reeker's Profile") Replied by *[reeker](/forum/user/23625-reeker "View reeker's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112355 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* I need help again ![:)](/media/kunena/emoticons/8.png ":)") This category display solution doesnt work at checkout page in product listing, please can you help me with that? Also, how to edit code of $amount for payment? ive made a discount system, but it does not affilate on payment amount ![:(](/media/kunena/emoticons/5.png ":(") Last edit: 13 years 3 months ago by [reeker](/forum/user/23625-reeker "View reeker's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) 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: 86316 - Thank you received: 14276 - - 13 years 3 months ago [\#112422](#112422) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112422 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* The code Xavier provided was for the order details page. So it's normal that it doesn't do anything for the checkout. You will need to do similar changes in the file "cart" of the view "checkout" of your frontend template via the menu Display->Views for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[reeker](/forum/user/23625-reeker "View reeker's Profile")** - [![reeker's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-13.jpg)](/forum/user/23625-reeker "View reeker's Profile") Topic Author - [ Offline](/forum/user/23625-reeker) Less More - Posts: 8 - Thank you received: 1 - - - - 13 years 3 months ago [\#112423](#112423) by [reeker](/forum/user/23625-reeker "View reeker's Profile") Replied by *[reeker](/forum/user/23625-reeker "View reeker's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112423 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Already applied this changes, but its just doesnt work ![:(](/media/kunena/emoticons/5.png ":(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) 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: 86316 - Thank you received: 14276 - - 13 years 3 months ago [\#112440](#112440) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Category display in order's at admin panel](/forum/4-how-to/84509-category-display-in-orders-at-admin-panel#112440 "Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work :( How to do it? Thanks.")* Can you attach the content of the cart file so that we can see the changes you made ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NTA5LWNhdGVnb3J5LWRpc3BsYXktaW4tb3JkZXJzLWF0LWFkbWluLXBhbmVsP3RtcGw9bWFya2Rvd24=) 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.155 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)