[Skip to main content](#vessel-content) # Best customers mass export ## - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 5 years 8 months ago [\#329418](#329418) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") *[Best customers mass export](/forum/36-reports-statistics/901896-best-customers-mass-export#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.")* was created by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDE4OTYtYmVzdC1jdXN0b21lcnMtbWFzcy1leHBvcnQ/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 5 years 8 months ago [\#329454](#329454) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Best customers mass export](/forum/36-reports-statistics/901896-best-customers-mass-export#329454 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDE4OTYtYmVzdC1jdXN0b21lcnMtbWFzcy1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 5 years 8 months ago [\#329489](#329489) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Best customers mass export](/forum/36-reports-statistics/901896-best-customers-mass-export#329489 "-- 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.")* Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDE4OTYtYmVzdC1jdXN0b21lcnMtbWFzcy1leHBvcnQ/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.122 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)