News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

[SOLVED] Migrating products from Joomla 1.5 to 2.5

Started by sui_page, July 16, 2013, 10:13:54 AM

Previous topic - Next topic

sui_page

I've exported then imported the following files from my old Joomla 1.5 site to the newer 2.5 version:

  • CSVI Category details export
  • CSVI Multiple Prices export
  • CSVI Product Export
  • CSVI Product files export
However I'm getting the following error when I try to import the CSVI Google Base Export XML file – 'Cannot load the configuration fields. There is a problem with the import file'

That's not my concern though. Basically the products and categories are showing but 1. the products aren't being linked to any of their respective categories 2. None of the product images are showing up even after moved them from their old folder 'com_virtuemart/shop_image/product' to 'images/stories/virtuemart/product'. This is why I want to import the file above^ as I i believe it will solve my problems. Cheerio

jenkinhill

Migration of Virtuemart 1.1 to 2 is best managed using the inbuilt script. VM2.0.22a has an enhanced migrator. For a howto see http://docs.virtuemart.net/tutorials/30-installation-migration-upgrade-vm-2/77-upgrading-vm1-to-vm2.html

CSVI issues should be posted on the CSV forum at http://csvimproved.com
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Yesceeohhh

Install latest virtumert version. Latest version have default migration option. So you can use that migration option. Consider the below steps:

1. In old virtumart table present in new version, don't change prefix.
http://www.usjoomlaforce.com/joomla-ecommerce-service.html --> Build Your Ecommerce Store!
http://www.ticktechpros.com --> Build Ticket Website

AH

Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!
Regards
A

Joomla 3.10.11
php 8.0

sui_page

Quote from: Hutson on July 18, 2013, 21:47:55 PM
Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!

Thanks for the link, I also found http://www.ostraining.com/blog/joomla/virtuemart-11-to-version-2 tutorial. I'll let you know guys know how it goes. cheers

sui_page

Quote from: Hutson on July 18, 2013, 21:47:55 PM
Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!

So I've searched various migration methods and haven't been found what I'm looking for. What I'm trying to do is move all VM products from a Joomla 1.5 site to another website with Joomla 2.5. I can't simply migrate via the various upgrade methods I've seen as all the products and images need to be moved to the other site

AH

So if you already have a Joomla 2.5 site and want to move your VM prods etc over to it:-

(Luckily that is how I want to do it and what I have tested  8) )

Procedure:-

1.      Install virtuemart and VM AIO on the new site
2. Move your media into images/stories/virtuemart and make sure they're in the right subfolders. (category, manufacturer, product, vendor)
3. Move all the old  VM database tables to your new Joomla database  (copy/rename them to the databse folder) ensure they are named newprefix_vm_tablename
4. Enable The "Enable database Update tools" in Virtuemart Configuration
5. Go to Tools/Tools & Migration "Migration" Tab
6. Choose "Everything" and click "Start Migration"

Voila!

Regards
A

Joomla 3.10.11
php 8.0

sui_page

Quote from: Hutson on July 20, 2013, 14:09:36 PM
So if you already have a Joomla 2.5 site and want to move your VM prods etc over to it:-

(Luckily that is how I want to do it and what I have tested  8) )

Procedure:-

1.      Install virtuemart and VM AIO on the new site
2. Move your media into images/stories/virtuemart and make sure they're in the right subfolders. (category, manufacturer, product, vendor)
3. Move all the old  VM database tables to your new Joomla database  (copy/rename them to the databse folder) ensure they are named newprefix_vm_tablename
4. Enable The "Enable database Update tools" in Virtuemart Configuration
5. Go to Tools/Tools & Migration "Migration" Tab
6. Choose "Everything" and click "Start Migration"

Voila!

This method looks very promising but I just need some clarification on this – the databases look quite different on the different Joomla versions. Should I be changing the 'vm' prefix to 'virtuemart' as well? Even some of the fields are name diffrelnty for example 'country' and 'countries. Is this something the VM migration will sort out?

AH

Yes this method should work for you based on they way you are wanting to migrate!

The old VM1 tables should only have the joomla dbprefix changed to match the new joomla dbprefix

The vm_xxx remains the same so if old joomla prefix is dog and new joomla prefix is cat

dog_vm_product.xxx  becomes cat_vm_product.xxx

You can mass rename using a great piece of freeware- Bulk Rename Utility

http://www.bulkrenameutility.co.uk/Download.php

Migration
When the migration takes place the data is copied to the relevant new tables with the dbprefix_virtuemart_newtable

The old VM tables remain in the database unchanged for you to review or re-try failed migrations or timeouts
Regards
A

Joomla 3.10.11
php 8.0

sui_page

Quote from: Hutson on July 20, 2013, 15:39:39 PM
Yes this method should work for you based on they way you are wanting to migrate!

The old VM1 tables should only have the joomla dbprefix changed to match the new joomla dbprefix

The vm_xxx remains the same so if old joomla prefix is dog and new joomla prefix is cat

dog_vm_product.xxx  becomes cat_vm_product.xxx

You can mass rename using a great piece of freeware- Bulk Rename Utility

http://www.bulkrenameutility.co.uk/Download.php

Migration
When the migration takes place the data is copied to the relevant new tables with the dbprefix_virtuemart_newtable

The old VM tables remain in the database unchanged for you to review or re-try failed migrations or timeouts

This worked flawlessy, you're a lifesaver. Thanks so much!  ;)