CData Python Connector for Shopify

Build 23.0.8839

OrderDiscountApplications

Returns a list of discounts that are applied to the order, not including order edits and refunds.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the OrderId column, which supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

For example, the following query is processed server-side:

SELECT * FROM OrderDiscountApplications WHERE OrderId='VALUE'

Columns

Name Type References Description
OrderId [KEY] String

Orders.Id

A globally-unique ID.
AllocationMethod String The method by which the discount's value is applied to its entitled items.
Index [KEY] Int An ordered index that can be used to identify the discount application and indicate the precedence of the discount application for calculations.
TargetSelection String How the discount amount is distributed on the discounted lines.
TargetType String Whether the discount is applied on line items or shipping lines.
ValueAmount Decimal The value of the discount application. Decimal money amount.
ValueCurrencyCode String The value of the discount application. Currency of the money.
ValuePercentage Double The value of the discount application. The percentage value of the object. This is a number between -100 (free) and 0 (no discount).
AutomaticDiscountApplicationTitle String The title of the discount application.
DiscountCodeApplicationCode String The string identifying the discount code that was used at the time of application.
ManualDiscountApplicationTitle String The title of the discount application.
ManualDiscountApplicationDescription String The description of the discount application.
ScriptDiscountApplicationTitle String The title of the discount application.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839