JDBC Driver for WooCommerce

Build 24.0.9062

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 References 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. See api_refund.

LineItems String False

Line items data. See Order refund - Line items properties

ApiRefund Boolean False

When true, the payment gateway API is used to generate the refund. Defaults to true. write-only

Metadata String True

Meta data. See OrderRefunds - Meta data properties.

OrderId String True

Orders.Id

Id of the order.

Pseudo-Columns

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

Name Type Description
ReferenceNumber String

This column will be used in Bulk operations to get specific values from the Temp tables.

ApiRestock Boolean

When true, the selected line items are restocked. Default is true.

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