Upgrade from 1.5.5.1 to 3.0.4.0

Hello

I'm looking to upgrade from 1.5.5.1 to 3.0.4.0, I was planning on using Excelport that I purchased but that seems to have been a waste of money since it doesn't work.

So here's what my plan is, please tell me if you see any faults.

Old site is mysite.com/store
New site will be mysite.com/oc3

The plan is to setup the new store layout as I want, then import the products, categories, etc. using the Import/Export tool and I read up on that and it seems like that will work for what I need.

Then, I figured I could just re-name mysite.com/store to mysite.com/oldstore and then rename the mysite.com/oc3 to mysite.com/store (after updating the catalog and admin config files). And checking my htaccess file to update any site specific things there (if any)

Will that work fine?

Also, I didn't see how to bring over customer data (like order history etc). I read that the databases between the two versions are very different, so I get that I can't just backup the old one and import it as the new (OpenCart 3.x) database.

But how would I copy over the sales history and order history? I found a post where someone said there are posts describing how to do that process, within the database (I guess copying tables and importing them to the new DB), but I can find any of those posts. Maybe I'm using the wrong search terms? Does anyone have a link to a thread on that topic?

As you correctly pointed out, there will be some DB tables to be copied over to your new database which aren't covered by the Export/Import tool. Your best bet is to use PHPMyAdmin export and import for these DB table, you could use CSV formats for these exports and edit them to fit the required formats of the corresponding new DB tables.

JNeuhoff wrote: ↑

Tue Aug 12, 2025 6:15 pm

As you correctly pointed out, there will be some DB tables to be copied over to your new database which aren't covered by the Export/Import tool. Your best bet is to use PHPMyAdmin export and import for these DB table, you could use CSV formats for these exports and edit them to fit the required formats of the corresponding new DB tables.

Thank you. But how do I find out which tables I need to export and import over to the new db?

I'm mainly concerned about the customers, their information, their passwords (so they can login like nothing changed), and order/sales history.

I have seen that with your export/import tool I can copy over many things (like products & categories), but in all the threads I've read nobody seems to mention if it works with those database items I mentioned or if there is another required method.

I'm okay copying and pasting tables from the old db to the new db, but I just don't know what things to bring over exactly. And for example, do I just copy the "oc_customer" table and import it in the place of the new db "oc_customer" table? Or are there internal structure differences between the old and new version of those tables?

There will be internal structures for the tables for example oc_customer will need information for order, etc.

If you don't know how to do it better place a post in commercial section of the froum and can have a bid for this tedious task.

khnaz35 wrote: ↑

Tue Aug 12, 2025 7:39 pm

There will be internal structures for the tables for example oc_customer will need information for order, etc.

If you don't know how to do it better place a post in commercial section of the froum and can have a bid for this tedious task.

Yes, I'm aware there are internal structures for the tables. That is not what I'm referring to.

What I am asking is:

• What tables get exported (from the old/current db) and imported (into the new db) or where can I find a list posted somewhere

• Is the internal structure of those tables the same from the current db (oc v 1.5.5.1) as the new db (oc v3.0.4.0)?

For example, if I need db table "oc_customers" copied over, can I just export that as it is and import it into the new db under "oc_customers"? Or has something internally changed (been renamed, relocated, etc) within the new db when compared to the old db tables?

You know what I mean?

The easiest and fastest solution will be you install a demo store for both opencart versions and compare them side by side for your needs.

You can also take a look into the source code and see how tables are being created.

Not sure if there is a readily list available for your case. Feel free to share back here after findings.

khnaz35 wrote: ↑

Tue Aug 12, 2025 8:59 pm

The easiest and fastest solution will be you install a demo store for both opencart versions and compare them side by side for your needs.

I have already created a live test site:

Current/live site is (OC v 1.5.5.1) = mysite.com/store

New (test) site is mysite.com/oc3 (fresh install with new separate db of course)

khnaz35 wrote: ↑

Tue Aug 12, 2025 8:59 pm

Not sure if there is a readily list available for your case.

Don't people use specific db tables for migrating over customer data (names, address's, login's, pw's) and sales history, to new versions of Opencart?