How to migrate database from osCommerce to Magento - Blog
If you want to migrate database from your osCommerce shopping cart to Magento, I recommend for osCommerce to Magento migration tool by LitExension. It makes migration process easy and quickly.
https://www.youtube.com/watch?v=0Fa68bdT0Hw
1. Preparation
For Source Store:
- Please ensure you have the right permission to upload files into your Source Store
- It must not block access from Target Store to the connector.
Source Store can operate normally during migration as it requires a very limited resource for the process.
PHP Compatibility: PHP 5.3 or later
For Target Store:
It is strongly recommended to backup Magento Target Store first
- Target Store should be placed in a stable hosting or in localhost.
- It also must not block connection to Source Store.
- Webserver (mostly apache) should have full permission to write on /media folder.
PHP Compatibility: PHP 5.3 or later.
Magento Compatibility: 1.7 or later
2. Setup
After downloading the product zip file from our Store, please extract it into a folder. The module consists of two main parts: Cart Migration Magento Module (app and skin folder) and Source Cart Connector ("magento_connector" folder)
2.1 Cart Migration Magento Module Setup
Magento Data Migration Module is a Magento Module which acts like a hub at Magento side to receive data and import it into Magento database. It can be installed just like all other Magento Modules, please follow our general Installation Guide:
http://litextension.com/docs/litexte...tion_guide.pdf
2.2 Source Cart Connector Setup
Extract Magento_connector into Source Cart root folder. After finished please make sure Migration Connector can be reached at: http(s)://yourstore.com/magento_connector/connector.php
After finished please make sure Migration Connector can be reached at: http://litextension.com/docs/litexte...tion_guide.pdf
For security, please open connector.php, find this very first line:
define('LECM_TOKEN', '123456');
And change "123456" to another string, this will be used to enter to the Migration Form (Cart Token) and acts like "password" to prevent unauthorized data access to your source store.
3. Migration
Please login your Magento Target Store backend, select Cart Migration > Migration
The migration will go through 3 simple steps. Just hit Next when you finish one step to advance.
3.1 Migration Step 1: Source Cart Configuration
Attachment 2769
Cart Type: select corresponding source cart type (OpenCart)
Cart Url: source cart full url
Cart Token: the token string which has been configured in connector.php
3.3 Migration Step 2: Migration Configuration
Attachment 2770
- Root Category: the category of current Magento store to import all source cart categories into.
- Product Attribute Set: select an Attribute Set which is used to import products, all necessary attributes in migration process will be created in to this set.
- Languages Mapping: If your Source Cart is multilingual, corresponding languages should be available in Target Magento Store. You may need to create additional languages in Magento Store to avoid data loss.
- Currencies Mapping: Assign Source Cart currencies to proper Target Magento Store currencies. Creating currencies in Target Magento Store may be needed.
- Orders Status Mapping: Assign Source Cart order statuses to proper Target Magento Store order statuses. Creating additional order statues in Target Magento Store may be needed.
- Entities to Migrate: select all entities to migrate or just a part of them.
3.4 Migration Step 3: Migration
Attachment 2771
The migration will take place automatically in this final step. In order for it to progress, you should not close your browser.
After the migration is completed, click on Clear Cache and ReIndex Data to finish. If you dont want to run it right here or it returns false here, you can do that manually in System > Cache Management and System > Index Management
4. Migration Resuming
When a problem occurring on the migration process, Cart Migration Module provide the ability to resume the process in two ways:
4.1. Automatically resume on the spot: the tool will automatically resume after a failure until all data is imported.
4.2. Manually resume: you can refresh the page to go back to Step 1 and click on Resume, this is helpful when you want to temporarily stop migration and resume when you want to.
More details: http://litextension.com/blog/how-to-...om-oscommerce/
