RefundLineItems
Retrieves the 'RefundLineItem' resources attached to the refund.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the RefundId 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 RefundLineItems WHERE RefundId='VALUE'
Columns
| Name | Type | References | Description |
| LineItemId | String | A globally-unique ID. | |
| RefundId [KEY] | String |
Refunds.Id | A globally-unique ID. |
| LineItemName | String | The title of the product, optionally appended with the title of the variant (if applicable). | |
| LineItemTitle | String | The title of the product at time of order creation. | |
| LineItemVariantTitle | String | The title of the variant at time of order creation. | |
| LineItemQuantity | Int | The number of variant units ordered. | |
| LineItemRestockable | Bool | Whether the line item can be restocked. | |
| LineItemSku | String | The variant SKU number. | |
| LineItemTaxable | Bool | Whether the variant is taxable. | |
| LineItemVendor | String | The name of the vendor who made the variant. | |
| LineItemCurrentQuantity | Int | The line item's quantity, minus the removed quantity. | |
| LineItemMerchantEditable | Bool | Whether the line item can be edited or not. | |
| LineItemRefundableQuantity | Int | The line item's quantity, minus the removed quantity. | |
| LineItemNonFulfillableQuantity | 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. | |
| LineItemRequiresShipping | Bool | Whether physical shipping is required for the variant. | |
| LineItemUnfulfilledQuantity | Int | The number of units not yet fulfilled. | |
| LineItemImageId | String | A unique ID for the image. | |
| LineItemImageWidth | Int | The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| LineItemImageAltText | String | A word or phrase to share the nature or contents of an image. | |
| LineItemImageHeight | Int | The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| LineItemImageUrl | String | The location of the image as a URL. | |
| LineItemProductId | String | A globally-unique ID. | |
| LineItemVariantId | String | A globally-unique ID. | |
| LineItemSellingPlanSellingPlanId | String | The ID of the selling plan associated with the line item. | |
| LineItemStaffMemberId | String | A globally-unique ID.(This column is available only with a ShopifyPlus subscription) | |
| Quantity | Int | The quantity of a refunded line item. | |
| Restocked | Bool | Whether the refunded line item was restocked. Not applicable in the context of a SuggestedRefund. | |
| RestockType | String | The type of restock for the refunded line item. | |
| LocationId | String | A globally-unique ID. | |
| PriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| PriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| PriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| PriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| SubtotalSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| SubtotalSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| SubtotalSetShopMoneyAmount | Decimal | Decimal money amount. | |
| SubtotalSetShopMoneyCurrencyCode | String | Currency of the money. | |
| TotalTaxSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| TotalTaxSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| TotalTaxSetShopMoneyAmount | Decimal | Decimal money amount. | |
| TotalTaxSetShopMoneyCurrencyCode | String | Currency of the money. |