> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.kreezalid.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Import Reviews into Kreezalid's Admin Back Office

Effective management of reviews is vital for maintaining both the trust and quality inherent in your marketplace. Whether you are transitioning from a different platform or have accumulated reviews that you wish to add to your Kreezalid marketplace, this guide is here to assist you!

## Prerequisites: Ensure Customers and Suppliers Exist

**Important Note:** Before you proceed with importing reviews, ensure that all customers and suppliers referenced in the import file already exist within your Kreezalid marketplace. Reviews can only be associated with existing user accounts.

## Preparing Your File

Initiate by preparing a file in CSV, XLS, XLSX, or ODS format. Below is a sample structure of data in a CSV file:

```
role;customer_id;supplier_id;note;is_public;review;completed_at
customer;john.doe@mail.com;bob.martin@mail.com;5;yes;Lorem ipsum dolor...;2023-07-23 10:45
supplier;123456;654321;4;no;Qui impedit sint...;2023-07-06 14:32
```

## Fields Breakdown:

1. **role:** 
   - Specify the reviewer's role: `customer` or `supplier`
   - Default: `customer` (if omitted or incorrect)
   - Note: `customer` indicates the review is from a customer about a supplier, while `supplier` signals it's from a supplier about a customer.

2. **customer_id:** 
   - Acceptable identifiers include the email address, external ID, or Kreezalid user ID of the customer.
   - **Mandatory**

3. **supplier_id:** 
   - Identifiable by the email address, external ID, or Kreezalid user ID of the supplier.
   - **Mandatory**

4. **note:** 
   - Assign a numerical rating between `1` and `5`.
   - **Mandatory**

5. **is_public:** 
   - Indicate visibility with `yes` (public) or `no` (private)
   - Default: `no` (if omitted or incorrect)
   - An input of `no` ensures the review will not be publicly visible unless adjusted manually.

6. **review:** 
   - Insert the textual content of the review.

7. **completed_at:** 
   - Provide the review’s completion date.
   - Default: Current datetime (if omitted or incorrect)
   - For CSV imports, adhere to the format: `YYYY-MM-DD HH:MM` or `MM/DD/YYYY HH:MM`. Time is optional.

## Seamless Review Importing

Upon successful file preparation, follow these steps for import:

1. Login to your Kreezalid admin back office.
2. Navigate to the **Reviews** section.
3. Select **Import Reviews**.
4. Upload your prepared file.
5. The system will process the file, providing notifications related to the outcomes and any identified errors.

Congratulations! Your reviews should now be accessible on your marketplace! Conduct a thorough review to validate the accuracy and aesthetic of the uploaded content. For any discrepancies or errors, adjustments can be made manually within the admin panel. 

## Comprehensive Error Handling

In the event of discrepancies within your file, the system will astutely highlight the exact line and specify the nature of the error. To maintain consistency and prevent duplication, the system smartly prevents re-importing previously processed reviews. Therefore, rectify the noted issues within the original file and re-upload in its entirety. Happy reviewing!