Query Shipping item discount allocations.

View-Specific Information

Select

The add-in uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server-side.

SELECT * from ShippingItemDiscountAllocations

SELECT * from ShippingItemDiscountAllocations where OrderId='1'

SELECT * from ShippingItemDiscountAllocations where OrderId IN ('1', '2')

SELECT * from ShippingItemDiscountAllocations where OrderUpdatedAt <= '2020-07-20 08:28:03.0'

SELECT * from ShippingItemDiscountAllocations where OrderUpdatedAt > '2020-07-20 08:28:03.0'

Columns

Name	Type	References	Description
LineNumber [KEY]	Long		A unique numeric identifier for the table.
ItemId	Long	ShippingItems.ItemId	The id of the shipping item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
Amount	String		The Amount of the item discount allocations.
ShopMoneyAmount	Decimal		The ShopMoneyAmount of the item discount allocations.
ShopMoneyCurrencyCode	String		The ShopMoneyCurrencyCode of the item discount allocations.
PresentmentMoneyAmount	Decimal		The PresentmentMoneyAmount of the item discount allocations.
PresentmentMoneyCurrencyCode	String		The PresentmentMoneyCurrencyCode of the item discount allocations.
DiscountApplicationIndex	Int		The Discount application index for an order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.