DiscountsAutomaticApp

Contains automatic discounts created by apps, including qualifying conditions and applied benefits.

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.

Title supports the '=, !=' comparison operators.
Status supports the '=, !=' comparison operators.
DiscountClass supports the '=, !=' comparison operators.
StartsAt supports the '=, !=, <, >, >=, <=' comparison operators.
AppDiscountTypeTitle supports the '=, !=' comparison operators.
AppDiscountTypeDiscountClass supports the '=, !=' comparison operators.

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

  SELECT * FROM DiscountsAutomaticApp WHERE Title = 'Val1'
  SELECT * FROM DiscountsAutomaticApp WHERE Status = 'Val1'
  SELECT * FROM DiscountsAutomaticApp WHERE DiscountClass = 'Val1'
  SELECT * FROM DiscountsAutomaticApp WHERE StartsAt = '2023-01-01 11:10:00'
  SELECT * FROM DiscountsAutomaticApp WHERE AppDiscountTypeTitle = 'Val1'
  SELECT * FROM DiscountsAutomaticApp WHERE AppDiscountTypeDiscountClass = 'Val1'

Insert

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

Title, AppliesOnSubscription, RecurringCycleLimit, EndsAt, StartsAt, AppDiscountTypeFunctionId, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

Update

The following columns can be updated:

Title, AppliesOnSubscription, RecurringCycleLimit, EndsAt, StartsAt, AppDiscountTypeFunctionId, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique identifier for the automatic app discount record.
DiscountId	String	True		The unique identifier of the associated discount that defines this automatic app discount configuration.
Title	String	False		The display title of the discount, as shown to merchants or customers.
Status	String	True		The current operational state of the discount, such as active, scheduled, or expired.
DiscountClass	String	True		Defines how this discount interacts with other discounts when combined, such as order-level or product-level.
AppliesOnSubscription	Bool	False		Indicates whether the discount applies to subscription-based purchases, allowing recurring discounts for subscribed items.
RecurringCycleLimit	Int	False		Specifies how many billing cycles the discount remains active for subscription orders. For instance, '3' limits the discount to the first three cycles, while '0' applies it indefinitely.
EndsAt	Datetime	False		The date and time when the discount stops being valid. Returns 'null' for open-ended or ongoing discounts.
StartsAt	Datetime	False		The date and time when the discount first becomes active.
AsyncUsageCount	Int	True		The total number of times this discount has been used, updated asynchronously and may temporarily differ from the exact usage count.
CreatedAt	Datetime	True		The date and time when this automatic app discount was initially created.
UpdatedAt	Datetime	True		The date and time when this automatic app discount was last modified.
AppDiscountTypeFunctionId	String	False		The unique identifier of the app function that defines the logic or rules for this discount type.
AppDiscountTypeTitle	String	True		The title of the app-defined discount type that determines how the discount is applied.
AppDiscountTypeDescription	String	True		A human-readable description explaining the purpose and behavior of the app discount type.
AppDiscountTypeAppKey	String	True		The unique client ID of the app responsible for providing and managing this discount type.
AppDiscountTypeDiscountClass	String	True		Specifies the classification of the app discount type for determining combination behavior with other discounts.
AppDiscountTypeTargetType	String	True		Identifies the specific target type of the discount, such as 'SHIPPING_LINE' for shipping discounts or 'LINE_ITEM' for product-level discounts.
CombinesWithOrderDiscounts	Bool	False		Indicates whether this discount can be applied in combination with other order-level discounts.
CombinesWithProductDiscounts	Bool	False		Indicates whether this discount can be applied in combination with other product-level discounts.
CombinesWithShippingDiscounts	Bool	False		Indicates whether this discount can be applied in combination with other shipping-related discounts.
ErrorHistoryFirstOccurredAt	Datetime	True		The date and time when the first recorded error occurred during the discount's operation.
ErrorHistoryErrorsFirstOccurredAt	Datetime	True		The timestamp of the earliest occurrence among recorded discount-related errors.
ErrorHistoryHasSharedRecentErrors	Bool	True		Indicates whether the merchant has shared all recent discount-related error details with the app developer.
ErrorHistoryHasBeenSharedSinceLastError	Bool	True		Indicates whether the merchant has shared error details that occurred since the most recent recorded error.