What can this extension do?
Import guests reviews and ratings on products in bulk
The current version is 1.0.0, tested in Magento ver. 1.6.2.0 CE, working well
The extension’s name
Cancms_Review
Notices:
The perfect Magento version for this extension is Magento ver. 1.6.x.x
When you use this extension to import new reviews and ratings, please back up the database first, if you don’t want to back up the whole database, at least you should back up the tables related to reviews and ratings, like the ones starting with review_ or rating_
The review importing will be using a csv file as a media, and the csv file should be in UTF-8 encoding.
The extension takes the semicolon(;) as default csv separator, so the review content should not contain any semicolon(;) to mix up with the csv separator.
The csv file is uploaded at a folder var/importexport, please keep this folder existed and make it writable, like a linux privilege 777.
Screen shot:
P1:
The Magento front end review input interface:
P2:
The Csv file, opened with MS Excel:
The Csv file, opened with a plain text editor Editplus:
1. Store id: the store id of the store which you want to import the reviews and ratings into, you can check up the store id from back end “Manage stores”.
2. Nickname: the reviewer’s name
3. Created_at: the review time, should be in a standard mysql datatime format like: 2012-05-03
4. Product_id: the product of which the review is on
5. Title: review title
6. Detail: review detail content
7. Value_rating: rating on product Value, integer, maximum 5
8. Quality_rating : rating on product Quality, integer, maximum 5
9. Price_rating: rating on product Price, integer, maximum 5
P3:
Back end interface 1, choose the csv file to import:
P4:
Back end interface 2, import successfully.
P5:
After importing successfully, the reviews shown on front end and back end:
Front end:
Back end:
Support:
http://cancms.com/content/item/view/iid/66
Contact us:
How to get this extension?
First, please make contact with us, we will inform you the request has been received.
Then click the “Buy now” button, you will be redirected to Paypal to finish the payment process.
Once the payment is confirmed, we will send you the Extension immediately.
We charge $50 for this extension:
![]() |
![]() |