Skip to main content

Importing reviews using CREMA template

  • Updated

πŸ’‘ This document provides guidance on importing reviews from external sources into CREMA.

Key Summary

  • Prepare your review data using the CREMA standard template and ensure it is saved as a CSV file with UTF-8 encoding.
  • Upload your prepared CSV file through the CREMA Admin page by navigating to Review > Review management > Import reviews > Upload file.
  • Monitor the status of your import, view imported reviews, and manage any errors using the Import log tab.

If you have reviews from other sources, such as a previous reviews app that is not supported by CREMA, you can import these reviews by following the detailed instructions provided in this document.

 

In this article

STEP 1. Create and upload the file

 

  1. Open the CREMA standard template and click Make a copy.
    Screenshot showing the 'Make a copy' option in Google Sheets template.
  2. Fill in your reviews accordingly.
    • Enter the reviews starting from row 5.
      • Required columns, which are 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.
        Screenshot highlighting that header rows (1-4) should not be edited in the CSV template.
  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
  5. Choose Other review for Type of CSV files.
  6. Navigate to the location where your file is saved and click Upload.
    Screenshot of the review import screen with the 'Upload' button highlighted.

 

STEP 2. View the import log

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

Screenshot of the 'Import log' tab showing review import history and status.

 

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 completely failed.
    • 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 the Download report button to review and fix the errors. After addressing the errors in your file, please upload it again.

STEP 3. 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 in the downloaded report 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 - CREMA will still be able to read your file.
  3. Save the file in CSV Format.
  4. Click Upload to try the upload again.

Tips for Importing Reviews

  • 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.

Frequently Asked Questions (FAQ)

What kind of reviews can I import using this method?

πŸ‘‰ You can import reviews from other sources, such as previous review applications not directly supported by CREMA, by preparing your data in the standardized CSV template.

What should I do if my review import fails or partially fails?

πŸ‘‰ If an import fails or partially fails, navigate to the Import log tab in your CREMA Admin page. Click the Download report button to get a CSV file that contains an error_message column. This column will help you identify the specific issues. After making the necessary corrections to your file, you can re-upload it.

Are there any limitations to the number of reviews I can upload or how long it takes for them to appear?

πŸ‘‰ You can upload a maximum of 100,000 reviews at once. Text-only reviews are typically uploaded and displayed immediately. However, photo and video reviews may take additional time to process and appear in the reviews panel. If the processing for photo/video reviews takes longer than 1 hour, please contact CREMA support for assistance.

Related articles