Cmdlets for WooCommerce

Build 20.0.7587

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] Integer True

Unique identifier for the resource.

DateCreated Datetime True

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

ProductId Integer 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587