Magento – Best way to migrate from opencart 1.5.3 to magento 1.9

magento-1.9migration

Hi Magento Developers ,

I have a opencart website with,

60 products
555 Orders
1837 Customers

I'm in need to migrate entire opencart to magento, so far i've done the fronted theme. Now the biggest issue I’m facing is with database migration for products, orders, customers.

I've googled a bit and found some of solutions,

http://www.shopping-cart-migration.com/ An expensive premium service
Manually creating and mapping all together. (An time taking process but not sure whether this will work or not)

So do you guys have any other way to solve this database migration from opencart to magento ?

Please share your ideas.

Best Answer

The most cost effective way would be to simply not worry about your old orders and just import customers and products.

If you do need orders there are a couple of modules that will import orders, at least one that is free. The process is fairly slow and you have to set it up.

If you want everything all at once I would recommend using Cart2Cart. It is quick, effective and easy to use.

Related Solutions

Magento – Best way to upgrade Magento from 1.4.2 to 1.9

You can do a direct upgrade, you do not have to do an incremental upgrade

Here is the procedure:

Backup your database from your current 1.4 site.

Example:

mysqldump -u<user> -p -h<host> database > yourdumpfile.sql

Now restore your file to a NEW database

mysql -u<user> -p -h<host> new-db < yourdumpfile.sql

Now point your fresh version of Magento CE 1.9 at your NEW db and it will upgrade you to that version.

Depending on your file size it should not take more than 5-40 minutes. (This is dependant on the amount of orders you have.

Clear your log tables before you do your upgrade.

Now all your data is in the new version of Magento!

Magento – Migrate only orders in magento 2 from Magento 1.9 using thesqlworkbench

I think we should map some more tables:

Magento 1                     || Magento 2
sales_flat_order                 sales_order
sales_flat_order_address         sales_order_address
sales_flat_order_grid            sales_order_grid
sales_flat_order_item            sales_order_item
sales_flat_order_payment         sales_order_payment
sales_flat_order_status_history  sales_order_status_history

If we had the invoices and shipments, we need to map more tables.

Note: when we want to clear the order from Magento 2, we can use this module.

Best Answer

Related Solutions

Magento – Best way to upgrade Magento from 1.4.2 to 1.9

Magento – Migrate only orders in magento 2 from Magento 1.9 using thesqlworkbench

Related Topic