Skip to main content

Importing reviews using CREMA template

  • Updated

If you have reviews from other sources, such as the previous reviews app that is not supported by CREMA, Facebook/Instagram, etc, you can import the reviews by following the instructions below.

 

In this article

 

Create and upload the file

  1. Open CREMA standard template and click Make a copy.
  2. Fill in your reviews accordingly.
    • Enter the reviews starting from row 5.
      • Required columns marked with a blue background must be filled in order to upload the reviews.
    • Editing the header columns (row 1~4) is prohibited.
      • Modifying these columns may prevent the reviews from being processed correctly.
  3. Save the file as a CSV.
    • Ensure the encoding option is set to UTF-8 when saving the CSV.
  4. To upload the file, navigate to the CREMA admin page, then go to Review → Review management → Import reviews → Upload file tab.
  5. Choose Other review for Type of CSV files.
  6. Navigate to the location where your file is saved and click Upload.

 

View the import log

You can view the history of your review imports and manage the imported reviews in Import log tab.

 

Available components are as following :

  1. Source
    • The type of CSV file that you uploaded.
  2. Date
    • The date the CSV file and the date that the import was completed.
  3. Status
    • Pending : The import is waiting to begin.
    • Importing : The import is currently in progress.
    • Imported : The import has been successfully completed.
    • Failed : The import has been failed completely.
    • Partially failed : Some reviews have been successfully imported, while others failed.
  4. Result
    • Indicates the number of reviews that were successfully imported and those that failed.
    • If the import failed, the failure reason will be displayed in the Result field.
  5. Uploaded file
    • You can download the uploaded file by clicking the Download file button.
  6. Manage reviews
    • See reviews : Click the button to view the reviews imported in this import.
    • Delete reviews : Click the button to delete all reviews imported in this import.
  7. Import error
    • You can download the error report by clicking Download report button to review and fix the errors. After addressing the errors in your file, please upload it again.

 

Fix errors

If some reviews failed to be imported, you can fix the errors and try uploading again.

  1. In the Import log tab, click the Download report button. A CSV file will be downloaded to your computer.
  2. Use the error_message column on the left to identify the issues and make the necessary fixes.
    Once you've made the changes, you can either delete this column or leave it as it is - we'll still be able to read your file.
  3. Save the file in CSV Format.
  4. Click Upload to try the upload again.

 

⭐ TIPS

  • Imported reviews will be tagged as 'Imported'.
  • A maximum of 100,000 reviews can be uploaded at once.
  • Text reviews will be uploaded immediately, while photo/video reviews may take additional time to appear in the reviews panel. Please contact CREMA support if the processing takes longer than 1 hour.

 

Related articles