OrderRefunds

Retrieve and modify order refunds.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns support only the = comparison, unless stated otherwise. The available column for this table is: OrderId. All other columns are processed client side. If the 'OrderId' filter is not specified, the 本製品 will fetch a list of all the orders and perform a request for each order in the list.

SELECT * FROM OrderRefunds WHERE OrderId = 21

Insert

The following attribute is required when performing an insert: OrderId.

INSERT INTO OrderRefunds (OrderId) VALUES (33)

Columns


Name	Type	ReadOnly	Description
Id	Long	False	Unique identifier for the resource.
DateCreated	Datetime	True	The date the order refund was created, in the site's timezone.
Amount	String	False	Refund amount.
Reason	String	False	Reason for refund.
RefundedBy	Long	False	User ID of user who created the refund.
RefundedPayment	Boolean	True	If the payment was refunded via the API.
LineItems	String	False	Line items data.
OrderId	String	True	Id of the order.

Pseudo-Columns

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