OrderNonFulfillableLineItemDuties
Shows duty charges on items that cannot be fulfilled due to restrictions or inventory issues.
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.
- LineItemId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderNonFulfillableLineItemDuties WHERE LineItemId = 'Val1'
Columns
| Name | Type | References | Description |
| LineItemId | String | A globally unique identifier for the non-fulfillable order line item associated with the duty charge. | |
| Id [KEY] | String | A globally unique identifier for the duty record applied to the non-fulfillable line item. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code representing the country where the item originated, used for customs and duty calculation. | |
| HarmonizedSystemCode | String | The harmonized system (HS) code categorizing the product for international trade and duty assessment. | |
| PricePresentmentMoneyAmount | Decimal | The total duty amount applied to the non-fulfillable line item, expressed in the customer's presentment currency. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency in which the duty amount is displayed to the customer. | |
| PriceShopMoneyAmount | Decimal | The total duty amount applied to the non-fulfillable line item, expressed in the shop's base currency. | |
| PriceShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency in which the duty amount is recorded. |