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 used this link to download run.php:
http://svn.magentocommerce.com/source/branches/1.5-trunk/app/code/core/Mage/Oscommerce/Block/Adminhtml/Import/Run.php
Any ideas as to how to get thumbnails sorted - without having to go through nearly a thousand products updating the image info?
Make sure that Zen/OsCommerse database tables are without prefixes.
Seems that it is reason of the issue.
Try to clear Magento cache.
I am using magento ver1.4, I have installed the module via magento connect but it is not showing in the admin.
can anyone has rectified this?
Refreshing cache, running cron, but still no OsC link in Import/Export tab.
What is wrong?
(Magento 1.3)