Cmdlets for BigCommerce

Build 24.0.9062

ProductReviews

Returns reviews registered for products.

Table Specific Information

Select


SELECT * FROM ProductReviews 

Insert

To insert a new ProductReviews, you need to specify at least the following columns: Title,Status, Id,ProductId,DateReviewed.

INSERT INTO ProductReviews (Title,Status, Id,ProductId,DateReviewed) VALUES ('Car Interior121', 'approved','6','103','2019-08-24T14:15:22Z')

Update


UPDATE ProductReviews SET Title='Testing123' where Id=7

Delete


DELETE FROM ProductReviews WHERE Id = 16

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

The Id of the review.

ProductId [KEY] Integer True

Products.Id

The Id of the corresponding product.

Title String False

Title of the review.

Text String False

Text content of the review.

Status String False

The status of the product review. Must be one of approved, disapproved, or pending.

Rating Integer False

The rating of the product review. Must be one of 0, 1, 2, 3, 4, or 5.

Email String False

The email of the reviewer. Must be a valid email, or an empty string.

Name String False

The name of the reviewer.

DateCreated Datetime True

The date of creation for the review.

DateModified Datetime True

The last modification date of the review.

DateReviewed Datetime False

Date the product was reviewed.

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