Refunds

Create and query refunds.

Table-Specific Information

Select

The 本製品 uses the Shopify API to process search criteria that refer to the OrderId column. The 本製品 processes other filters client-side within the 本製品.

For example, the following queries are processed server-side. If you specify the unique identifier of the Order, then this view will only list refund information concerning that order.

SELECT * FROM Refunds WHERE OrderId = '179098550295'

SELECT * FROM Refunds WHERE OrderId = '179098550295' AND Id = '7382073367'

Insert

You must specify the OrderId when inserting a refund.

Create a new refund for an order using aggregates.

INSERT INTO Refunds (OrderId, Restock, Notify, Note, ShippingFullRefund, LineAggregate) VALUES ('123', true, true, 'Wrong size', true, '[{\"id\":\"123\",\"quantity\":3,\"restock_type\": \"return\"}]')

Create a new refund for an order using temporary table.

INSERT INTO OrdersItems#TEMP (ItemId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Refunds (OrderId, Restock, Notify, Note, ShippingFullRefund, LineAggregate) VALUES ('123', true, true, 'Wrong size', true, 'OrdersItems#TEMP')

Create a new refund for an order and attach a transaction to the refund as well using aggregates.

INSERT INTO Refunds (OrderId, LineAggregate, OrderTransactionAggregate) VALUES ('123', '[{\"id\":\"123\",\"quantity\":3,\"restock_type\": \"return\"}]', '[{\"kind\":\"refund\",\"amount\":5.5,\"gateway\":\"gw\",\"parent_id\":\"789\"}]')

Create a new refund for an order and attach a transaction to the refund as well using temporary table.

INSERT INTO OrdersItems#TEMP (ItemId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Transactions#TEMP (TransactionItemParentId, TransactionItemAmount, TransactionItemKind, TransactionItemGateway) VALUES ('789', 5.5, 'refund', 'gw')
INSERT INTO Refunds (OrderId, LineAggregate, OrderTransactionAggregate) VALUES ('123', 'OrdersItems#TEMP', 'Transactions#TEMP')

Refund a specific amount of shipping using aggregates.

INSERT INTO Refunds (OrderId, ShippingAmount, OrderTransactionAggregate) VALUES ('123', 5.3, '[{\"parent_id\":\"456\"}]')

Refund a specific amount of shipping using temporary table.

INSERT INTO Transactions#TEMP (TransactionItemParentId) VALUES ('456')
INSERT INTO Refunds (OrderId, ShippingAmount, OrderTransactionAggregate) VALUES ('123', 5.3, 'Transactions#TEMP')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique identifier for the refund.
OrderId	Long	False	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime	True	Orders.UpdatedAt	The date and time when the order was last modified.
Note	String	False		The optional note attached to a refund.
Restock	Bool	True		Whether or not the line items were added back to the store inventory.
UserId	Long	True		The unique identifier of the user who performed the refund.
CreatedAt	Datetime	True		The date and time when the refund was created.
ProcessedAt	Datetime	True		The date and time when the refund was imported.
LineAggregate	String	False		A JSON aggregate of line items associated with the refund.
OrderTransactionAggregate	String	False		A JSON aggregate of transactions associated with the refund.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。