How to migrate from OpenCart 1.5.1.3+ to OpenCart 2.x with ExcelPort

ExcelPort by iSenseLabs is an excellent tool if you have just upgraded your OpenCart store and need a way to transfer your data from your old OpenCart 1.5.1.3+ store to your shiny new OpenCart 2.x.

Follow this step-by-step tutorial to learn how to do it. Let’s go!

Requirements for the old OpenCart 1.5.1.3+ store:

• A running installation of the latest ExcelPort 1.x (be careful not to install ExcelPort 2.x) Please make sure to upgrade to the latest available version of ExcelPort 1.x.

Requirements for the new OpenCart 2.x store:

• A running installation of the latest ExcelPort 2.x (be careful not to install ExcelPort 1.x) Please make sure to upgrade to the latest available version of ExcelPort 2.x.

Important: This tutorial assumes that your new store is a fresh installation of OpenCart. If your new store is already populated with Products, Categories, Options, Attributes, Attribute groups, Customers, Customer groups, Manufacturers, Coupons, Gift Vouchers and Orders, following this tutorial WILL delete this information in order to successfully import your data.

Important: This tutorial divides the migration progress in three main stages, which should be followed consecutively:

1. Migrating products
2. Migrating customers
3. Migrating orders

The idea is to not migrate your orders before you have first migrated your customers and products.

Note: if you wish to migrate only your products, you can follow only Stage 1.

Note: If you wish to migrate only your customers you can follow only Stage 2, skipping Stage 1.

This tutorial assumes that you are already familiar with the interface of ExcelPort. If not, feel free to click around our ExcelPort demo page to get acquainted:

http://excelport.demo.isenselabs.com/admin (user: demo pass: demo)

STAGE 1: MIGRATING PRODUCTS

To migrate your products, you will first need to migrate the Categories, Attributes, Attribute Groups, Options, Customer Groups and Manufacturers.

Here is a video tutorial, which explains the full product migration:

In your old website visit:

Admin > Extensions > Modules > ExcelPort 1.x [Edit] > Export

… and do separate exports of:

1. Categories
2. Customer Groups
3. Attributes and Attribute Groups
4. Options
5. Manufacturers
6. Products (make sure to export in Bulk mode)

Next, in the OpenCart 2.x website, go to:

Admin > Extensions > Modules > ExcelPort 2.x [Edit] > Import

Mind the checkboxes above the “Import Data” button. Before doing your imports, please make sure to check the checkbox “Delete the entries before doing the import”

This will tell ExcelPort to first delete your existing data, after which it will do the import. Do separate imports in the following order:

1. Categories
2. Customer Groups
3. Attributes and Attribute Groups
4. Options
5. Manufacturers
6. Products

If you wish to migrate customers and orders, you can move to the next stages. Otherwise, you can skip to the end of the article.

STAGE 2: MIGRATING CUSTOMERS

Important: Note that OpenCart have changed the encryption of the passwords after version 1.5.4.1. This means that if you transfer customers between a version of OpenCart, older than 1.5.4, and 1.5.4.1 – 2.x then the passwords will not work and the customers will need to use the “Forgotten password” feature. The passwords will work just fine if you transfer between OpenCart 1.5.4.1+ and OpenCart 2.x.

To migrate your customers, you will first need to migrate the Customer Groups.

Here is a video tutorial, which explains the full customers migration:

In your old website visit:

Admin > Extensions > Modules > ExcelPort 1.x [Edit] > Export

… and do separate exports of:

1. Customer Groups (you can skip this export if you have already done it in the previous Stage)
2. Customers

Next, in the OpenCart 2.x website, go to:

Admin > Extensions > Modules > ExcelPort 2.x [Edit] > Import

Mind the checkboxes above the “Import Data” button. Before doing your imports, please make sure to check the checkbox “Delete the entries before doing the import” This will tell ExcelPort to first delete your existing data, after which it will do the import.

Do separate imports in the following order:

1. Customer Groups (you can skip this import if you have already done it in the previous Stage)
2. Customers

STAGE 3: MIGRATING ORDERS

If you have not already followed Stage 1 and Stage 2, please do it now.

Here is a video tutorial, which explains the migration of the orders:

In your old website visit:

Admin > Extensions > Modules > ExcelPort 1.x [Edit] > Export

Now Export your:

1. Coupons
2. Gift Vouchers
3. Orders

Next, in the OpenCart 2.x website, go to:

Admin > Extensions > Modules > ExcelPort 2.x [Edit] > Import

Mind the checkboxes above the “Import Data” button. Before doing your imports, please make sure to check the checkbox “Delete the entries before doing the import” This will tell ExcelPort to first delete your existing data, after which it will do the import.

Now Import your:

1. Coupons
2. Gift Vouchers
3. Orders

CONCLUSION

Congratulations! You have successfully migrated your store. If you have any questions, feel free to open up a thread in our community forums https://isenselabs.com/forum, or in our support system https://isenselabs.com/users/support.