OrderLineItemDiscountAllocations
Shows how discount amounts are distributed among individual order line items.
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.
- OrderLineItemId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderLineItemDiscountAllocations WHERE OrderLineItemId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderLineItemId [KEY] | String | A globally unique identifier for the order line item to which the discount is applied. | |
| DiscountApplicationIndex [KEY] | Decimal | The position of the discount application in the calculation sequence, determining how multiple discounts are prioritized and applied. | |
| AllocatedAmountSetPresentmentMoneyAmount | Decimal | The monetary value of the discount applied to the line item in the customer's presentment currency. | |
| AllocatedAmountSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the discount amount. | |
| AllocatedAmountSetShopMoneyAmount | Decimal | The monetary value of the discount applied to the line item in the shop's base currency. | |
| AllocatedAmountSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the discount amount. |