OsCommerce upgrade to OsCMax

[BrandonScottishRegalia]

Can it be done? we have a oscommerce store now and wanted to know if you can upgrade to oscmax. Probalem is already have a database full of products can that be transferred over to the oscmax?

Not sure where to post this so will post here and in oscmax installion help too.

sorry if did anything wrong.

[jpf]

Yes.....and......no.

EZPopulate is built into MAX and can be added to OSC - export from OSC and Import into MAX.

Easy - no! Could it be done - with work - yes. There is SO much added functions into MAX - that a dozen or so feilds in OSC - In MAX - there is Several Dozen - depending on options....

If you look at a single item exported from OSC. Then manually create the same item in MAX with all options that the original has, then export it. Compare the two to see how much work needs to be done. If you have say only 100 items. Reenter them might be a better/faster/less fuss way. If you have 1000s then export/import you want to do.

[michael_s]

It is not too hard if you are experienced with both php and mysql. If you know what you are doing, it takes about an hour to two, depending on your speed at getting things done.

It is not technically an upgrade though. Consider it a migration to a similar platform and you will have an easier time grasping the changes.

The right tools are very important. mysqldiff or other database diff tool is required to do a proper migration, moving customers, orders, products, categories, addresses, etc (not just products/categories via easypopulate).

What you need to do is the following:

Template migration:
1. If your site has a custom design, you will want to migrate that to osCMax first (before the data), so that when you move the data, you are ready to go live. I will not go into the details on how this is done here. Read my BTS template tutorials:
BTS Template Tutorial, Examples, converting osC template to BTS

Migrating the database:
1. Make a copy of your database, then run mysqldiff on the copy, against the osCMax database structure. This will output the sql that needs to be added to the copy to match the osCMax structure.

2. Run that sql on your copied database. Now you have a structure that matches osCMax.

3. Next export the data from the product, order, categories, customer, addressbook tables. Do not export the admin or configuration tables. They cannot be used in the new osCMax database.

4. Import that data to the stock oscmax database. That concludes the data migration to the new site.