Google

Saturday, March 28, 2009

Import of ZenCart database into Magento using the osCommerce import tool

 

By following the guide in the Wiki (http://www.magentocommerce.com/wiki/creating_an_oscommerce_import_profile) and renaming the database tables. Database table names are the main issue.

Firstly, make a copy of existing Zen Cart db, then renamed all of the tables (in the copy). The reason to rename the tables was to remove the prefix (zencart_tablename renamed to tablename). Afterthat, the import tool did what it was suppose to . . . . . kind of!

Here’s what the import tool did not do: It did not import references to additional photos, so every product was imported with only its default image. No attributes were imported. Some odd characters showed up in the product descriptions, but that could be to do with character sets, not sure. The product descriptions were dumped in to both the description field and the short description field. Product and category META did not import. Product and category sort settings were dropped.

So, even after using the import tool—you will basically have to go back to every imported product and re-do. Customers and orders did import just fine, though.

Today, more and more people like a lot of the features of Magento, and it had been seriously considering migrating. However, it is not sure if it is worth the effort—yet. Zen Cart works flawlessly and it feels a lot more stable. Zen Cart is, at least in the experience, much faster than Magento.

No comments: