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