Returns a list of automatic free shipping discounts.

Table-Specific Information

Select

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

• Title supports the '=, !=' comparison operators.
• Status supports the '=, !=' comparison operators.
• DiscountClass supports the '=, !=' comparison operators.
• EndsAt supports the '=, !=, <, >, >=, <=' comparison operators.
• StartsAt supports the '=, !=, <, >, >=, <=' comparison operators.
• AsyncUsageCount supports the '=, !=, <, >, >=, <=' comparison operators.
• CreatedAt supports the '=, <, >, >=, <=' comparison operators.
• UpdatedAt supports the '=, <, >, >=, <=' comparison operators.

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

  SELECT * FROM DiscountsAutomaticFreeShipping WHERE Title = 'Val1'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE Status = 'Val1'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE DiscountClass = 'Val1'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE EndsAt = '2023-01-01 11:10:00'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE StartsAt = '2023-01-01 11:10:00'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE AsyncUsageCount = 123
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM DiscountsAutomaticFreeShipping WHERE UpdatedAt = '2023-01-01 11:10:00'

Insert

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

Title, EndsAt, StartsAt, AppliesOnSubscription, AppliesOnOneTimePurchase, RecurringCycleLimit, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, DiscountCountriesCountries, DiscountCountriesIncludeRestOfWorld, DiscountCountryAllAllCountries, MaximumShippingPriceAmount, DiscountMinimumQuantityGreaterThanOrEqualToQuantity, DiscountMinimumSubtotalGreaterThanOrEqualToSubtotalAmount

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

CountriesToAdd, CountriesToRemove

Update

The following columns can be updated:

Title, EndsAt, StartsAt, AppliesOnSubscription, AppliesOnOneTimePurchase, RecurringCycleLimit, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, DiscountCountriesCountries, DiscountCountriesIncludeRestOfWorld, DiscountCountryAllAllCountries, MaximumShippingPriceAmount, DiscountMinimumQuantityGreaterThanOrEqualToQuantity, DiscountMinimumSubtotalGreaterThanOrEqualToSubtotalAmount

The following pseudo-columns can be used to update a record:

CountriesToAdd, CountriesToRemove

Delete

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		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.
EndsAt	Datetime	False		The date and time when the discount ends. For open-ended discounts, use null.
StartsAt	Datetime	False		The date and time when the discount starts.
AsyncUsageCount	Int	True		The number of times the discount has been used.
AppliesOnSubscription	Bool	False		Whether the discount applies on subscription shipping lines.
AppliesOnOneTimePurchase	Bool	False		Whether the discount applies on regular one-time-purchase shipping lines.
CreatedAt	Datetime	True		The date and time when the discount was created.
UpdatedAt	Datetime	True		The date and time when the discount was updated.
HasTimelineComment	Bool	True		Whether there are timeline comments associated with the discount.
RecurringCycleLimit	Int	False		The number of times a discount applies on recurring purchases (subscriptions).
ShortSummary	String	True		A short summary of the discount.
CombinesWithOrderDiscounts	Bool	False		Combines with order discounts.
CombinesWithProductDiscounts	Bool	False		Combines with product discounts.
CombinesWithShippingDiscounts	Bool	True		Combines with shipping discounts.
DiscountCountriesCountries	String	False		The codes for the countries where the discount can be applied.
DiscountCountriesIncludeRestOfWorld	Bool	False		Whether the discount is applicable to countries not defined in the shop's shipping zones.
DiscountCountryAllAllCountries	Bool	False		Whether the discount can be applied to all countries as shipping destination.
MaximumShippingPriceAmount	Decimal	False		Decimal money amount.
MaximumShippingPriceCurrencyCode	String	True		Currency of the money.
DiscountMinimumQuantityGreaterThanOrEqualToQuantity	String	False		The minimum quantity of items that's required for the discount to be applied.
DiscountMinimumSubtotalGreaterThanOrEqualToSubtotalAmount	Decimal	False		The minimum subtotal that's required for the discount to be applied.
DiscountMinimumSubtotalGreaterThanOrEqualToSubtotalCurrencyCode	String	True		The three-letter currency code that represents a world currency used in a store.
TotalSalesAmount	Decimal	True		Decimal money amount.
TotalSalesCurrencyCode	String	True		Currency of the money.

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
CountriesToAdd	String	A simple, comma-separated list of countries to add.
CountriesToRemove	String	A simple, comma-separated list of countries to remove.