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. Following columns are supported server side, all other columns are processed client side.
- Id supports the '=, NOT IN' operators.
- Status supports the '=' operator.
- Reviewer supports the '=, IN, NOT IN' operators.
- ReviewerEmail supports the '=' operator.
- ProductId supports the '=' operator.
- DateCreated supports the '>,<,>=,<=,=' operators.
SELECT * FROM ProductReviews WHERE Id = 4 SELECT * FROM ProductReviews WHERE ReviewerEmail = '[email protected]' SELECT * FROM ProductReviews WHERE DateCreated = '2024-08-22 08:47:21.0'
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. |