Import reviews from a CSV file
You can bulk-import reviews from a spreadsheet, for example reviews exported from another app or collected elsewhere. For the columns A2Reviews accepts, see CSV file format for review imports.
Two ways to import
- Many products at once: on the Products page, click Import Reviews From CSV. Each row goes to the product whose
handle is in that row.
- A single product: on the Products page, click the product's Import reviews (plus icon) button and open the Import From CSV tab. Every row is imported into that product, whatever is in the
handle column.
Step 1: Upload the file
- Click Upload CSV and choose your file. Files should be smaller than 5 MB.
- To reuse a file you uploaded before, pick it under Or From History Upload.
- Click Import Now next to the file. The Import CSV Editor opens.
Step 2: Mapping fields
The editor shows the columns found in your file under Header columns from CSV, and the A2Reviews fields under them.
- A2Reviews tries to match columns automatically. Click Auto mapping fields to run it again.
- For any field left empty, drag a CSV column onto the matching A2Reviews field. Click the x next to a mapping to remove it.
- Make sure the required fields are mapped:
rating, handle and author.
Step 3: Edit Reviews
Look over the reviews before they are saved. You can filter by star rating, photos or country, and fix or remove rows.
Step 4: Finish
- Choose what to do when a product with the same handle already has reviews:
- Skip: leave that product as it is.
- Replace: replace its reviews with the ones from the file.
- Merge: add the file's reviews to the existing ones. Rows that exactly match a review already on the product are not added again.
- If a handle doesn't match any product yet, A2Reviews creates a product entry for it. You can give it a title and image (JPG or PNG) before you import.
- Click Import Reviews and wait until you see "All reviews from CSV have been imported!"
Tip: Handles must match your store's product handles exactly, or the reviews won't show on the right product page. Run Sync Products before you import so your store products are listed.
If the editor says "Not found CSV file or file format error.", see the file requirements in CSV file format for review imports.