[Skip to main content](#vessel-content) # Order Name vs. Order Number (Community Plugin) ## - **[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")** - [![xsbucks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/22196-xsbucks "View xsbucks's Profile") Topic Author - [ Offline](/forum/user/22196-xsbucks) Less More - Posts: 61 - Thank you received: 2 - - 13 years 2 months ago - 13 years 2 months ago [\#121766](#121766) by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile") *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121766 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* was created by *[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")* Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks Last edit: 13 years 2 months ago by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14305 - - 13 years 2 months ago [\#121773](#121773) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121773 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* You can edit the file plugins/community/hikashop/hikashop.php and change the code: <?php echo JText::_('ORDER_NUMBER'); ?> to the text you want. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")** - [![xsbucks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/22196-xsbucks "View xsbucks's Profile") Topic Author - [ Offline](/forum/user/22196-xsbucks) Less More - Posts: 61 - Thank you received: 2 - - 13 years 2 months ago [\#121782](#121782) by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile") Replied by *[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121782 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* Thanks Nicolas for the quick reply, what i was hoping to do was to grab the name of the file from the DB instead of the Order_Number Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 13 years 2 months ago [\#121827](#121827) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121827 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* Hi, Of which name are your talking about ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")** - [![xsbucks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/22196-xsbucks "View xsbucks's Profile") Topic Author - [ Offline](/forum/user/22196-xsbucks) Less More - Posts: 61 - Thank you received: 2 - - 13 years 2 months ago [\#121835](#121835) by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile") Replied by *[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121835 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* From the hikashop_order_product table, order_product_name Do i need just an INNER join? .a and .b DB exception in the module for that? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14305 - - 13 years 2 months ago [\#121842](#121842) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121842 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* I don't think that most shop have that since it's not practical and not really nice to display all the products of each order on the order listing. I might be for simple ecommerce extensions which don't handle shopping carts and thus where you can only purchase one product at a time. If that's the case on your website (all orders have only one product), simply change: $query = 'FROM '.hikashop_table('order').' AS a WHERE '.implode(' AND ',$filters).$order; to: $query = 'FROM '.hikashop_table('order').' AS a LEFT JOIN #__hikashop_order_product AS b ON a.order_id=b.order_id WHERE '.implode(' AND ',$filters).$order; and then change : <?php echo $row->order_number; ?> to: <?php echo $row->order_product_name; ?> Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")** - [![xsbucks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/22196-xsbucks "View xsbucks's Profile") Topic Author - [ Offline](/forum/user/22196-xsbucks) Less More - Posts: 61 - Thank you received: 2 - - 13 years 2 months ago [\#121871](#121871) by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile") Replied by *[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121871 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* Thanks Nicolas, I changed the code as you mentioned... It is still not showing... I can't seem to find where it is missing, but it should be working as mentioned. <?php /** * @copyright Copyright (C) 2010-2011 HIKASHOP SARL - All rights reserved. * @license [ www.gnu.org/licenses/gpl-3.0.html](http://www.gnu.org/licenses/gpl-3.0.html) GNU/GPL */ defined('_JEXEC') or die('Restricted access'); if(!defined('DS')) define('DS', DIRECTORY_SEPARATOR); if(!@include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php')){ return; }; if(!class_exists('plgCommunityHikaShop')){ class plgCommunityHikaShop extends CApplications{ var $name = "My Orders"; var $_name = "orders"; function plgCommunityHikaShop(& $subject, $config){ parent::__construct($subject, $config); } function onProfileDisplay(){ $my = & JFactory::getUser(); $user =& CFactory::getActiveProfile(); //only you can see your orders if (empty($my->id) OR empty($user) OR $my->id != $user->id) return; //load order info $database =& JFactory::getDBO(); $searchMap = array('a.order_id','a.order_status'); $filters = array('a.order_user_id='.hikashop_loadUser()); $order = ' ORDER BY a.order_created DESC'; $query = 'FROM '.hikashop_table('order').' AS a LEFT JOIN #__hikashop_order_product AS b ON a.order_id=b.order_id WHERE '.implode(' AND ',$filters).$order; $database->setQuery('SELECT a.* '.$query); $rows = $database->loadObjectList(); if(empty($rows)){ return; } $currencyHelper = hikashop_get('class.currency'); $trans = hikashop_get('helper.translation'); $statuses = $trans->getStatusTrans(); ob_start(); ?> <table class="hikashop_orders adminlist" cellpadding="1"> <thead> <tr> <th class="title" align="center"> <?php echo JText::_('ORDER_NUMBER'); ?> </th> <th class="title" align="center"> <?php echo JText::_('DATE'); ?> </th> <th class="title" align="center"> <?php echo JText::_('ORDER_STATUS'); ?> </th> <th class="title" align="center"> <?php echo JText::_('HIKASHOP_TOTAL'); ?> </th> </tr> </thead> <tbody> <?php $k = 0; for($i = 0,$a = count($rows);$i<$a;$i++){ $row =& $rows[$i]; ?> <tr class="<?php echo "row$k"; ?>"> <td align="center"> <?php global $Itemid; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } ?> <a href="<?php echo hikashop_completeLink('order&task=show&cid='.$row->order_id.$url_itemid.'&cancel_url='.urlencode(base64_encode(JRoute::_('index.php?option=com_community&view=profile&userid='.$my->id)))); ?>"> <?php echo $row->order_product_name; ?> </a> </td> <td align="center"> <?php echo hikashop_getDate($row->order_created,'%Y-%m-%d %H:%M');?> </td> <td align="center"> <?php //get translation echo $statuses[$row->order_status]; ?> </td> <td align="center"> <?php echo $currencyHelper->format($row->order_full_price,$row->order_currency_id);?> </td> </tr> <?php $k = 1-$k; } ?> </tbody> </table> <?php return ob_get_clean(); } function onAppDisplay(){ return $this->onProfileDisplay(); } } } Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14305 - - 13 years 2 months ago [\#121908](#121908) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121908 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* Ah yes, you also need to; $database->setQuery('SELECT a.* '.$query); to: $database->setQuery('SELECT a.*,b.* '.$query); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")** - [![xsbucks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/22196-xsbucks "View xsbucks's Profile") Topic Author - [ Offline](/forum/user/22196-xsbucks) Less More - Posts: 61 - Thank you received: 2 - - 13 years 2 months ago [\#121962](#121962) by [xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile") Replied by *[xsbucks](/forum/user/22196-xsbucks "View xsbucks's Profile")* on topic *[Order Name vs. Order Number (Community Plugin)](/forum/26-product-category-display/861655-order-name-vs-order-number-community-plugin#121962 "Hey guys, wondering on the HikaShop JomSocial Plugin, if there is an easy way to change the 'Order Number' table to an 'Order Name'? It would be a lot more feasable for what i think a lot of shops have. Would look a little nicer in Jomsocial as well. Thanks")* Got it! Thanks Nicolas. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjE2NTUtb3JkZXItbmFtZS12cy1vcmRlci1udW1iZXItY29tbXVuaXR5LXBsdWdpbj90bXBsPW1hcmtkb3du) 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.074 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)