RefundLineItems
Lists refund line item records that specify quantities and amounts refunded.
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.
- RefundId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM RefundLineItems WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id of the refund line item. | |
| LineItemId | String | A globally unique Id of the associated line item. | |
| RefundId | String |
Refunds.Id | A globally unique Id of the associated refund. |
| LineItemName | String | The title of the product, optionally appended with the variant title if applicable. | |
| LineItemTitle | String | The title of the product at the time of order creation. | |
| LineItemVariantTitle | String | The title of the variant at the time of order creation. | |
| LineItemQuantity | Int | The number of variant units ordered. | |
| LineItemRestockable | Bool | Indicates whether the line item can be restocked. | |
| LineItemSku | String | The SKU number of the variant. | |
| LineItemTaxable | Bool | Indicates whether the variant is taxable. | |
| LineItemVendor | String | The name of the vendor who supplied the variant. | |
| LineItemCurrentQuantity | Int | The line item's quantity, minus any removed quantity. | |
| LineItemMerchantEditable | Bool | Indicates whether the line item can be edited. | |
| LineItemRefundableQuantity | Int | The line item's refundable quantity, calculated as quantity minus removed quantity. | |
| LineItemNonFulfillableQuantity | Int | The total number of units that can't be fulfilled. For example, refunded items or non-fulfillable items such as tips. | |
| LineItemRequiresShipping | Bool | Indicates whether the variant requires physical shipping. | |
| LineItemUnfulfilledQuantity | Int | The number of units not yet fulfilled. | |
| LineItemImageId | String | A globally unique Id of the associated image. | |
| LineItemImageWidth | Int | The original width of the image in pixels. Contains null if the image isn't hosted by Shopify. | |
| LineItemImageAltText | String | Alternative text that describes the image. | |
| LineItemImageHeight | Int | The original height of the image in pixels. Contains null if the image isn't hosted by Shopify. | |
| LineItemImageUrl | String | The URL location of the image. | |
| LineItemProductId | String | A globally unique Id of the associated product. | |
| LineItemVariantId | String | A globally unique Id of the associated variant. | |
| LineItemSellingPlanSellingPlanId | String | The Id of the selling plan associated with the line item. | |
| LineItemStaffMemberId | String | A globally unique Id of the staff member associated with the line item. (Available only with a ShopifyPlus subscription) | |
| Quantity | Int | The quantity of the refunded line item. | |
| Restocked | Bool | Indicates whether the refunded line item was restocked. Not applicable for SuggestedRefunds. | |
| RestockType | String | The type of restock applied to the refunded line item. | |
| LocationId | String | A globally unique Id of the location associated with the refund. | |
| PriceSetPresentmentMoneyAmount | Decimal | The refund price in the presentment currency, expressed as a decimal money amount. | |
| PriceSetPresentmentMoneyCurrencyCode | String | The currency code of the refund price in the presentment currency. | |
| PriceSetShopMoneyAmount | Decimal | The refund price in the shop's currency, expressed as a decimal money amount. | |
| PriceSetShopMoneyCurrencyCode | String | The currency code of the refund price in the shop's currency. | |
| SubtotalSetPresentmentMoneyAmount | Decimal | The subtotal in the presentment currency, expressed as a decimal money amount. | |
| SubtotalSetPresentmentMoneyCurrencyCode | String | The currency code of the subtotal in the presentment currency. | |
| SubtotalSetShopMoneyAmount | Decimal | The subtotal in the shop's currency, expressed as a decimal money amount. | |
| SubtotalSetShopMoneyCurrencyCode | String | The currency code of the subtotal in the shop's currency. | |
| TotalTaxSetPresentmentMoneyAmount | Decimal | The total tax amount in the presentment currency, expressed as a decimal money amount. | |
| TotalTaxSetPresentmentMoneyCurrencyCode | String | The currency code of the total tax in the presentment currency. | |
| TotalTaxSetShopMoneyAmount | Decimal | The total tax amount in the shop's currency, expressed as a decimal money amount. | |
| TotalTaxSetShopMoneyCurrencyCode | String | The currency code of the total tax in the shop's currency. | |
| LineItemContractId | String | A globally unique Id of the associated contract. |