jaicket Posted June 2, 2007 Share Posted June 2, 2007 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 Link to comment Share on other sites More sharing options...
Guest Posted June 2, 2007 Share Posted June 2, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.