OrderAdditionalFees
Lists additional fees applied to an order, such as environmental surcharges or custom service fees.
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.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderAdditionalFees WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the additional fee record. | |
| OrderId | String |
Orders.Id | The unique identifier of the order associated with this additional fee. |
| Name | String | The descriptive name of the additional fee, such as a handling charge, customization fee, or service cost. | |
| PricePresentmentMoneyAmount | Decimal | The fee amount presented to the customer, expressed as a decimal value in the presentment currency. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency used for displaying the fee to the customer. | |
| PriceShopMoneyAmount | Decimal | The fee amount expressed as a decimal value in the shop's base currency. | |
| PriceShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for accounting and reporting purposes. |