Excel Add-In for WooCommerce

Build 23.0.8839


Retrieve and modify products reviews.

Table Specific Information


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'


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')


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.

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