OrderDiscountApplications
Shows all discounts applied to an order, excluding refunds and order edits, including type and allocation data.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- 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 | The unique identifier of the order associated with this discount application. |
| AllocationMethod | String | Specifies how the discount value is allocated across the eligible items or lines, such as by item or across the entire order. | |
| Index [KEY] | Int | A numerical index representing the order in which this discount application was applied, used to determine precedence in discount calculations. | |
| TargetSelection | String | Indicates how the discount amount is distributed among the applicable items or lines, such as all eligible items or the most expensive item. | |
| TargetType | String | Specifies whether the discount applies to product line items, shipping lines, or other components of the order. | |
| ValueAmount | Decimal | The total monetary value of the discount, expressed as a decimal amount in the applicable currency. | |
| ValueCurrencyCode | String | The ISO 4217 currency code representing the currency in which the discount amount is expressed. | |
| ValuePercentage | Double | The discount value represented as a percentage, where -100 corresponds to a full discount and 0 indicates no discount. | |
| AutomaticDiscountApplicationTitle | String | The display title of the automatic discount that was applied to the order. | |
| DiscountCodeApplicationCode | String | The discount code entered by the customer and applied to the order at checkout. | |
| ManualDiscountApplicationTitle | String | The display title of a manually created discount applied to the order. | |
| ManualDiscountApplicationDescription | String | A brief description of the manually applied discount, providing context or details about its purpose. | |
| ScriptDiscountApplicationTitle | String | The display title of a discount generated by a Shopify Script, typically used in custom discount logic or automation. |