VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: werian on November 05, 2012, 21:49:47 PM

Title: Reviews migration from Virtuemart 1 to Virtuemart 2 - solution
Post by: werian on November 05, 2012, 21:49:47 PM
Hello there!

After publishing Products additional images migration from Virtuemart 1 to Virtuemart 2 (http://forum.virtuemart.net/index.php?topic=109502.0), I would like to upload another migration plugin.
I'm talking now about reviews.
Use this plugin after VM 1 => VM 2 migration process, when your old VM 1 tables still exists into target, new database.
THIS PLUGIN WORKS FINE ONLY WITH MIGRATED JOOMLA USERS FROM YOUR OLD VIRTUEMART 1 SITE!

Download:

Use this url: http://joomstuff.com/free/plg_vm1_reviews_migrator.php

Installation:

Installation is simple - use your Joomla installer, after that - publish the plugin.

Migration process:

1. Old Virtuemart 1 tables musts exists in your actual database! (especially #__vm_product_reviews table), with the same prefix, as your Virtuemart 2 database prefix.
2. Put this url into you browser address bar: www.your_vm2_site.com/administrator/index.php?convertVm1Reviews  (don't forget /administrator/ !)
3. You will get this form:

(http://joomstuff.com/free/migration_reviews_1.png)

4. Put "Start process" to begin reviews migration.
5. You will get this message on complete:

(http://joomstuff.com/free/migration_reviews_2.png)


If you will get any error message - probably migrated review had some special characters in comment. That review comment will be non complete (spited to some word, which has that special character). You should copy-past manually that review from VM1 to VM2.


Regards, sorry for my poor English & have fun!  ;)

Łukasz Duda / Luke Duda
http://joomstuff.com/
http://dodatkijoomla.pl/
Title: Re: Reviews migration from Virtuemart 1 to Virtuemart 2 - solution
Post by: kaistudios on March 17, 2016, 06:15:23 AM
Hello do you have an updated version of this and a way to migrate product reviews & ratings from VM1.5 to VM3?
I used a migrator plugin but for some reason it only migrated about half the reviews and also I had to manually adjust the product IDs to match
I also tried csvi but I don't see a field to export for reviews on the old joomla.
I have about 700 and been doing a few manually with phpmyadmin but it takes forever
Thank you
Title: Re: Reviews migration from Virtuemart 1 to Virtuemart 2 - solution
Post by: DayCounts on November 11, 2022, 16:36:56 PM
Hi,
VM Migrator will do that for you
https://extensions.virtuemart.net/back-office/import-export/virtuemart-migrator-detail
Title: Re: Reviews migration from Virtuemart 1 to Virtuemart 2 - solution
Post by: nehakakar on July 31, 2023, 16:02:30 PM
Here are the solution.

Check the old Virtuemart 1 tables, especially the #__vm_product_reviews table, exist in the new database with the same prefix as the Virtuemart 2 database prefix.
Download the migration plugin from the provided URL: http://joomstuff.com/free/plg_vm1_reviews_migrator.php
Install the plugin using the Joomla installer and then publish the plugin. Then Access the migration process by entering the following URL in your browser's address bar: www.your_vm2_site.com/administrator/index.php?convertVm1Reviews (replace www.your_vm2_site.com with the actual URL of your Virtuemart 2 site and don't forget to include /administrator/).
now click on Start process
I hope it helps you.