[Skip to main content](#vessel-content) # Product Purchase Records ## - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 9 months ago [\#287940](#287940) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#287940 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* was created by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* -- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) 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 - - 8 years 8 months ago [\#287942](#287942) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#287942 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hi, Yes. You can use the Orders>Reports system: [ www.hikashop.com/support/documentation/1...hop-report-form.html](https://www.hikashop.com/support/documentation/133-hikashop-report-form.html) Mass actions in the menu System>Mass actions should also allow you to do that but it's a bit more complex to use: [ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html) The following user(s) said Thank You: [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 8 months ago [\#288812](#288812) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#288812 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Thanks nicolas (sry late reply - been away) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 8 months ago [\#288876](#288876) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#288876 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hi In the Hikashop widget panel, I have "last 10 orders", it has | ref no | Customer email | Order status | Total | is there a way for me to change the email to show the customer name ? and add the purchase date ? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) 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) - 8 years 8 months ago [\#288880](#288880) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#288880 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hello, The answer would depend on the kind of report you're using. Please provide more details. A screenshot could help. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 8 months ago [\#289079](#289079) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#289079 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hi Jerome please find my screenshot attached, under the title "customer" it lists the customers email address. What I'm asking is, can I change this to show their surname or names instead of the email address ? thanks [ ![customerlist.jpg](/forum/attachment/42855) ](/forum/attachment/42855 "customerlist.jpg") - [ ![customerlist.jpg](/forum/attachment/42855) ](/forum/attachment/42855 "customerlist.jpg") [ ](/forum/attachment/42855?download=1 "customerlist.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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 - - - 8 years 8 months ago [\#289098](#289098) 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 *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#289098 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hello, There's actually no option to do that so the best solution will probably be to directly edit the "Order" file of the "Dashboard" view of your back-end template via "Hikashop->Display->Views". [ www.hikashop.com/support/documentation/1...-display.html#layout](https://www.hikashop.com/support/documentation/153-customize-the-display.html#layout) Best regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 8 months ago [\#289174](#289174) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#289174 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Thanks Mohamed sorry to ask again, I think Ive found the correct file, >Back end / dashboard / order <thead> <tr> <th class="title"> </th> <th class="title"> **<?php echo JText::\_('CUSTOMER'); ?>** </th> <th class="title"> <?php echo JText::_('ORDER_STATUS'); ?> </th> <th class="title"> <?php echo JText::_('HIKASHOP_TOTAL'); ?> </th> </tr> </thead> Can you tell me where to find the correct code I should use for customer NAME is it ('HIKA_USER') ? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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 - - - 8 years 8 months ago [\#289180](#289180) 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 *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#289180 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hello, The solution will probably be to directly change these lines : Code: if(!empty($row->username) && !empty($row->name)){ echo $row->name.' ( '.$row->username.' )</a><br/>'; } By : Code: $customer = JFactory::getUser($row->user_cms_id); if(!empty($customer->username) && !empty($customer->name)){ echo $customer->name.' ( '.$customer->username.' )</a><br/>'; } The following user(s) said Thank You: [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 8 years 8 months ago [\#289391](#289391) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records#289391 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks")* Hi Mohamed thank you for that code, appreciated Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM3OTYtcHJvZHVjdC1wdXJjaGFzZS1yZWNvcmRzP3RtcGw9bWFya2Rvd24=) 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.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)