Batch Review Import
Batch Review Import loads product reviews from a spreadsheet, which is how you bring review history across when migrating from another platform or a separate review service.
Opening the tool
Main Menu → Items → Tools → Batch Review Import
The screen itself is titled Upload Reviews.
Preparing the spreadsheet
Accepted formats are CSV, XLS, and XLSX.
Column headers are matched by name, and matching ignores case and surrounding spaces. So
item id, Item ID, and ITEM ID all work. Column order does not matter.
Required columns
Every row needs all six:
| Column | Holds |
|---|---|
| Item ID | The item the review belongs to |
| Status | The review's state |
| Featured | Whether the review is promoted |
| Review Title | The review's headline |
| Review Content | The review body |
| Product Rating: Overall | The overall star rating |
Optional columns
Include these when you have the data:
Submitted, Reviewer Nickname, Review Media, Recommend To Friend, Helpful Yes Votes, Helpful No Votes, Awaiting Screening, Email.
Carrying Submitted across matters when you are migrating, because without it the reviews lose their original dates.
Use Download a sample spreadsheet on the screen to get a file containing every supported column. Starting from it is quicker than building headers by hand, and it removes any doubt about spelling.
Importing
- Click Choose File and select your spreadsheet.
- Click Validate.
Return to Item Management takes you back to the item list without importing.
Related Documentation
- Batch Item Import - import items rather than reviews
- Item Tools - the full set of bulk tools