GiftCardTransactionsDebit
Logs debit transactions that reduce gift card balances, such as redemptions or refunds. Available only for Shopify Plus.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=, IN' comparison operators.
- GiftCardId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM GiftCardTransactionsDebit WHERE Id = 'Val1'
SELECT * FROM GiftCardTransactionsDebit WHERE GiftCardId = 'Val1'
Insert
The following columns can be used to create a new record:
GiftCardId, Note, ProcessedAt, Amount, AmountCurrencyCode
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally unique identifier for the gift card debit transaction record. | |
| GiftCardId | String | True |
GiftCards.Id |
The unique identifier of the gift card from which this debit transaction was made. |
| Note | String | True |
An internal note describing the reason or context for the debit transaction, visible only to store staff. | |
| ProcessedAt | Datetime | True |
The date and time when the debit transaction was processed and deducted from the gift card balance. | |
| Amount | Decimal | True |
The amount deducted from the gift card balance, represented as a decimal monetary value. | |
| AmountCurrencyCode | String | True |
The ISO currency code representing the currency of the debited amount. |