Retrieving last 4 digits of CC payment method in a report

lydiahall
Visitor
1 0 0

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 #

Replies 2 (2)
BetterReports-K
Shopify Partner
158 6 16

Hi @lydiahall,

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.

Report-Pundit
Trailblazer
290 9 20
Hi  @lydiahall ,

This is John, from Report Pundit.

Report Pundit has the option to fetch the last 4 digits of the credit card, customer details, transaction details, order details, etc.
 
You can filter, sort the data, and export the report instantly. And You can schedule the reports to Email, Google Drive, FTP, BigQuery.

We have a free trial to see if Report Pundit fits your need. Our prices are merchant-friendly. Our support team can set up any custom report unique to your business. Report setup is always free. 
 
You can reach me at support@reportpundit.com

Thanks!!
Report Pundit - Instant reports and custom dashboards