[Skip to main content](#vessel-content) # Modify Orders Page ## - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101292](#101292) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#101292 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* was created by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 6 months ago [\#101390](#101390) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#101390 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Hi, I think that you'll be able to do that by changing the code of your "listing" file of your "order" view through "*Hikashop->Display->Views*". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101451](#101451) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#101451 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Hi, Thanks for tour reply! I understood how to add any columns.....but do you have any suggestions to how insert a sql query to collect data from other tables? because I'm able to get data only from order table. Thanks!!! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 6 months ago [\#101454](#101454) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#101454 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* You can run queries like that: <?php $db = JFactory::getDBO(); $db->setQuery('YOUR QUERY'); $data = $db->loadObjectList(); ?> The following user(s) said Thank You: [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101583](#101583) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#101583 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Perfect! Thanks!!! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 5 months ago [\#102446](#102446) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#102446 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Hi, I need last suggestion, if is possible: I have insert a sql Query into the order_listing like this: $db->setQuery('SELECT order_product_name FROM hikashop_order_product join hikashop_order on hikashop_order_product.order_id=hikashop_order.order_id and hikashop_order.order_id=????????'); but I can not correct link the table order with table order_product in a way that corresponds to each order the exact product name. If it is not too complicated…my PHP Skills are not very good! Thanks!!! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 5 months ago [\#102455](#102455) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#102455 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* you can find the order_id in the variable: $row->order_id The following user(s) said Thank You: [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 5 months ago [\#102537](#102537) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#102537 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Thanks!! it's OK Bye Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 2 months ago [\#120709](#120709) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#120709 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Hi, sorry, but I'd like to filter orders in this page so that they are displayed only in status = "completed". I always have to edit the file "listing" in view "Order"? Thanks!! Bye Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 2 months ago [\#120711](#120711) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#120711 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* Yes. You can just add the line: if($row->order_status!='confirmed') continue; after the line: $row =& $this->rows[$i]; in that order/listing view file. The following user(s) said Thank You: [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 2 months ago [\#120714](#120714) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[Modify Orders Page](/forum/2-general-talk-about-hikashop/81052-modify-orders-page#120714 "Hi, can I modify the List Orders page linked in the Cpanel user? I would like to add 2 columns: Product name and quantity products...it is possible?? Thanks Guy")* spectacular!! you were very fast and very good! It's all OK! Many many Thanks Grazie!! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMDUyLW1vZGlmeS1vcmRlcnMtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)