Best customers mass export

  • Posts: 278
  • Thank you received: 14
  • Hikashop Business
3 years 2 months ago #329418

-- HikaShop version -- : 4.4.0

Hello
I need csv export for 1000 best customers for last year. So customers with most spend.
Customers data should be name, address and total amount spent in last year.
I can do it with Reports, but there is no address and problem with 1000 lines.
I have only guest checkout, if that is importnat.

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

  • Posts: 81540
  • Thank you received: 13069
  • MODERATOR
3 years 2 months ago #329454

Hi,

I don't see any easy solution here.
You'll have to add custom code in the function "csv" of the file administrator/components/com_hikashop/classes/widget.php to load the address data for each user with an extra MySQL query or two, process the data and add it to the CSV data being processed by that function.
So it would require a skilled PHP developer to work on that. And since it's a core file, it would require redoing the modification after each update of HikaShop, or doing the modification as a plugin overriding that class, which is possible but more complex and thus pricier to implement.

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

  • Posts: 278
  • Thank you received: 14
  • Hikashop Business
3 years 2 months ago #329489

Thank you.

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

Time to create page: 0.061 seconds
Powered by Kunena Forum