Gift Card Transaction Mapping

Hi,

I’m working on a reporting function for a client to map all of the transactions recorded against orders in their external system with all of the gcift card transactions in Shopify in a given time frame. Initially, I started by tracking orders and getting the gift card ID from the receiptJson field. This method doesn’t let me capture the creation event of the gift card, only getting a list of gift cards that have been transacted on, furthermore, it is incredibly inefficient as gift cards are only used on a small fraction of orders.

I then attempted to go the other way, get all of the gift cards, and their transactions via the newly added GiftCardTransaction connection, however since this type doesn’t have a connection to orders and doesn’t show up in tenderTransactions - GraphQL Admin since to my understanding, gift card transactions aren’t counted as having a financial impact on a shop's balance since the credit is applied to the shops balance on the purchase of the gift card, not when it’s spent.

Technically I can combine these methods by using the orders to get all of the gift card Debits/Refund Credits and use the gift cards filtered by created at to get the orders where they are purchased, even if they are not otherwise transacted on in the timeframe but this seems like a lot of queries and mess where there could be a connection from GiftCardTransaction to orders, or a way to query on transactions outside the scope of tenderTransactions (although from my understanding, that would effectively equate to being the same thing).

Please let me know if I’m missing something!

Thanks

quick note, looks like the description on this page is incorrect:

Represents information about the metafields associated to the specified resource.

1 Like

Did you find an answer? It think we’re going down the same rabbit hole.

Unfortunatly not… Just lots of inefficient queries.

We hope to have this feature in soon: New Graphql Gift Card Transaction connection to Order Transaction? - #2 by teddyhwang