DiscountsAutomaticBasic
Stores basic automatic discount rules applied at checkout without the use of discount codes.
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.
- DiscountClass supports the '=, !=' comparison operators.
- StartsAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM DiscountsAutomaticBasic WHERE Title = 'Val1'
SELECT * FROM DiscountsAutomaticBasic WHERE DiscountClass = 'Val1'
SELECT * FROM DiscountsAutomaticBasic WHERE StartsAt = '2023-01-01 11:10:00'
Insert
The following columns can be used to create a new record:
Title, EndsAt, StartsAt, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts
The following pseudo-columns can be used to create a new record:
AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, MinimumQuantity, MinimumSubtotal
Update
The following columns can be updated:
Title, EndsAt, StartsAt, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts
The following pseudo-columns can be used to update a record:
AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally unique identifier for the automatic basic discount record. | |
| Title | String | False |
The display title of the discount, as shown to merchants or customers. | |
| Status | String | True |
The current operational status of the discount, such as active, scheduled, or expired. | |
| Summary | String | True |
A detailed description summarizing the terms, conditions, and effects of the discount. | |
| DiscountClass | String | True |
Defines how this discount interacts with other discounts when applied together, such as whether it is order-level, product-level, or shipping-level. | |
| EndsAt | Datetime | False |
The date and time when the discount expires. Returns 'null' if the discount is open-ended or ongoing. | |
| ShortSummary | String | True |
A brief summary of the discount, typically used for display in lists or summaries. | |
| StartsAt | Datetime | False |
The date and time when the discount becomes active. | |
| AsyncUsageCount | Int | True |
The total number of times this discount has been used, updated asynchronously and potentially differing from the real-time count. | |
| CreatedAt | Datetime | True |
The date and time when this automatic basic discount was created. | |
| CombinesWithOrderDiscounts | Bool | False |
Indicates whether this discount can be combined with other order-level discounts. | |
| CombinesWithProductDiscounts | Bool | False |
Indicates whether this discount can be combined with other product-level discounts. | |
| CombinesWithShippingDiscounts | Bool | False |
Indicates whether this discount can be combined with other shipping-related discounts. | |
| DiscountMinimumQuantityGreaterThanOrEqualToQuantity | String | True |
Specifies the minimum number of items that must be purchased for the discount to be applied. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description |
| AppliesOnEachItem | Bool |
If true, the discount value is applied individually to each eligible item. If false, the total discount amount is distributed evenly across all eligible items. |
| DiscountAmount | Decimal |
The monetary value or percentage amount of the discount applied to the eligible items or order. |
| ProductsToAdd | String |
A comma-separated list of product IDs to which the discount will be newly applied. |
| ProductsToRemove | String |
A comma-separated list of product IDs from which the discount will be removed. |
| MinimumQuantity | String |
Specifies the minimum number of items required in the cart for the discount to activate. |
| MinimumSubtotal | String |
Specifies the minimum subtotal value required in the order for the discount to be applied. |