Upgrading from 2.2.0.0 to 3.0.3.9

Hello, I'm planning to upgrade to the latest 3.0.3.9 version if that is recommended.

I have looked at Opencart's document on Updating from 2.x.x to 3.0.x. Would that be the best way to upgrade? It seemed to be most straightforward. Let me know what I should look out for.

Thanks in advance

Do a fresh install of OC 3.0.3.9, the built-in upgrade almost always fails.

JNeuhoff wrote: ↑

Mon Mar 25, 2024 3:28 am

Do a fresh install of OC 3.0.3.9, the built-in upgrade almost always fails.

Fair enough. I have seen the Export/Import tool, and if I understand correctly, I should use Export/Import for Opencart version 2.2 (to export) and another tool for version 3.0 (to import).

barnettgs wrote: ↑

Mon Mar 25, 2024 5:35 pm

Fair enough. I have seen the Export/Import tool, and if I understand correctly, I should use Export/Import for Opencart version 2.2 (to export) and another tool for version 3.0 (to import).

Yes, using the Export/Import tool will help you with this. See also our FAQ, the formats may slightly vary between the old and new sites.

JNeuhoff wrote: ↑

Mon Mar 25, 2024 7:56 pm

barnettgs wrote: ↑

Mon Mar 25, 2024 5:35 pm

Fair enough. I have seen the Export/Import tool, and if I understand correctly, I should use Export/Import for Opencart version 2.2 (to export) and another tool for version 3.0 (to import).

Yes, using the Export/Import tool will help you with this. See also our FAQ, the formats may slightly vary between the old and new sites.

Thanks.

Since SEO differs between OC v2.0 and v3.0, can SEO be exported to v3?

barnettgs wrote: ↑

Tue Mar 26, 2024 12:08 am

Since SEO differs between OC v2.0 and v3.0, can SEO be exported to v3?

Yes, SEO can be copied over, too. There are new worksheets for this, e.g. ProductSEOKeywords or CategorySEOKeywords.

Thank you. I'm trying it out on Opencart 2.2, and it seems that I need to export each data set in the correct order, starting with Categories, then Products, and then Options, etc.

It has to be followed in the same order when importing as well?

barnettgs wrote: ↑

Tue Mar 26, 2024 4:55 am

Thank you. I'm trying it out on Opencart 2.2, and it seems that I need to export each data set in the correct order, starting with Categories, then Products, and then Options, etc.

It has to be followed in the same order when importing as well?

Please read our FAQ.

Thanks. I read the FAQ and got it; I was wondering where the instruction manual is, but it's in the FAQ.

Does it export Geo Zones? I have looked at the files, and I do not see them.

I guess Geo Zones need to be added separately or used with Opencart's own export tool just for one table?

barnettgs wrote: ↑

Fri Mar 29, 2024 6:57 pm

Thanks. I read the FAQ and got it; I was wondering where the instruction manual is, but it's in the FAQ.

Does it export Geo Zones? I have looked at the files, and I do not see them.

I guess Geo Zones need to be added separately or used with Opencart's own export tool just for one table?

You will have to redefine the geo-zones manually. There have been many changes to the underlying countries and zones since OpenCart 2.2.0.0.

Thanks, I exported them from 2.2 and 3.0; there are differences in the countries' IDs, and the 3.0 version has a few more entries, so it is not worth the risk. I decided to make new ones in 3.0.

As an experiment, I tried Opencart's upgrade method in another folder with another copy of the database of Opencart 2.2. The upgrade actually went through fine, and everything is working, but the extension store doesn't load at all, and the number of tables in the database has increased to 153.

The fresh install of 3.0 I'm currently working on has just 136 tables, which only increased by three to 139 once I installed two extensions—the same extensions as the old store. So clearly, there were an extra 14 tables lying around, including the URL table (for SEO) leftover from Opencart 2.2 (and possibly from the previous upgrade from 1.5 back in 2017).

I have just noticed that there are no customers' orders list. Can these be imported into the new server?

You'd have to use PHPMyAdmin for copying customers orders from the old to the new database.

No problem I got the error importing product data:
I have looked into the formats and double-checked everything; what could have caused it? There is no space etc.

barnettgs wrote: ↑

Thu Apr 04, 2024 7:42 pm

No problem I got the error importing product data:

Code: Select all

2024-04-04 11:41:04 - Export/Import: Undefined option_value_name 'Yellow/10' for option_name 'Battery Type' used in worksheet 'ProductOptionValues'!

I have looked into the formats and double-checked everything; what could have caused it? There is no space etc.

Got it fixed. It was caused by a space in another table which is the Options