Migrating from J1.5 VM directly to J3.3 Hikashop?

Is it possible to directly migrate from an old J1.5 install of Virtuemart (1.1.5) up to a new site running on Joomla 3.3 and the newest version of Hikashop? If so what is the upgrade path to do it? I tried copying over the DB tables from the old site to the new then running the import as was suggested on a forum post here. That didn't work.

I also tried exporting a CSV from the old site using CSVI. I was able to import that CSV in and I can see all the items but it did not bring in the prices or images nor did it store the items in categories.

What is the proper way to migrate from such an old version of VM over to Hikashop?

Old site temp URL is : regional-supply.com/index.php/vmchk.html

New site temp URL is: www.straightarrowhosting.net/~sawstemp/r...for-products-listing

-- PHP version -- :5.4
-- Browser(s) name and version -- : Chrome

I have a similar problem. After spending hours in vain trying to do a similar migration yesterday, I posted a question but have yet to hear from anyone. How did you succeed in importing the CSV? I wasn't even able to do that and only got multiple error messages. Did you import the CSV as is, or did you modify it before importing into your new site?
Andre

I did as you suggested and actually managed to get it going this time. I think the problem for me was that the Next link during each part of the transfer from VM was very small and the first time I tried it I honestly did not realize that there was more than one step to the process. I wasn't expecting to have to hit Next seven or eight times in order to complete the conversion. It's not a complaint really, but I'd put in a suggestion to make those links larger and maybe explain on the first page of the transfer that there are multiple steps. Plus on each page of the transfer it kept putting the start page of the migration at the bottom of the page.

Anyway, thank you for the help on that part of this project.

I do have one followup question to all this though. The transfer did not seem to do anything with the images. Every image for every product and category is just the plain barcode image. Can I import the old images somehow?

I think the problem for me was that the Next link during each part of the transfer from VM was very small and the first time I tried it I honestly did not realize that there was more than one step to the process. I wasn't expecting to have to hit Next seven or eight times in order to complete the conversion.

Ah! Thank you maestroc! Exactly the same thing happened to me. I thought the VM import was doing nothing, and I didn't even notice that HS was prompting me to move through several other steps, because the first two pages look almost exactly the same. I strongly suggest to the Hikashop development team to redesign the pages so that they display more clearly the steps on how to proceed.

In any case, problem solved!

I copied over the media/hikashop/upload directory from the old site to the new Joomla 3 site. All of the category images work properly now but the individual item images do not. Any idea why that would be? Are they stored elsewhere or controlled in some other way?

In looking at the old 1.5 site it does not appear that Hikashop imported the image paths for the individual items. It did so for the categories but not the products.

If you could check in your database ; try to link table hikashop_product with the hikashop_file using file_red_id & product_id, and tell me if your product have the correct file_path associated.

Uhh... That went a little over my head. I know the basic idea of what you are suggesting but I don't have a clue how to do it. I could provide a login and the site has Adminer installed to allow access to the DB. Let me know via PM if that is something you would be interested in doing. Otherwise if you can just give me the SQL query written out I can run it myself.

Replace # by your prefix.

Thank you!

I ran the query:

SELECT b.product_name, a.file_path FROM `mpx_hikashop_file` a INNER JOIN `mpx_hikashop_product` b ON a.file_ref_id = b.product_id WHERE a.file_type = 'product'

and it seemed to run successfully (partial output shown below, no error messages):

product_name
file_path
WorldWide Electric Worm Gear Reducer-Flange Input,...
WorldWide_Electr_4cf3f9dbc302d.jpg
WorldWide Electric Worm Gear Reducer-Flange Input,...
WorldWide_Electr_4cf3fcae639f7.jpg
WorldWide Electric Worm Gear Reducer-Flange Input,...
WorldWide_Electr_4cf4034e1c447.jpg
WorldWide Electric Worm Gear Reducer-Flange Input,...
WorldWide_Electr_4cf401fcf307f.jpg

Those files are currently sitting in the media/com_hikashop/upload folder. Should they be in a different place?

Well, it looks all good to me. Files are in the right folder, and associated to the right products...

But I recently made some changes on the images import for VM 1, so just to be sure, try to replace your administrator/components/com_hikashop/helpers/importvm.php file by the one attached to this post, and try to import again from a clean installation (without any previous import made). Images should be imported. If not, send me via mp your access (website backend, FTP, database), so I can try by myself and see what's going on.

I tried with the new file you attached but it gave me a blank screen. I rolled it back to the importvm.php file that ships with the version now available on your site and ran the import again just to see what would happen. I'm getting a few file not found errors on step 4, but when it imports the products I get lots of file not found errors that refresh so quickly that I can't really stop to read them all.

Because of this I think the image issue may be something that is not Hikashop related (many of the images seem to be missing from the old VM installation). But I now have another possibly related concern to this migration. I will ask that question in a different thread, and for now I will leave this one for later.

Thank you for your help with this.