Migrating From An Existing Mysql Database

[jaicket]

Hi All,

 

Wondering if anyone can help. I'm trying to migrate an existing eCommerce website that I built from scratch into an osCommerce one. Although the database is not huge by anyones standards (Around 80 items), it did take a while to construct, and it would take a good few hours (if not days!) for the administrator of the website to reconstruct, so I'd rather not simply start again from the ground up.

 

Further, we kind of need the table structure to stay the same, or at least be able to edit the products table structure to suit our needs, i.e. add in ISBN, Author, Title, replace 'Manufacturer' with 'Publisher' etc etc.

 

Is there an easy way to do this?

 

I have a lot of experience with databases so I'm not frightened of writing or running SQL scripts, but I reckon it'd take a fair bit of doing to alter the database manually to accommodate these requirements, and then most probably the PHP end of osCommerce would fall flat on it's face anyway as it'd be expecting a different structure.

 

Any help is appreciated :thumbsup:,

 

Regards,

 

David

[Guest]

see if contributions like the easy populate can help in this case.

http://www.oscommerce.com/community/contributions,500

 

If there is a method from the old engine to export into csv (or using phpmyadmin) can help. Otherwise you could create a conversion script in php to read the sql tables and convert the rows for osc. The categories extra fields or products extra fields modules can help to accommodate the entries not present with the osc products table. See how these modules work. There is also an articles manager but again depends how your old structure is setup. If these are products for sale use the products tables only.