I spent quite a while trying to import an osCommerce store into Magento 1.7.0.2 and wanted to document it somewhere relevant.
The official migration tool seems like the best free option, but it was clearly never completed or properly tested (to be fair, it is marked as Beta).
It’s still possible to get it to work, with a lot of tweaks. I was able to import categories, products, orders and customers using the method in my answer below:
3
Answers
Install the extension from http://www.magentocommerce.com/magento-connect/oscommerce-migration-tool.html, but then upgrade it with the most recent version (from 1.5 trunk) in SVN:
You should then be able to run your import following these instructions:
Good luck!
I used Magmi to import products, categories and imagesto magento.
It works pretty well and is very quick.
Imported 6500 products in under 2 mins. If you do that with the official importer it takes hours.
I like the possibility to import via a sql query that defines the datamodel instead of working with csv files.
There are some strange effects if you have utf8 chars but if you are english only, you are fine.
In response to dearlbry, (I can’t comment for lack of points, however..) I would like to point out as a helpful warning to anyone using this method, that it will send ‘subscription success’ email to customers as they import from OSCommerce. This can be extremely frustrating and cause a bit of a rift with customers if you’re not careful. More info here: enter link description here