QA Import Process

     

   

      Questions & Answers Import Process   Client Documentation  January 2016               

1

Background  During your PowerReviews implementation you can import your existing product questions and  answers from other providers into our system.  In order to do this you will need to export the  reviews from your previous solution, and send them to us in XLS format.    Steps for Import Process  1. Prepare and send your import file to PowerReviews.  a. Sample File  2. PowerReviews will import the data into your test account.  3. Review the imported data within your test environment for accuracy.  4. PowerReviews will import the data into your production account.    File Requirements  ● XLS File  ● All required fields included (see below) 

    Required Fields  Field 

Permitted Values 

Description 

Question ID

Whole Number

Unique ID for the Question.

Question Submission Date

Date

The date the user wrote the review. MM/dd/yy HH:mm:ss z

Question Status

Valid Status

“APPROVED”, “PENDING”, or “REJECTED”

Question Summary

String

Question Details

String

Product ID

String (Max Length 50)

Unique ID for the Product PageID

  180 N LaSalle Street, 5th Floor | Chicago, IL 60601 | www.powerreviews.com   PowerReviews, Inc. Confidential 

2

Product Name

String

Product Brand

String

Asker Nickname

String

The user’s nickname on the asker.

Asker Location

String

Physical location of asker..

Answer ID

Whole Number

Unique ID for the Answer.

Answer Submission Date

Date

The date the user wrote the review. MM/dd/yy HH:mm:ss z

Answer Status

Valid Status

“APPROVED”, “PENDING”, or “REJECTED”

Answer Text

String

Answerer Nickname

String

The user’s nickname of the answerer.

Answerer Location

String

Physical location of answerer.

       

  180 N LaSalle Street, 5th Floor | Chicago, IL 60601 | www.powerreviews.com   PowerReviews, Inc. Confidential