OrderNonFulfillableLineItems
Lists order line items that are not fulfillable and related context.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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 Id for the non-fulfillable order line item. | |
| ResourceId | String |
Orders.Id | A globally unique Id for the resource associated with the line item. |
| Name | String | The title of the product, optionally appended with the title of the variant (if applicable). | |
| Title | String | The title of the product at the time of order creation. | |
| VariantTitle | String | The title of the variant at the time of order creation. | |
| VariantId | String | A globally unique Id for the variant associated with the line item. | |
| ProductId | String | A globally unique Id for the product associated with the line item. | |
| SellingPlanSellingPlanId | String | The Id of the selling plan associated with the line item. | |
| Quantity | Int | The number of variant units ordered. | |
| Restockable | Bool | Indicates whether the line item can be restocked. | |
| Sku | String | The variant SKU number. | |
| Taxable | Bool | Indicates whether the variant is taxable. | |
| Vendor | String | The name of the vendor who made the variant. | |
| CurrentQuantity | Int | The current quantity of the line item, excluding removed units. | |
| MerchantEditable | Bool | Indicates whether the line item can be edited. | |
| RefundableQuantity | Int | The quantity of the line item that can be refunded. | |
| RequiresShipping | Bool | Indicates whether physical shipping is required for the variant. | |
| UnfulfilledQuantity | Int | The number of units not yet fulfilled. | |
| NonFulfillableQuantity | Int | The number of units that cannot be fulfilled. For example, refunded items or non-fulfillable items like tips. | |
| IsGiftCard | Bool | Indicates whether the line item represents the purchase of a gift card. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total, in presentment currency, as a decimal value. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The discounted total with code discounts applied, in presentment currency, as a decimal value. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted total. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The discounted total, in shop currency, as a decimal value. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The discounted total with code discounts applied, in shop currency, as a decimal value. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discounted total. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted unit price, in presentment currency, as a decimal value. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted unit price. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted unit price, in shop currency, as a decimal value. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discounted unit price. | |
| ImageId | String | A globally unique Id for the image. | |
| ImageWidth | Int | The original width of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | A word or phrase that describes the contents or purpose of the image. | |
| ImageHeight | Int | The original height of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | The URL location of the image. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total, in presentment currency, as a decimal value. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original total. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total, in shop currency, as a decimal value. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the original total. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original unit price, in presentment currency, as a decimal value. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original unit price. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original unit price, in shop currency, as a decimal value. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the original unit price. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount applied, in presentment currency, as a decimal value. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the total discount. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount applied, in shop currency, as a decimal value. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the total discount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled discounted total, in presentment currency, as a decimal value. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled discounted total. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The unfulfilled discounted total, in shop currency, as a decimal value. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the unfulfilled discounted total. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled original total, in presentment currency, as a decimal value. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled original total. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The unfulfilled original total, in shop currency, as a decimal value. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the unfulfilled original total. |