OrderDiscountApplications

Returns a list of discounts that are applied to the order, not including order edits and refunds.

View-Specific Information

The connector uses the Shopify API to process WHERE clause conditions built with the OrderId column, which supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

For example, the following query is processed server-side:

SELECT * FROM OrderDiscountApplications WHERE OrderId='VALUE'


Name	Type	References	Description
OrderId [KEY]	String	Orders.Id	A globally-unique ID.
AllocationMethod	String		The method by which the discount's value is applied to its entitled items.
Index [KEY]	Int		An ordered index that can be used to identify the discount application and indicate the precedence of the discount application for calculations.
TargetSelection	String		How the discount amount is distributed on the discounted lines.
TargetType	String		Whether the discount is applied on line items or shipping lines.
ValueAmount	Decimal		The value of the discount application. Decimal money amount.
ValueCurrencyCode	String		The value of the discount application. Currency of the money.
ValuePercentage	Double		The value of the discount application. The percentage value of the object. This is a number between -100 (free) and 0 (no discount).
AutomaticDiscountApplicationTitle	String		The title of the discount application.
DiscountCodeApplicationCode	String		The string identifying the discount code that was used at the time of application.
ManualDiscountApplicationTitle	String		The title of the discount application.
ManualDiscountApplicationDescription	String		The description of the discount application.
ScriptDiscountApplicationTitle	String		The title of the discount application.