How to import osCommerce store into Magento 1.7.0.2

dearlbry picture dearlbry · Nov 14, 2012 · Viewed 7.8k times · Source

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:

Answer

dearlbry picture dearlbry · Nov 14, 2012

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:

svn co http://svn.magentocommerce.com/source/branches/1.5-trunk/app/code/core/Mage/Oscommerce/ Oscommerce

You should then be able to run your import following these instructions:

  • Back up your database
  • Copy all your osCommerce product images into media/import (and make them writable by the webserver)
  • VERY IMPORTANT: Change the language for the admin interface to English (United States) - or no products will appear even after a succesful import. You can switch it back afterwards
  • Set up your import profile (from System > Import/Export > osCommerce)
  • Click on Run Profile on the left, and then the "Check Requirements" button
  • If you only have one store/website, the Website Code field will be "base".

Good luck!