- Posts: 431
- Thank you received: 22
Best customers mass export
5 years 8 months ago #329418
by mojweb
Best customers mass export was created by mojweb
-- 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.
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.
5 years 8 months ago #329454
by nicolas
Replied by nicolas on topic Best customers mass export
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.
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.
5 years 8 months ago #329489
by mojweb
Replied by mojweb on topic Best customers mass export
Thank you.
Please Log in or Create an account to join the conversation.
Time to create page: 0.099 seconds