Knowledgebase: General
How do I import Product Reviews via CSV?

With 3dcart's built-in Product Review function, you have the ability to import reviews to your store. This can be helpful if you are migrating from another service and you would like to have your reviews from your older platform appear on your new platform with 3dcart.

Note
You must first make sure the 3dcart Product Review module is enabled for your store. To enable the module:

  1. Log into your 3dcart Online Store Manager
  2. Using the left hand navigation menu, go to Modules
  3. Then, using the search bar at the top, search for "Product Reviews" to view the module

Mark the "Enable Product Reviews" checkbox and click on "Save" at the top right to commit your changes.

To generate the CSV file needed for import:

  1. Log into your 3dcart Online Store Manager
  2. Using the left hand navigaiton menu, go to Products ->Reviews
  3. Next, click on the "Export/Import" button found at the top right of the page
  4. In the Import section of the page (on the right hand side) click on the "Sample File" link provided (under "File Input")

This sample file will be formatted for importing back to your store with data. The file will contain the following column headers:

  • reviewid
    This is the database ID for the review record. It is assigned by the store and should be left blank for new reviews
  • id
    This is the ID/SKU for the product that the review will pertain to.
  • catalogid
    This is the catalogid for the product that the review will pertain to
  • user_name
    This will be the display name of the customer entering the review
  • user_email
    This will be the reviewer's email address
  • user_city
    This will correlate to the reviewer's city
  • short_review
    This column will be for the short post/subject line of the review
  • long_review
    This column will be for the fullly written out review itself
  • rating
    This column will be used for the rating (1 to 5) of stars rated for the review
  • review_date
    This will be the date of the review
  • approved
    This column will denote if the review is approved or not
    This is a toggle value of either zero (0) or one (1)
    • 0 = No
    • 1 = Yes
  • userid
    This will be the numerical ID (in your store's database) of the customer's record.
    If you do not know this information, you may use a zero (0)
  • userip
    This is the user's recorded IP address when the review was submitted.
    If you do not know this information, you may leave it blank
  • rev_verified
    This column will denote if the user is a verified puchaser of the item or not.
    This is a toggle value of either zero (0) or one (1).
    • 0 = No
    • 1 = Yes
  • rev_helpful
    This column will let you record the number of helpful ratings that the review has garnered
  • rev_votes
    This column will let you record the total number of helpfulness votes given to the review

After you've finished editing your import file, save it as a CSV file and continue with these steps to import it to your store.

  1. Log into your 3dcart Online Store Manager
  2. Using the left hand navigaiton menu, go to Products ->Reviews
  3. Next, click on the "Export/Import" button found at the top right of the page
  4. Click on the Browse button under the Import section (on the right hand side) to locate your saved CSV file.
  5. Then, click on the "Import Data" link to have the reviews added to your store.

Tip
You can also export your store's existing reviews using the Export Data options located on the left hand side of the page.


Help Desk Software by Kayako fusion