Here is instruction on how to import customers, orders, categories, products and images from ZenCart or OsCommerce to Magento.
1) Install osCommerce Migration Tool
ZenCart and OsCommerce databases are equal, because ZenCart is an OsCommerce fork project.
osCommerce Migration Tool was developed by Magento Core team, you can install it from MagentoConnect here:
http://www.magentocommerce.com/magento-connect/Magento+Core/extension/114/os-commerce-import
2) Replace Run.php file with the latest version:
Replace /app/code/core/Mage/Oscommerce/Block/Adminhtml/Import/Run.php file with the latest version from the Magento repository:
For Magento 1.5.x:
http://svn.magentocommerce.com/source/branches/1.5-trunk/app/code/core/Mage/Oscommerce/Block/Adminhtml/Import/Run.php
For Magento 1.4.x:
http://svn.magentocommerce.com/source/branches/1.4-trunk/app/code/core/Mage/Oscommerce/Block/Adminhtml/Import/Run.php
For Magento 1.3.x:
http://svn.magentocommerce.com/source/branches/1.3-trunk/app/code/core/Mage/Oscommerce/Block/Adminhtml/Import/Run.php
3) Copy images
Copy all of your category and product images using FTP client into the Media > Import directory in the root of your Magento installation. Enable write permissions for all copied folders and files.
4) Create copy of the OsCommerce or ZenCart database, create Magento DB dump
Using phpMyAdmin or MySQL console tool, copy your existing OsCommerce or ZenCart database into new one.
Don't forget to create Magento DB dump as well.
5) Set up osCommerce (ZenCart) import profile in Magento
Fill in form:
- Name: name of the import profile
- IP or Hostname of the OsCommerce/ZenCart database
- DB name: name of the OsCommerce/ZenCart database
- DB username and password: password for login access to osCommerce/ZenCart database
- Prefix: prefix tables in osCommerce/ZenCart
6) Run import profile
- Click on Check Requirements to access osCommerce/ZenCart database (If successful you should now see a General Information section and import options).
- Select an existing Magento website from the pulldown menu for importing (Magento will create a store view for each of your osCommerce language packages).
- Categories: Check to import all osCommerce/ZenCart categories with tree structure
- Customers: Check to import all customer info (osCommerce/ZenCart customers will be able to use same login and password in Magento)
- Orders: Order records will be stored separate of Magento orders and will be viewable only through the customer's My account section > Order history or through the Magento admin.
Click on the "Start Running" button to begin the import (If successful you should see a chart with the total of records found, imported, and failed to import).
7) Refresh Magento Cache and view your osCommerce catalog in Magento!
I successfully imported 300 categories, 2100 products, and 3000 customers and their multiple orders from ZenCart 1.8 to Magento 1.6.2
In downloader/lib/Mage/Archive/Tar.php, the line,
replace this,
const FORMAT_PARSE_HEADER = 'a100name/a8mode/a8uid/a8gid/a12size/a12mtime/a8checksum/a1type/a100symlink/a6magic/a2version/a32uname/a32gname/a8devmajor/a8devminor/a155prefix/a12closer';
with
const FORMAT_PARSE_HEADER = 'Z100name/Z8mode/Z8uid/Z8gid/Z12size/Z12mtime/Z8checksum/Z1type/Z100symlink/Z6magic/Z2version/Z32uname/Z32gname/Z8devmajor/Z8devminor/Z155prefix/Z12closer';
Reference: http://stackoverflow.com/questions/19097292/got-an-error-in-magento-connect-for-installing-any-extension
I need your help . After importing from oscommerce to magento , all categories/products name are empty , why this problem I have ? Can anybody help me ?
Thanks
how to use this for with magento 1.9.0.1
Check the comment of Lunica on this page. Looks like it is connected with database prefix bug.