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 = 'testemail@domain.com'
Insert
The following attributes are required when performing an insert: ProductId, Reviewer, Review.
INSERT INTO ProductReviews (ProductId, Reviewer, ReviewerEmail, Review) VALUES (167, 'reviewer', 'reviewer@domain.com', 'review_content')
Columns
| Name | Type | ReadOnly | 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. |