klantenvertellen.nl review import

In this document we describe how to import reviews for Klantenvertellen and Kiyoh in “Two Steps”

1. CREATE FORM IN SFF

2. IMPORT REVIEWS IN ARI

STEP 1. CREATE FORM IN SFF

1. Log in into the Smart Feedback Forms

   1. Use Connect Credentials
      
      

2. Create a new form (default form is in English)

   1. Click on Create New Form

      1. Input the form Name (for example review-import-30-12-2020)

      2. select the Language (Dutch)

      3. select the Review Type (Seller)

      4. Click on Save

   2. Click "Continue"

3. Add fields that you need to push to eKomi

   1. Remove the "Would you recommend us to your friends?" question

      1. click on Trash the icon next to the question, Click on Yes to confirm deletion.

   2. Click on the edit icon next to "How many stars would you like to award?"

      1. Update the Question text to "Totaal score"

      2. Changed scale from “Star rating” to “NPS”

      3. Click on Save

   3. Click on the edit icon next to "Please describe your experience:"

      1. Update the Question text to "Beschrijf uw ervaring"

      2. Click on Save

   4. Add Short Text field Naam

      1. Change “Minimum number of characters” to 1

      2. Enable checkbox “Reviewer's first name (Will be sent to the certificate page)”

      3. Click on Save

   5. Add Short Text field E-mailadres

      1. Enable checkbox “Reviewer's email address (Will be used for dialog)”

      2. Click on Save

   6. Add Short Text field Review Id

      1. Click on Save

   7. Add other fields you want to push to eKomi as Short Text

4. SAVE FORM

Video 1 - Setup SmartForm for Review Import klantenvertellen.nl (in Dutch):

Open

STEP 2. IMPORT REVIEWS IN ARI

After you have created your form for the review import continue with ARI.

1. Log in into the ARI

   1. Use Connect Credentials

2. Create Input Source

   1. Step 1: Give title (e.g. Review_import_30_12_2020) under Source Type

   2. Step 2: Map (at least the following) CSV columns:

      1. Name → FIRST_NAME

      2. Totaal score → custom title: Totaal Score

      3. Beschrijf uw ervaring → COMMENT

      4. E-mailadres → EMAIL

      5. Datum → TRANSACTION_DATE (Date format: Y-m-d\TH:i:s.u\Z[\U\TC])

      6. Review Id → ORDERID

   3. Step 3: Mapping Fields to SFF Fields

      1. FIRST_NAME → NAAM

      2. Totaal score → Totaal Score

      3. COMMENT → Beschrijf uw ervaring

      4. EMAIL → E-mailadres

      5. TRANSACTION_DATE → Datum

      6. ORDERID → Review Id

   4. Step 4: Select Data Source: Upload files manually

   5. Confirmation → Click on FINISH

3. UPLOAD CSV-FILE with the review you want to import.

   1. Upload File

   2. Check if your reviews look good

   3. Click on “QUEUE CSV FILE FOR PROCESSING”

Done! The reviews will be imported within the next 24 hours.

Video 2 - Setup Input Source in ARI for Review Import klantenvertellen.nl (in Dutch):

Open