Product Purchase Records

  • Posts: 161
  • Thank you received: 4
6 years 1 month ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
6 years 1 month ago #287942

Hi,

Yes. You can use the Orders>Reports system:
www.hikashop.com/support/documentation/1...hop-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

The following user(s) said Thank You: phiddius

Please Log in or Create an account to join the conversation.

  • Posts: 161
  • Thank you received: 4
6 years 1 month ago #288812

Thanks nicolas
(sry late reply - been away)

Please Log in or Create an account to join the conversation.

  • Posts: 161
  • Thank you received: 4
6 years 3 weeks ago #288876

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 or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 3 weeks ago #288880

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 161
  • Thank you received: 4
6 years 3 weeks ago #289079

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
6 years 3 weeks ago #289098

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

Best regards,
Mohamed Thelji.

Please Log in or Create an account to join the conversation.

  • Posts: 161
  • Thank you received: 4
6 years 3 weeks ago #289174

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 or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
6 years 3 weeks ago #289180

Hello,

The solution will probably be to directly change these lines :

	 if(!empty($row->username) && !empty($row->name)){
	 	echo $row->name.' ( '.$row->username.' )</a><br/>';
	 }
By :
	$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

Please Log in or Create an account to join the conversation.

  • Posts: 161
  • Thank you received: 4
6 years 2 weeks ago #289391

Hi Mohamed
thank you for that code, appreciated

Please Log in or Create an account to join the conversation.

Time to create page: 0.094 seconds
Powered by Kunena Forum