Power BI Connector for Shopify

Build 25.0.9454

ShippingItemDiscountAllocations

Breaks out discount amounts allocated to shipping lines on orders.

Columns

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

ShippingItems.ItemId

The ID of the shipping line item. Only available for orders.
OrderId Long

Orders.Id

The ID of the order that the shipping item discount allocation belongs to.
Amount String The total discount amount applied to the shipping line item, represented as a string.
ShopMoneyAmount Decimal The discount amount applied to the shipping line item, represented in the shop's currency.
ShopMoneyCurrencyCode String The three-letter ISO currency code for the shop's money amount.
PresentmentMoneyAmount Decimal The discount amount applied to the shipping line item, represented in the customer's presentment currency.
PresentmentMoneyCurrencyCode String The three-letter ISO currency code for the presentment money amount.
DiscountApplicationIndex Int The index position of the discount application associated with the shipping line item.
OrderUpdatedAt Datetime The date and time (ISO 8601 format) when the order was last updated.

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