OrderNonFulfillableLineItems
Lists order line items that are not eligible for fulfillment, typically due to stockouts or fulfillment exceptions.
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.
- ResourceId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderNonFulfillableLineItems WHERE ResourceId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the non-fulfillable line item. | |
| ResourceId | String |
Orders.Id | A globally unique identifier linking the non-fulfillable item to its corresponding order resource. |
| Name | String | The product title, optionally combined with the variant title if the line item represents a specific product variant. | |
| Title | String | The product title as it appeared at the time of order creation. | |
| VariantTitle | String | The title of the variant at the time the order was created, providing historical context for the purchased item. | |
| VariantId | String | A globally unique identifier for the variant associated with this non-fulfillable item. | |
| ProductId | String | A globally unique identifier for the product to which this non-fulfillable line item belongs. | |
| SellingPlanSellingPlanId | String | The identifier of the selling plan associated with this non-fulfillable item, if part of a subscription or recurring purchase. | |
| Quantity | Int | The total number of variant units ordered for this non-fulfillable item. | |
| Restockable | Bool | Indicates whether the item can be returned to inventory (restocked) after cancellation or refund. | |
| Sku | String | The stock keeping unit (SKU) identifier for the variant. | |
| Taxable | Bool | Indicates whether this variant is subject to sales tax or value-added tax (VAT). | |
| Vendor | String | The name of the vendor or supplier who provides the variant. | |
| CurrentQuantity | Int | The current quantity of this item after accounting for cancellations or removals. | |
| MerchantEditable | Bool | Indicates whether the line item can be modified by the merchant after order creation. | |
| RefundableQuantity | Int | The portion of the ordered quantity still eligible for refund processing. | |
| RequiresShipping | Bool | Indicates whether this item requires physical shipping. | |
| UnfulfilledQuantity | Int | The number of units that have not yet been fulfilled. | |
| NonFulfillableQuantity | Int | The number of units that cannot be fulfilled, such as refunded items, digital goods, or non-shippable charges. | |
| IsGiftCard | Bool | Indicates whether this line item represents a gift card purchase. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The total price after discounts, expressed in the customer's presentment currency. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The total price after all discounts, including those from discount codes, expressed in the customer's presentment currency. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted total. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The total discounted price expressed in the shop's base currency. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The total discounted price including code-based discounts, expressed in the shop's base currency. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the discounted total. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The per-unit discounted price in the customer's presentment currency. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted unit price. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The per-unit discounted price in the shop's base currency. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the discounted unit price. | |
| ImageId | String | A unique identifier for the product image associated with this line item. | |
| ImageWidth | Int | The width of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | Descriptive text for the image, providing context for accessibility or SEO. | |
| ImageHeight | Int | The height of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | The full URL path where the product image is located. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total amount before discounts, expressed in the customer's presentment currency. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original total. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total amount before discounts, expressed in the shop's base currency. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the original total. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original per-unit price before discounts, in the customer's presentment currency. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original unit price. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original per-unit price before discounts, in the shop's base currency. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the original unit price. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount value applied to the item, expressed in the customer's presentment currency. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the total discount. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount value applied to the item, expressed in the shop's base currency. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the total discount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted amount for unfulfilled units, expressed in the customer's presentment currency. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled discounted total. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The total discounted amount for unfulfilled units, expressed in the shop's base currency. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the unfulfilled discounted total. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The original total amount for unfulfilled units before discounts, expressed in the customer's presentment currency. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled original total. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The original total amount for unfulfilled units before discounts, expressed in the shop's base currency. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the unfulfilled original total. |