OrderNonFulfillableLineItems
Retrieves a list of line items in the associated resource.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the ResourceId 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 OrderNonFulfillableLineItems WHERE ResourceId='VALUE'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| ResourceId | String |
Orders.Id | A globally-unique ID. |
| 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 time of order creation. | |
| VariantTitle | String | The title of the variant at time of order creation. | |
| VariantId | String | A globally-unique ID. | |
| ProductId | String | A globally-unique ID. | |
| SellingPlanSellingPlanId | String | The ID of the selling plan associated with the line item. | |
| Quantity | Int | The number of variant units ordered. | |
| Restockable | Bool | Whether the line item can be restocked. | |
| Sku | String | The variant SKU number. | |
| Taxable | Bool | Whether the variant is taxable. | |
| Vendor | String | The name of the vendor who made the variant. | |
| CurrentQuantity | Int | The line item's quantity, minus the removed quantity. | |
| MerchantEditable | Bool | Whether the line item can be edited or not. | |
| RefundableQuantity | Int | The line item's quantity, minus the removed quantity. | |
| RequiresShipping | Bool | Whether physical shipping is required for the variant. | |
| UnfulfilledQuantity | Int | The number of units not yet fulfilled. | |
| NonFulfillableQuantity | Int | The total number of units that can't be fulfilled. For example, if items have been refunded, or the item is not something that can be fulfilled, like a tip. Please see the object for more fulfillment details. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | Currency of the money. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| ImageId | String | A 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 to share the nature or contents of an image. | |
| ImageHeight | Int | The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| ImageUrl | String | The location of the image as a URL. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| OriginalTotalSetShopMoneyAmount | Decimal | Decimal money amount. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | Currency of the money. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| TotalDiscountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | Currency of the money. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | Decimal money amount. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | Currency of the money. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | Decimal money amount. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | Currency of the money. |