Page 1 of 1

Importing/Keeping Product Reviews

Posted: Wed Aug 13, 2008 7:29 am
by Robbie@FireFold
Anyone have thoughts on how I could import reviews? Logically I know my old software and Able will not have the same setup - so this will have to be a manual entry.

I don't want to make these reviews look 'fake' because they are legit customer reviews.

How/where does able store the reviews of each product in the backend? I'm thinking maybe I could 'inject' them that way instead of trying from the front end.

Re: Importing/Keeping Product Reviews

Posted: Wed Aug 13, 2008 7:47 am
by heinscott
Robbie... the information you are looking for is in the ac_ProductReviews table. All information there looks pretty straightforward , too. The only problem you might have is with the ReviewerProfileId. I believe that information is stored in the ac_ReviewerProfiles table. Therefore, in order to make everything show up correctly, you're also going to have to import your old site's reviewer information into this table first, and then import your reviews based on the ReviewProfileId.
Hope this helps.

Scott

Re: Importing/Keeping Product Reviews

Posted: Wed Aug 13, 2008 9:16 am
by jmestep
Scott is correct on this. I imported reviews from an old site -- it was Able 5 so I was able to keep the Product id the same. I had so many that I just made a user called Customer Review and used that for all the old ones.