[Skip to main content](#vessel-content) # Edit the report to show PRODUCT CODE rather than name ## - **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")** - [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile") Topic Author - [ Offline](/forum/user/11107-byoguru) Less More - Posts: 99 - Thank you received: 5 - - 9 years 4 months ago - 9 years 4 months ago [\#273102](#273102) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273102 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* was created by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you Last edit: 9 years 4 months ago by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile"). Reason: corrected typo - sorry! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 9 years 4 months ago [\#273107](#273107) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273107 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hello, I'm sorry but I don't understand your question. Can you please clarify ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")** - [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile") Topic Author - [ Offline](/forum/user/11107-byoguru) Less More - Posts: 99 - Thank you received: 5 - - 9 years 4 months ago [\#273137](#273137) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273137 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hello Jerome, Sorry about that! In the admin section were the Reports are created I can make a report that provides a table with: Product Name, ORDERS, etc., But I cannot find a method of showing the Product CODE instead of the name of the product. Sorry for the mistyping! -T Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 9 years 4 months ago [\#273139](#273139) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273139 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hello, I'm sorry but there is still not enough information. What is that report ; what is the report settings ? Please provide a really precise context and details to allow us to understand what you're talking about **exactly**. Thank you for your understanding. --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")** - [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile") Topic Author - [ Offline](/forum/user/11107-byoguru) Less More - Posts: 99 - Thank you received: 5 - - 9 years 4 months ago [\#273252](#273252) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273252 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Okay. In this Administration page URL: administrator/index.php?option=com_hikashop&ctrl=report where the ADMIN makes reports in Hikashop. Make a new REPORT with the following: DISPLAY Type = LISTING + FILTERS = ALL STATUSES The report will provide a list that displays the following columns: **Products name Orders Total** I would like to replace the column titled Products name with Product CODE Is there a method for doing this? If not could you please let me know which file I would need to edit? [ ![Voila_Capture2017-07-03_01-38-33_PM.png](/forum/attachment/39035) ](/forum/attachment/39035 "...1-38-33_PM.png") - [ ![Voila_Capture2017-07-03_01-38-33_PM.png](/forum/attachment/39035) ](/forum/attachment/39035 "...1-38-33_PM.png") [ ](/forum/attachment/39035?download=1 "...1-38-33_PM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) 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: 86555 - Thank you received: 14304 - - 9 years 4 months ago [\#273299](#273299) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273299 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hi, You'll have to edit the file administrator/components/com_hikashop/classes/widget.php I think that it's these lines: Code: $widget->exportFields=array('order_product_name', 'Total'); }else{ $widget->exportFields=array('order_product_name', 'quantity'); where you want to change order_product_name by order_product_code Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")** - [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile") Topic Author - [ Offline](/forum/user/11107-byoguru) Less More - Posts: 99 - Thank you received: 5 - - 9 years 4 months ago [\#273336](#273336) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273336 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hello Nicolas, Thank you for this - it works when EXPORTING the report . Whereas in the admin panel nothing changes, it displays the same data as in the image sent previously. Will see if the client is willing to work with this solution. Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) 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: 86555 - Thank you received: 14304 - - 9 years 4 months ago [\#273355](#273355) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273355 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Hi, For the admin panel, you want to edit the file 'product' of the view "dashboard" via the menu Display>Views and change the line: echo @$row->order_product_name; to: echo @$row->order_product_code; The following user(s) said Thank You: [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")** - [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile") Topic Author - [ Offline](/forum/user/11107-byoguru) Less More - Posts: 99 - Thank you received: 5 - - 9 years 4 months ago [\#273409](#273409) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile") Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Edit the report to show PRODUCT CODE rather than name](/forum/36-reports-statistics/890960-edit-the-report-to-show-product-code-rather-than-name#273409 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome 59 Hello, Where can I change the reporting to display product_code rather than product_NAME in the dashboard reports. Thank you")* Thank you Nicolas. Best Tony Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTA5NjAtZWRpdC10aGUtcmVwb3J0LXRvLXNob3ctcHJvZHVjdC1jb2RlLXJhdGhlci10aGFuLW5hbWU/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.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)