CData Python Connector for Shopify

Build 25.0.9454

OrderItemDiscountAllocations

Breaks down how discounts are allocated to individual line items, including amounts and discount application references.

Columns

Name Type References Description
LineNumber [KEY] Long A unique numeric identifier for the record within the table.
ItemId Long

OrdersItems.ItemId

The unique identifier of the line item to which the discount allocation applies. Available only for finalized orders.
OrderId Long

Orders.Id

The unique identifier of the order that contains the discounted line item.
amount String The total discount amount applied to the line item across all discount applications, represented as a string for precision consistency.
ApplicationIndex Int Indicates the position or sequence of the discount application when multiple discounts are applied to the same item.
ShopMoneyAmount Decimal The monetary value of the discount allocation in the shop's base currency.
ShopMoneyCurrencyCode String The three-letter ISO 4217 currency code representing the shop's base currency for this discount allocation.
PresentmentMoneyAmount Decimal The monetary value of the discount allocation in the customer's presentment (display) currency.
PresentmentMoneyCurrencyCode String The three-letter ISO 4217 currency code representing the customer's presentment currency for this discount allocation.
OrderUpdatedAt Datetime The date and time when the order, including this discount allocation, was last updated.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454