Gift Card reports by month -- only for specific subset of gift cards

Marc_Schroth
Shopify Partner
13 0 8

We are preparing to launch gift cards in our store. To begin with, we'll be generating a batch of gift cards using the REST Admin API to send to one of our partner companies for them to give to their customers. We'll also be selling gift cards through our storefront.

The reports available in Shopify let us look at total amounts redeemed broken down by day. We'd like to be able to do the same thing, but to limit the reports ONLY to this initial batch of gift cards we'll be generating through the API, and not include cards purchased through the storefront or other cards generated through the API at a later date.

Looking for guidance on any way we can make this happen. If necessary, we can maintain a list of the gift card IDs from the batch we generate so that we know which gift cards to include data from. I've been able to find an endpoint that shows the current and initial balances for each gift card (GET/admin/api/2020-10/gift_cards/{gift_card_id}.json), but not one that shows the purchase/refund histories. 

Appreciate any help you're able to provide!

Replies 2 (2)

Marc_Schroth
Shopify Partner
13 0 8

Still looking for an answer on this. I contacted Shopify Plus Support initially for this question and was told this forum is monitored by the API devs who'd be able to help me?

KBetterReports
Shopify Partner
69 0 25

Hi Marc,

Kritesh here from Better Reports team.

I believe our app Better Reports may be able to help. We can use your generated list of Gift Card IDs to create an identifier that can help track the usage of these gift cards specifically. In fact, if there are multiple such batches, we can create an identifier for each batch as well.

What do you think? Would that work for you?

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.

Disclaimer: I am part of Better Reports team.