Export reviews to CSV and restore from backups

A2Reviews lets you export your reviews to CSV files, either for a single product or for your whole store. You can also restore a product's reviews from automatic or manual backups. This article covers both.

Export all reviews

  1. Open Products.
  2. In the page header, next to the CSV import button, open the Export reviews to CSV panel.
  3. Under Please select the options below, tick the star ratings to include (5 Stars to 1 Star).
  4. Optionally tick Skip disabled products, and choose a Language if you use review translations.
  5. Click Export All Reviews.

Finished files appear in the Exported list in the same panel, where you can download them or delete old ones.

Export one product or a selection

Choose the CSV columns and file name

Go to Settings and open the CSV Reviews Export tab.

  1. Create an export profile, or edit an existing one with Edit Export Profile.
  2. Enter a Profile Name. Under List fields Allow, click fields to add or remove them, and drag and drop to set the column order. The CSV Fields Map shows how the selected fields map to the CSV columns.
  3. Click Save Change, then set the profile as default. Exports use the default profile (shown as Current Profile).
  4. Under CSV Download Name, choose a file name pattern such as {handle}.csv, {handle}-{datetime}.csv, {profile_name}.csv or {site_domain}-{handle}-{datetime}.csv.

Tip: To move reviews into another tool, create a profile that matches the columns that tool expects. You then won't need to edit the CSV by hand.

Back up and restore a product's reviews

Each product has a backup history. Open the product from Products and choose Backup history and restore.

The list shows when each backup was made, whether it was created automatically or manually, and how many reviews (and reviews with pictures) it contains.

Tip: Before you empty a product's reviews, replace them with a new import, or run bulk actions in the Reviews Editor, click Create a backup and lock it. Then you can always roll back.

Keep a full copy outside A2Reviews

Backups are stored per product inside A2Reviews. For a complete off-site copy, run Export All Reviews regularly and keep the CSV files somewhere safe.

Related articles: Moderation & Publishing, Photo & Video Reviews.