JDBC Driver for WooCommerce

Build 24.0.9062

ProductReviews

Retrieve and modify products reviews.

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 columns for this table are: Id, Status, Reviewer, ReviewerEmail, ProductId. All other columns are processed client side.

SELECT * FROM ProductReviews WHERE Id = 4
SELECT * FROM ProductReviews WHERE ReviewerEmail = '[email protected]'

Insert

The following attributes are required when performing an insert: ProductId, Reviewer, Review.

INSERT INTO ProductReviews (ProductId, Reviewer, ReviewerEmail, Review) VALUES (167, 'reviewer', '[email protected]', 'review_content')

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique identifier for the resource.

DateCreated Datetime True

The date the review was created, in the site's timezone.

ProductId Long False

Unique identifier for the product that the review belongs to.

Status String False

Status of the review. Options: approved, hold, spam, unspam, trash and untrash. Defauls to approved.

Reviewer String False

Reviewer name.

ReviewerEmail String False

Reviewer email.

Review String False

The content of the review.

Rating Integer False

Review rating (0 to 5).

Verified Boolean False

Shows if the reviewer bought the product or not.

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