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 DiscountsCodeBxgy
  SELECT * FROM DiscountsCodeBxgy WHERE Title = 'Val1'
  SELECT * FROM DiscountsCodeBxgy WHERE DiscountClass = 'Val1'
  SELECT * FROM DiscountsCodeBxgy WHERE StartsAt = '2023-01-01 11:10:00'

Insert

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

Title, EndsAt, StartsAt, UsageLimit, AppliesOncePerCustomer, UsesPerOrderLimit, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

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

Code, DiscountOnQuantity, DiscountPercentage, ProductsToAdd, ProductsToRemove, DiscountAmountToBuy, DiscountQuantityToBuy, ProductsBuysToAdd, ProductsBuysToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove

Update

The following columns can be updated:

Title, EndsAt, StartsAt, UsageLimit, AppliesOncePerCustomer, UsesPerOrderLimit, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

The following pseudo-columns can be updated:

Code, DiscountOnQuantity, DiscountPercentage, ProductsToAdd, ProductsToRemove, DiscountAmountToBuy, DiscountQuantityToBuy, ProductsBuysToAdd, ProductsBuysToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove

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.
CodeCount	Int	True		The number of redeem codes for 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'.
StartsAt	Datetime	False		The date and time when the discount starts.
UsageLimit	Int	False		The maximum number of times that the discount can be used.
AsyncUsageCount	Int	True		The number of times that the discount has been used.
HasTimelineComment	Bool	True		Indicates whether there are any timeline comments on the discount.
AppliesOncePerCustomer	Bool	False		Whether the discount can be applied only once per customer.
UsesPerOrderLimit	Int	False		The maximum number of times that the discount can be applied to an order.
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.
CustomerGetsAppliesOnSubscription	Bool	True		Whether the discount applies on subscription items.
CustomerGetsAppliesOnOneTimePurchase	Bool	True		Whether the discount applies on regular one-time-purchase items.
DiscountCustomerAllAllCustomers	Bool	True		Whether the discount can be applied by all customers. This value is always 'true'.
TotalSalesAmount	Decimal	True		Decimal money amount.
TotalSalesCurrencyCode	String	True		Currency of the money.

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
Code	String	The code to use the discount.
DiscountOnQuantity	String	The value of the discount.
DiscountPercentage	Double	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.
DiscountAmountToBuy	String	The value of the discount.
DiscountQuantityToBuy	Double	The quantity of prerequisite items.
ProductsBuysToAdd	String	A simple, comma-separated list of products IDs to add.
ProductsBuysToRemove	String	A simple, comma-separated list of products IDs to remove.
AddAllCustomers	Bool	Whether all customers can use this discount.
CustomersToAdd	String	A simple, comma-separated list of customers IDs to add.
CustomersToRemove	String	A simple, comma-separated list of customers IDs to remove.
CustomerSegmentsToAdd	String	A simple, comma-separated list of customers IDs to add.
CustomerSegmentsToRemove	String	A simple, comma-separated list of customers IDs to remove.