Accepting credit cards, warehouses, and shipping and fulfilling orders
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?
IE:
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?
Thanks!
Hi, @DeniseVR!
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!
To learn more visit the Shopify Help Center or the Community Blog.
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.
Hey, @DeniseVR
This is Denys from Mipler: Custom Reports. It's nice to connect with you here!
I noticed an old topic that isn't been marked as solved and wanted to suggest trying out our application.
Here you can get 4 last credit card digits in the different formats:
You can explore it through the following link: Mipler: Advanced Reports
We offer a free 7-day trial, and our support team is ready to create any report you need.
Just send us a request, and we’ll provide a complete solution promptly.
Looking forward to hearing from you soon! 🙂
Discover how to increase customer engagement on your store with articles from Shopify A...
By Jacqui Apr 23, 2025Hey Community 👋 Did you know that March 15th is National Everything You Think Is W...
By JasonH Apr 1, 2025Discover how to increase the efficiency of commerce operations with Shopify Academy's l...
By Jacqui Mar 26, 2025