How can I split customer name into two columns in the order export?

How can I split customer name into two columns in the order export?

Michael-orsted
Visitor
1 0 0

Hey.
My store has two fields in the checkout form for costumer name.

Firstname

and

Lastname.

Although. When the orders export. Firstname AND lastname are in the same coloumn [shippingfullname]?

I would like it to be divided into two seperate coloumns. Like => [shippingfirstname] & [shippinglastname]

 

Could anyone point me in the direction of where to change the default order export coloum setup?

 

Cheers

Replies 3 (3)

CloudlabGeorge
Excursionist
18 2 8

Yes, you can do this with our third-party app, Report Toaster: 

CloudlabGeorge_0-1639682819181.png

 

This is just spoofed data but you get the idea. Essentially you can add whatever columns you want, adjust the filters, change the date range and all sorts.

You can check out the app over in our listing here: https://apps.shopify.com/report-toaster For Basic and regular Shopify customers, there is also a free plan available.  

Hopefully that works for you 🙂


LuisaAlexandri
Tourist
9 0 3

Nice sir , its amazing! You explain very well about the problem ,where to change the default order export column setup. It is very helpful for me . Thanks a lot! Sir.

BetterReports-C
Shopify Partner
99 0 7

Hi @Michael-orsted 

 

Claudia here from Better Reports.

 

I would recommend our app Better Reports for this.

 

We have built-in fields allowing you to choose either the shipping full name or the separated shipping first name and shipping last name. The same fields are available for the billing name and the customer registered name.

 

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use-cases for merchants. 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.

 

What do you think?

Support Specialist at Better Reports.
Why not start your 14-day free trial here.
More questions? Feel free to reach out directly at hello@betterreports.com.