a way to retrieve this information (last 4 digits) via our API (without having to go into each individual order) and add to a report or create a custom report which includes
customer name, order #, total transaction amount and last 4 of card #
Keanna here from the Better Reports support team.
I would recommend our app Better Reports for this!
We can create a custom report that shows the customer name, order number, transaction amount and credit card number for each order. This can be filtered for a date range, channel, payment gateway or more, depending on your report requirements.
Better Reports offers custom reporting capabilities and more than 60 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. Our reports can even be scheduled to send at a set frequency to your email or Google Drive!
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.