Will Hall Online

The migration of OsCommerce user to Drupal user can be a troublesome one, largely due to the password storage within OsCommerce. Ryan from Ubercart "the osCommerce method of storing passwords involves using "salt" on the password... appending some random characters and making an MD5 of it all. You can't undo MD5 hashes to get the original password, unfortunately, and Drupal just uses an MD5 of the password itself" (http://www.ubercart.org/forum/development/1379/oscommerce_ubercart).

Following the uploading of products to one product database within phpmyadmin/mysql root, you will now have a Drupal database with a new table named 'products' within it. You can then use the table wizard module to expose the table to the migrate module and draw relationships between the 'products' and 'uc_products' database table.

I have added another little script which runs almost the same process as the migrate module, however, this may need to be edited to run successfully:

<?php
$ubercart_database = 'uberdrupal_tensor';

The difficult thing that appears with moving the products using the migrate moduel appears to be the inability to put multiple tables into one table. To counteract this I ended up migrating all ot the Oscommerce product data into one database table and then sending the content over with the migrate module. The code ended up something like this although this is obviously editable dependant on what data you have in Oscommerce/want in Drupal:

Product aggregator to take products from Oscommerce and dump into a mysql file for insertion to Drupal Database.


<?php

The process of migrating Oscommerce to Drupal Ubercart, does involve a few processes, however, the advantages are numerous. Check out http://www.ubercart.org/drupal-ecommerce and http://groups.drupal.org/node/8096 for some data about why Ubercart/Migrating from Oscommerce. Personally I feel that the codebase of oscommerce has become very outdated and is no longer running to the potential it could. Alongside this, the Drupal project is growing and Oscommerce shrinking, with a large proportion of new modules being produced for Drupal/Ubercart.