To export product reviews, go to Catalog > Products from the Storefront module menu. Click on the Export link. Then select "Product review".
| Column |
Type |
Data required |
Description |
Example |
| Act |
String |
No |
No import action supported at the moment. |
|
| ProductReviewID |
Integer |
Yes/No |
Database object identifier. |
45 |
| Approved |
Boolean |
Yes |
|
True |
| Comment |
String |
No |
|
|
| CreateDate |
DateTime |
No |
|
|
| Email |
String |
No |
|
|
| FirstName |
String |
No |
|
|
| LastName |
String |
No |
|
|
| OverallRating |
Integer |
Yes |
Rating between 1 to 5. |
5 |
| ProductID |
Integer |
Yes/No |
Associate the product by its ProductID. If you specify ProductID, the ProductKey will be ignored. |
3 |
| ProductKey |
String |
Yes/No |
Associate the product by its ProductKey. If you specify ProductID, the ProductKey will be ignored. |
apple-ipad |
| Title |
String |
No |
|
|
| UpdateDate |
DateTime |
No |
|
|
| UserHostAddress |
String |
No |
IP address of the user. |
|
| UserID |
Integer |
No |
Associate the user by its UserID. If anonymous user, leave blank. |
234 |