I need to generate a report of sales by customer that includes a column showing the last 4 digits of the CC number used in the sale. I can't seem to find that or even see that listed in my Orders window. Is this available somewhere?
Name Adderess ITEM Email Total Paid CC Nos
Something like that. I do not see this column as an option in reports. Is there an app or something that can do this for me?
I'm Miles from the Social Care team at Shopify. Thanks for reaching out about your reporting needs. At this stage, Shopify doesn't offer a report with the last 4 digits of a customers credit card. I understand you do have access to that information in the order timeline, so it's something I'm happy to raise with our team for consideration. So I can do this, I would need some more information from you.
In the meantime, while this feature is not an option, have you tried any apps at all? I've had a look at some of the popular apps, but the full reporting lists aren't available. I've written some suggestions below for you, and you can choose which one suits you best. In order to confirm if they offer the credit card number as a reporting feature, you'll need to reach out directly to the app developer and ask.
I look forward to hearing back from you so I can raise the request on your behalf. Thanks!
Tiia here from Better Reports support team.
Thank you for suggesting our app!
I really appreciate it!
I believe our app Better Reports may be able to help. We can create a custom report for you that lists redacted credit card numbers (last 4 digits exposed) and, customer information (i.e. full name, email, address), order#, items ordered, and amount paid. These reports can be exported directly to Excel, csv, or pdf.
In addition to building custom reports to meet your specific needs, you'll have access to 60+ built-in reports that cover many common use cases for merchants and our reports can be scheduled to send to your email or Google Drive at set frequencies.
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.
Let me know how you go and feel free to reach out if you have any further questions.