OrderDiscountApplications
Lists discount applications that affected an order, excluding edits and refunds.
View-Specific Information
Select
The component uses the Shopify API to process WHERE clause conditions built with the following column and operators. The component processes other filters client-side within the component.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderDiscountApplications WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId [KEY] | String |
Orders.Id | A globally unique Id for the order associated with the discount application. |
| AllocationMethod | String | The method by which the discount value is applied to its entitled items. | |
| Index [KEY] | Int | The ordered index that identifies the discount application and indicates its precedence for calculations. | |
| TargetSelection | String | How the discount amount is distributed across the discounted lines. | |
| TargetType | String | Indicates whether the discount is applied to line items or shipping lines. | |
| ValueAmount | Decimal | The discount amount as a decimal value. | |
| ValueCurrencyCode | String | The ISO currency code of the discount amount. | |
| ValuePercentage | Double | The discount percentage, represented as a number between -100 (free) and 0 (no discount). | |
| AutomaticDiscountApplicationTitle | String | The title of the automatic discount application. | |
| DiscountCodeApplicationCode | String | The discount code used at the time of application. | |
| ManualDiscountApplicationTitle | String | The title of the manual discount application. | |
| ManualDiscountApplicationDescription | String | The description of the manual discount application. | |
| ScriptDiscountApplicationTitle | String | The title of the script-based discount application. |