GiftCards

Returns a list of gift cards. Requires read_gift_cards access scope. Also, note that the API client must be a private or custom application installed on a Shopify Plus or Shopify Plus Partner Sandbox store. (This table is available only with a ShopifyPlus subscription)

Table-Specific Information

Note: Access to the GiftCards table is restricted to Shopify accounts with Shopify Plus membership. If your account does not include this tier, the table may return an empty result set or indicate that the resource is unavailable.

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

Id supports the '=, IN' comparison operators.
ExpiresOn supports the '=, !=, <, >, >=, <=' comparison operators.
CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
InitialValueAmount supports the '=, !=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM GiftCards WHERE Id = 'Val1'
  SELECT * FROM GiftCards WHERE ExpiresOn = '2023-01-01'
  SELECT * FROM GiftCards WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM GiftCards WHERE InitialValueAmount = '100.00'

Insert

The following columns can be used to create a new record:

Note, ExpiresOn, InitialValueAmount, CustomerId, RecipientAttributesRecipientId, RecipientAttributesPreferredName, RecipientAttributesMessage, RecipientAttributesSendNotificationAt

Update

The following columns can be updated:

Note, ExpiresOn, CustomerId, RecipientAttributesRecipientId, RecipientAttributesPreferredName, RecipientAttributesMessage, RecipientAttributesSendNotificationAt, Enabled

Columns