ADO.NET Provider for BigCommerce

Build 23.0.8839


Returns reviews registered for products.

Table Specific Information


SELECT * FROM ProductReviews 


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 ProductReviews SET Title='Testing123' where Id=7


DELETE FROM ProductReviews WHERE Id = 16


Name Type ReadOnly References Description
Id [KEY] Integer False

The Id of the review.

ProductId [KEY] Integer True


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 23.0.8839