FulfillmentLineItems
Lists line items included within fulfillment records, including quantities, SKUs, and location data.
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.
- FulfillmentId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM FulfillmentLineItems WHERE FulfillmentId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the fulfillment line item record. | |
| FulfillmentId | String |
Fulfillments.Id | The unique identifier of the fulfillment associated with this line item. |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total amount in the customer's presentment currency. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the customer's presentment currency. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The discounted total amount in the shop's base currency. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total amount before discounts in the customer's presentment currency. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the customer's presentment currency used in the original total. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total amount before discounts in the shop's base currency. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the original total. | |
| Quantity | Int | The total number of item units included in this fulfillment line. | |
| LineItemId | String | The globally unique identifier for the related order line item. | |
| LineItemName | String | The display name of the product, optionally including its variant title. | |
| LineItemTitle | String | The product title as recorded at the time the order was created. | |
| LineItemVariantTitle | String | The variant title as recorded at the time the order was created. | |
| LineItemVariantId | String | The globally unique identifier for the product variant associated with this line item. | |
| LineItemProductId | String | The globally unique identifier for the product linked to this line item. | |
| LineItemSellingPlanSellingPlanId | String | The identifier of the selling plan that applies to this product or variant. | |
| LineItemQuantity | Int | The number of units of the variant that were ordered. | |
| LineItemRestockable | Bool | Indicates whether this line item can be restocked when returned or canceled. | |
| LineItemSku | String | The SKU (stock keeping unit) assigned to the product variant. | |
| LineItemTaxable | Bool | Specifies whether this line item is subject to tax. | |
| LineItemVendor | String | The name of the vendor or brand associated with the product variant. | |
| LineItemCurrentQuantity | Int | The remaining quantity of the item after any removals or adjustments. | |
| LineItemMerchantEditable | Bool | Indicates whether this line item can be modified by the merchant. | |
| LineItemRefundableQuantity | Int | The quantity of items eligible for refund after previous returns or removals. | |
| LineItemRequiresShipping | Bool | Specifies whether the item requires physical shipment. | |
| LineItemUnfulfilledQuantity | Int | The number of units from this line item that have not yet been fulfilled. | |
| LineItemNonFulfillableQuantity | Int | The total number of units that cannot be fulfilled, such as refunded or non-physical items like tips. | |
| LineItemIsGiftCard | Bool | Indicates whether the line item represents a gift card purchase. | |
| LineItemDiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted amount for this line item in the customer's presentment currency. | |
| LineItemDiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The total discounted amount including any discount codes in the presentment currency. | |
| LineItemDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted total. | |
| LineItemDiscountedTotalSetShopMoneyAmount | Decimal | The total discounted amount for this line item in the shop's base currency. | |
| LineItemDiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The total discounted amount including any discount codes in the shop's base currency. | |
| LineItemDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the discounted total. | |
| LineItemDiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted per-unit price in the customer's presentment currency. | |
| LineItemDiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted unit price. | |
| LineItemDiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted per-unit price in the shop's base currency. | |
| LineItemDiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the discounted unit price. | |
| LineItemImageId | String | The unique identifier for the image associated with this product variant. | |
| LineItemImageWidth | Int | The width of the image in pixels, or null if the image is externally hosted. | |
| LineItemImageAltText | String | The alternative text describing the image content for accessibility or SEO purposes. | |
| LineItemImageHeight | Int | The height of the image in pixels, or null if the image is externally hosted. | |
| LineItemImageUrl | String | The direct URL location of the product or variant image. | |
| LineItemOriginalTotalSetPresentmentMoneyAmount | Decimal | The original total amount for this line item in the customer's presentment currency. | |
| LineItemOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the original total. | |
| LineItemOriginalTotalSetShopMoneyAmount | Decimal | The original total amount for this line item in the shop's base currency. | |
| LineItemOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the original total. | |
| LineItemOriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original per-unit price in the customer's presentment currency before any discounts. | |
| LineItemOriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original unit price. | |
| LineItemOriginalUnitPriceSetShopMoneyAmount | Decimal | The original per-unit price in the shop's base currency before any discounts. | |
| LineItemOriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency of the original unit price. | |
| LineItemTotalDiscountSetPresentmentMoneyAmount | Decimal | The total amount discounted from the line item in the customer's presentment currency. | |
| LineItemTotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the total discount. | |
| LineItemTotalDiscountSetShopMoneyAmount | Decimal | The total amount discounted from the line item in the shop's base currency. | |
| LineItemTotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency of the total discount. | |
| LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total value of all unfulfilled units in the customer's presentment currency. | |
| LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled discounted total. | |
| LineItemUnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The discounted total value of all unfulfilled units in the shop's base currency. | |
| LineItemUnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the unfulfilled discounted total. | |
| LineItemUnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The original total value of unfulfilled units in the customer's presentment currency. | |
| LineItemUnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled original total. | |
| LineItemUnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The original total value of unfulfilled units in the shop's base currency. | |
| LineItemUnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the unfulfilled original total. |