RefundsItems

Columns

Name

Type

Description

ItemId [KEY]

Long

The id of the order item. Only available for orders.

OrderID [KEY]

Long

The id of the refund this refunded item belongs to.

RefundId [KEY]

Long

The id of the refund this refunded item belongs to.

LocationId

Long

The unique identifier of the location tied to the refund item

ProductId

Long

The id of the of the product beloning to the order item.

ItemVariantId

Long

The id of the product variant.

ItemTitle

String

The title of the product.

Name

String

The name of the product variant.

ItemQuantity

Integer

The number of products that were purchased.

ItemPrice

Decimal

The price of the item before discounts have been applied.

ItemGrams

Integer

The weight of the item in grams.

SKU

String

A unique identifier of the item in the fulfillment.

VariantTitle

String

The title of the product variant.

Properties

String

Shows custom properties for this order item.

Vendor

String

The name of the supplier of the item.

FulFillmentsService

String

Service provider who is doing the fulfillment.

RequiresShipping

Boolean

States whether or not the fulfillment requires shipping.

Taxable

Boolean

States whether or not the product was taxable.

GiftCard

Boolean

States whether or not the order item is a gift card.

FulfillableQuantity

Integer

The amount available to fulfill.

TotalDiscount

Decimal

The total discount amount applied to this order item.

FulfillmentStatus

String

How far along an order is in terms order items fulfilled.

RefundSubtotal

Decimal

The refunded amount for this item. This is calculated by multiplying ItemPrice with RefundQuantity.

RefundQuantity

Integer

The quantity of the item refunded.

RefundRestockType

String

The type of the restock action.

RefundSubtotalPresentmentAmount

Decimal

The total amount of the presentment money.

RefundSubtotalPresentmentCurrencyCode

String

The currency code of the presentment money.

RefundSubtotalShopAmount

Decimal

The total amount of the shop money.

RefundSubtotalShopCurrencyCode

String

The currency code of the shop money.

RefundTotalTax

Decimal

Total tax for the refunded item.

RefundTotalTaxPresentmentAmount

Decimal

Total tax amount for the presentment money.

RefundTotalTaxPresentmentCurrencyCode

String

Currency code for the tax on presentment money.

RefundTotalTaxShopAmount

Decimal

Total tax amount for the shop money.

RefundTotalTaxShopCurrencyCode

String

Currency code for the tax on shop money.

AppliedDiscountTitle

String

The title of the applied discount for this order. Only available for draft orders.

AppliedDiscountDescription

String

The description of the applied discount for order. Only available for draft orders.

AppliedDiscountValue

Decimal

The value of the applied discount for this order. Only available for draft orders.

AppliedDiscountValueType

String

The value type of the applied discount for order. Only available for draft orders.

AppliedDiscountAmount

Decimal

The amount of the applied discount for this order. Only available for draft orders.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Status

String

Filter orders by their status. Valid values are: open: show only open orders, closed: show only closed orders, cancelled: show only canceled orders, any: show orders of any status,default: open.

Last updated