JDBC Driver for Shopify

Build 23.0.8839

RefundLineItems

Retrieves the 'RefundLineItem' resources attached to the refund.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the RefundId column, which supports the '=' comparison operator.

The 本製品 processes other filters client-side within the 本製品.

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.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839