DiscountsAutomaticBasic
Returns a list of discounts.
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
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 updated:
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 ID. | |
Title | String | False |
The title of the discount. | |
Status | String | True |
The status of the discount. | |
Summary | String | True |
A detailed summary of the discount. | |
DiscountClass | String | True |
The class of the discount for combining purposes. | |
EndsAt | Datetime | False |
The date and time when the discount ends. For open-ended discounts, use 'null'. | |
ShortSummary | String | True |
A short summary of the discount. | |
StartsAt | Datetime | False |
The date and time when the discount starts. | |
AsyncUsageCount | Int | True |
The number of times the discount has been used. This value is updated asynchronously and can be different than the actual usage count. | |
CreatedAt | Datetime | True |
The date and time when the discount was created. | |
CombinesWithOrderDiscounts | Bool | False |
Combines with order discounts. | |
CombinesWithProductDiscounts | Bool | False |
Combines with product discounts. | |
CombinesWithShippingDiscounts | Bool | False |
Combines with shipping discounts. | |
DiscountMinimumQuantityGreaterThanOrEqualToQuantity | String | True |
The minimum quantity of items that's required for the discount to be applied. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
AppliesOnEachItem | Bool |
If true, then the discount is applied to each of the entitled items. If false, then the amount is split across all of the entitled items. |
DiscountAmount | Decimal |
The value of the discount. |
ProductsToAdd | String |
A simple, comma-separated list of products IDs to add. |
ProductsToRemove | String |
A simple, comma-separated list of products IDs to remove. |
MinimumQuantity | String |
The minimum quantity of items that's required for the discount to be applied. |
MinimumSubtotal | String |
The minimum subtotal that's required for the discount to be applied. |