How to export bulk customer data with first and last order dates?

Rogic
Visitor
2 0 1

team, we tried to export bulk customer data and int hat csv file we required 1st order date and last order date of customer but could not find it? please provide the guide for same

Replies 3 (3)

CloudlabSam
Shopify Partner
556 46 92

Hi There,

 

I don't believe that Shopify makes this data available to be exported on any of their reports. I believe you can get the last order number, but not the first.

 

Our Report Toaster app can help. You can use our standard customer report and add the First and Last order date and then export that list to CSV. Please feel free to have. look and let us know if you need any help.

 

Thanks,

Sam

SupportDC
Shopify Partner
43 2 7

Hi @Rogic 

As Sam already mentioned, you will probably need a third-party app to solve this problem! Our App DataChamp is also capable to visible this information in your reports. You can use one of our templates or just create your own custom report and let it run automatically! Our App is very easy to set up but if you require any support, we can assist you of course!

Hopefully we could help you with your concern and if you have any further questions, do not hesitate to contact us!

BetterReports-K
Shopify Partner
176 6 16

Hi @Rogic,

 

Keanna here from the Better Reports support team. I would recommend our app Better Reports for this! 

 

We can create a custom customers report including first order date, last order date, total orders, total spend etc. This can be exported to CSV. 

 

In addition to custom reporting capabilities, Better Reports offers more than 80 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

 

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.