Migration from Miva

[MSatterwhite]

I have a new client that has been running her store on Miva. She's not happy with it and has asked me to bring up an OSCommerce store. She has a lot of data in her catalog, and it would be great if there is some way to migrate that over to OSCommerce. Even better if other data could be moved as well, but the catalog is the most important.

Has anyone here done that? Are there any tools that could help me with it. If not, what procedure would you suggest?

Thanks in advance
---Michael

[seank123]

Did just that a few months ago - it was a bloody nighmare - we have 900+ products!!

MIVAs export functions are not very good (at least those on v4.13) so I ended up using Access to load the raw database files from our server, inported them into Excel and used lookup tables to get them in the right format for OSC

The main problem was the descriptions - they had a lot of HTML in them that the 'Easy Populate' module for OSC didn't like - I ended up exporting them from Access as CSV and importing directly into the MySQL database! If your descriptions are text, then it'll be a lot easier.

I think I've still got the spreadsheets I used lying about - I'll see if I can dig them out for you.



Sean

[MSatterwhite]

Originally Posted by seank123

Did just that a few months ago - it was a bloody nighmare - we have 900+ products!!

I was afraid of that.

Originally Posted by seank123

I think I've still got the spreadsheets I used lying about - I'll see if I can dig them out for you.

I really appreciate that. I'll owe you one - and I pay my debts. [/img]

[seank123]

Unfortunatly, I've deleted them....

But it may not be as bad as I implied - we had the product descriptions in the footer area of the product info screen (don't ask...) - if your customer has them in the normal place, then you only have to work with one database (called products.dbf - on our installation it was located in \mivadata\Merchant2\00000001\ - which I think is a standard install)

Everything is in there - just use lookup tables in Excel to arrange it in the right format for Easy Populate (or, you could just cut&paste the colums manually...)

Like I said before, the main problem was the HTML in our descriptions - Easy Populate did not like it at all!

Arranging everything into categories was another problem - easiest thing to do was add them manually into Excel.

The standard Miva image directory can also be copied directly into OSCs Image directory so you won't have to change the image links.

[christiansees]

I am glad to have found this post we are now in the process of doing this. We have a miva store with 750 products and 7000 customers. Any tips that you could give on how to do this would be great.
Specifically I haven't figured out how to import the customers.
You also said

Arranging everything into categories was another problem - easiest thing to do was add them manually into Excel.

Can you give step by step instructions on this.
Thanks for giving me hope that is can be done.