Returns

Stores records of product returns, including reason codes, refund references, and associated order data.

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

OrdersId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM Returns WHERE OrdersId = 'Val1'

Insert

The following columns can be used to create a new record:

OrdersId, ReturnLineItems (references ReturnLineItems), ReturnExchangeLineItems (references ReturnExchangeLineItems)

ReturnLineItems Temporary Table Columns


Column Name	Type	Description
Quantity	Int	The quantity being returned.
ReturnReason	String	The reason for returning the item.
ReturnReasonNote	String	Additional information about the reason for the return. Maximum length: 255 characters.
FulfillmentLineItemId	String	A globally-unique ID.

ReturnExchangeLineItems Temporary Table Columns


Column Name	Type	Description
VariantId	String	A globally-unique ID.
Quantity	Int	The number of variant units ordered.
AppliedDiscountValueAmount	Decimal	The discount to be applied to the exchange line item. The value of the discount as a fixed amount.
AppliedDiscountValueAmountCurrencyCode	String	The discount to be applied to the exchange line item. Currency of the money.
AppliedDiscountValuePercentage	Double	The discount to be applied to the exchange line item. The value of the discount as a percentage.
AppliedDiscountDescription	String	The discount to be applied to the exchange line item. The description of the discount.
GiftCardCodes	String	The gift card codes associated with the physical gift cards.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique identifier for the return record.
OrdersId	String	True	Orders.Id	The globally unique identifier of the order associated with this return.
Name	String	True		The system-generated name or reference label used to identify the return.
Status	String	True		Indicates the current state of the return, such as 'requested', 'approved', 'declined', or 'completed'.
TotalQuantity	Int	True		The total number of items included in the return, summed across all return line items.
DeclineReason	String	True		The reason provided by the merchant for declining the customer's return request, if applicable.
DeclineNote	String	True		A message sent to the customer explaining why their return request was declined. Limited to 500 characters.
ReturnLineItems	String	True		A list of the original line items that are being returned as part of this return record.
ReturnExchangeLineItems	String	True		A list of replacement or exchange items being added to the order as part of the return process.