Migrate Virtuemart 1.19 to 2.x.x without losing any data

  • Thursday, 09 May 2013 14:38
Written by 
Rate this item
(3 votes)
Virtuemart Slogan Blue
You can  migrate Virtuemart 1.1.9 to Virtuemart 2.x.x without losing any data like Products, Categories, Orders etc.. Yes, you hear it right.
Before you make any changes to your existing site, please make sure you make full backup of your site using Akeeba Backup or manual backup.
The most probable reason behind upgrading your site to 2.x.x is that you want to upgrade your Joomla 1.5 to 2.5 or higher(or maybe you want to use the latest version).
Ok, now lets get down to business.
Create media directory for new Virtuemart at /images/stories/virtuemart/ using an FTP program or via your Web hosting Control Panel. Now move/copy all your Virtuemart images located at /components/com_virtuemart/shop_image/ to the one created earlier that is , /images/stories/virtuemart/ .
Now rename or delete your Virtuemart component folder located at /components/com_virtuemart/ something like /components/com_virtuemart-old .
Disable all modules and plugins that are related to Virtuemart using the Extension> Modules Manager and Extension>Plugin Manager respectively.

If you are running Joomla 1.5 then please download Virtuemart.2.0.20b from Virtuemart's website(this is the version supported for Joomla 1.5). You will get two files in the download, one is the component and the other is the All in One Package which has all the modules and plugins.
Now install the downloaded component file via Joomla Extensions> Install/Uninstall.
If all goes well you will see a success message.. If anything goes wrong, uninstall Virtuemart and then install the new 2.x.x component again. It should work.

Now your shop is upgraded to VM2 but you will find that all your datas are lost. NO, we haven't migrated the datas yet.
To Migrate all your shop datas, go to your new Virtuemart Component and then on the left panel select Configuration > Configuration and then enable the option called "Enable database Update tools " located under the Shop tab

Virtuemart Database Upgrade

After enabling the Database Update tools, now navigate to Tools > Tools & Migration on the left panel. You will be presented with a screen like

Virtuemart Migration Tools

Now select Migration tab and then you will be presented with options to choose the type of data migration. You can just migrate Products, Orders, Categories etc only..
If you want to migrate everything select Choose a task for migration > Everything. Let the other option remain as it is or select any of the options to suit your need..
Now press the button called Start Migration, your migration time duration will depend on the number of products/categories you have. If your Migration is smooth, you will see a message from Virtuemart telling you that the migration has been completed. If this fail, please migrate each datas individually, like migrating products only and then categories, so on...
That's it. If you have any problem migrating your shop, do drop a comment we will try to help you out.
Read 30078 times


  • Comment Link //www.gravatar.com/avatar/1f24b487c0ed50ed6175e0f9a7d5baab?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Wednesday, 21 August 2013 12:51 posted by umapathi

    Respected Sir/Madam,
    Is it possible migrating virtuemart 1.1.9 to latest version of virtuemart by using Database backup and product images ?

    Actually i want import virtuemart 1.1.9 data to latest version.I created website in joomla 2.5 with virtuemart 2 and I don't know exactly how to import that old virtuemart 1.1.9 products into my new site.Please give some guidance step by step.I hope you will give some better response to me.

    Note:I just have only backup of images and Database

    Thanks and Regards
    Umapathi A

  • Comment Link //www.gravatar.com/avatar/cb1127e793fafc8493dc3d81a4925e96?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Wednesday, 04 December 2013 12:48 posted by umapathi

    How to create Own order number format in virtuemart2.0.24?

    I would like to create an own order number in the format like,
    Order number 001-123456 (01 /13)
    Order number must indicates,
    001 = explanation supplier number
    123456 = vendor item number
    ( 01 /13) = month and year

    Can i have some help from you ..?

  • Comment Link //www.gravatar.com/avatar/acfd21c8f802a8b116d0c2d0fd852e3e?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Monday, 05 May 2014 14:56 posted by kuldeep

    i have already used this method and this works great. can you please let me know the data limit of products that can be migrated by this method. now i have to migrate about 280 categories and 10000 products . would it work and what kind of setting like execution time and memory limit will be required for this ?

  • Comment Link //www.gravatar.com/avatar/54fcc6a3fe50eaa4c6b3babb19c502f0?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Tuesday, 27 May 2014 10:23 posted by baijianpeng

    I followed this guide today to migrate data on a Joomla 1.5 + VM 1.1.9 website, which have 18 categories and 286 products.

    However, only 9 categories and 213 products were migrated to new VM 2.0.20b.

    Why some categories and products were lost during migration?

    BTW, I must tell you that there is also JoomFish installed on this Joomla 1.5 website, it was used to translate articles and VM products to make a multi-lingual website.

    Does this guide also work for a multi-language VM 1.1.x website?

    Thank you.

  • Comment Link //www.gravatar.com/avatar/40a45fdf0b8d15cf7c26311e7a5f5405?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Tuesday, 04 November 2014 07:49 posted by Prashanth Reddy

    I migrated products, categories and users but couldn't migrate orders. Getting this error

    vmError: port Orders db error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM -- vm_orders` as `o` LEFT OUTER JOIN -- vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN -- virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL LIMIT 0,23000
    vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM -- vm_orders` as `o` LEFT OUTER JOIN -- vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN -- virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL LIMIT 0,23000

  • Comment Link //www.gravatar.com/avatar/1ce715f1e29fd3d4d1feb3b93fc03509?s=48&default=http%3A%2F%2Fwww.emanipur.org%2Fcomponents%2Fcom_k2%2Fimages%2Fplaceholder%2Fuser.png Wednesday, 01 April 2015 12:28 posted by manvi

    I have followed the procedure given above for updating my Virtuemart from 1.1.9 to 2.0.2. I installed Virtuemart 2.0.2 in my joomla1.5, But when in click in Components > Virtuemart. It gives me following error: Warning: require_once(C:\xampp\htdocs\marla/components/com_virtuemart/virtuemart_parser.php): failed to open stream: No such file or directory in C:\xampp\htdocs\marla\administrator\components\com_virtuemart\toolbar.virtuemart.php on line 37

    Fatal error: require_once(): Failed opening required 'C:\xampp\htdocs\marla/components/com_virtuemart/virtuemart_parser.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\marla\administrator\components\com_virtuemart\toolbar.virtuemart.php on line 37. Can anyone please help me with this.

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

Anti-spam: complete the task

Our Services

  • Web Design & UX Design
  • eCommerce sites
  • Social Media Marketing
  • Joomla Upgrade and troubleshooting
  • Blogging
  • Website Maintenance

Latest Offer from eManipur!

Joomla   Upgrade Your Old Joomla Website For Free*.
   For More Information click on the Link Below.

Upgrade Joomla

Drop in here

Keishamthong Elangbam Leikai,
Imphal -795001,
Manipur, India

Emanipur Location


+91 97742 70 499

Subscribe to our Tips

Receive our tips and hacks right into your Inbox. We promise you, it will be be a unique experience for you.

Receive HTML?

Social Icon
Facebook    Linked In    Gplus     Twitter