Migrating data from Opencart 2.0 to 4 schema issue.

I updated the PHP version on my server and have broken my Opencart 2.0 installation. The site doesn't show anymore and I cannot access the admin portion. I have a fresh install working and I need to migrate customers, products, and other data into the install. I notice that the schema is different and I cannot seem to figure out how to migrate the data. My MySql knowledge is limited and my store is down. Any suggestion on what I need to do to get the data moved? Thanks.

OC 4 is not yet ready for production. It should not be used until ready.

You could upgrade your existing OC v.2.0.x Version to the OC v.2.3.0.3 Version linked below, to then be able to use PHP v.8.x, without the need of re-inventing the Wheel, by moving up to OC v.3.x or even the not yet production-ready V.4 Version.
https://github.com/IP-CAM/Enhanced-Open ... by-Condor2

Here are the general steps to migrate a database from OpenCart 2 to OpenCart 4:

Backup your OpenCart 2 database: Before you begin the migration process, you should always backup your OpenCart 2 database. This will ensure that you have a working backup of your data in case anything goes wrong during the migration process.

Install OpenCart 4: Install OpenCart 4 on your server and make sure it's up and running.

Modify the database structure: OpenCart 4 have different database structure than OpenCart 2. You will need to modify the structure of the OpenCart 2 database to match OpenCart 4. This may include adding or removing tables, fields or data.

Export your OpenCart 2 database: Backup your OpenCart 2 database using cpanel. This will create compressed sql file that contains all the data from your OpenCart 2 database.

Import the OpenCart 2 database into OpenCart 4: Once you have exported your OpenCart 2 database, you can import it into OpenCart 4. Make sure to choose the correct database in OpenCart 4 before importing the data.

Test your migrated database: Once the data has been imported, test your OpenCart 4 site thoroughly to ensure that everything is working as expected.

Update any customizations or extensions: If you have any customizations or extensions on your OpenCart 2 site, you may need to update them to work with OpenCart 4.

Keep in mind that this is a general guide, and the actual steps may vary depending on your specific situation. It's always a good idea to consult with us or Opencart support team to ensure a smooth and successful migration.

Database structure also need to be changed since Opencart 2 uses MyISAM whereas Opencart 4 now uses InnoDB structure.