OSCommerce to CE Phoenix Migration Utility

0.6.0 Phoenix -
Mon Jul 05, 2021 6:38 pm
File size:
61 KiB
Validated for:
Phoenix -
MD5 checksum:
  • Password protect migration utility to avoid usage from third parties
  • Link to OSCommerce MySQL Database
  • Link to CE Phoenix MySQL Database
  • Link to file structure for OSCommerce Export
  • Link to file structure for CE Phoenix Import
  • Test server to make sure PHP and MySQL are setup correctly
    • Tests read/write/delete security
  • Upgrade old OSCommerce Data
    • Detects OSCommerce data version by the state of what upgrades are missing.
    • Applies upgrades to the database to upgrade OSCommerce to 2.3.4
  • Choose what data to migrate
    • Queries the OSCommerce tables and allows you to choose any tables you want to transfer, including custom tables that your mods have created
  • Check targeted tables in CE Phoenix to make sure table is empty
    • Will use the selected tables from the “Choose what data to migrate” and compare those against the target CE Phoenix tables and alert you to any required changes
  • Transfer MySQL Data Now
    • Will apply any required changes based on previous alerts in previous steps
      • All targeted tables in CE Phoenix will be emptied before being populated. There are warnings beside tables in previous steps to avoid this on some tables like “configuration” table
      • Any missing tables will be created to match the OSCommerce specs for that table
      • Any missing columns will be added to tables prior to import to make sure any custom data is not lost
    • All data from OSCommerce database will be migrated to CE Phoenix database
  • Transfer Images Now
    • All image files and folders will be migrated from OSCommerce to CE Phoenix
    • English language file for all text (Language Switch functionality to come if enough interest)
Install Instructions:
  • Clone your OSCommerce MySQL database to a new database as the data will be upgraded during the migration.
  • Make sure the Cloned OSCommerce MySQL database allows for connections from the server the utility is running on.
  • Create a fresh install of CE Phoenix on a network connected server - DO NOT INSTALL TEST DATA! If you do install the test data, the utility will remove it, but it is recommended that you do not install test data to avoid any issues.
  • Make sure the CE Phoenix MySQL database allows for connections from the server the utility is running on.
  • Unzip this utility and load the utility in your web browser.
  • Make sure that you have file path access from the server that the utility is running on, to both the CE Phoenix and OSCommerce installs. This can be done with mapped drives or mount points.
  • Recommended to be running PHP >= 7.3 on the server the utility is running on. Also make sure php output_buffering is turned on.
  • If migrating to CE Phoenix >= using this tool, make sure to set the database defaults for the following columns to 0 in your Phoenix DB orders table before migration to avoid errors. (customers_country_id, delivery_country_id, billing_country_id).
Happy Migrating

Donate to zipurman as a Thank You and to Keep the New Addons Coming!

Easily upgrade your OSCommerce store to CE Phoenix!

Change Log
  • 0.6.0 (07/05/2021)
    • Added data_type timestamp logic to migrate
    • Reworked logic for upper/lower TABLE_NAME logic throughout migrate tool to support client-side mysql settings for both import/export databases
  • 0.5.0 (06/29/2021)
    • Fixed issue with lower_case syntax in DB SCHEMA. Can still revert to lower case if needed using lower_case_table_names=2 in mysql config.
  • 0.4.0 (04/06/2021)
    • Fixed issue with logs complaining about deprecated logic (>=PHP7.4)
  • 0.3.0 (04/05/2021)
    • Fixed issue with cookie quote creating issues on php <7.3
  • 0.2.0 (03/15/2021)
    • Fixed issue with Chrome not working with samesite cookie settings
  • 0.1.20 (02/09/2021)
    • Moved some code around to fix issue for some with password cookies not working.
  • 0.1.10 (01/16/2021)
    • Fix another setting for ‘year’ datatypes (Thanks Iain)
  • 0.1.9 (01/15/2021)
    • added a setting for bypass_password in the header.php. Set that to 1 to allow no password
    • Added ‘year’ as a datatype to catch nulls
  • 0.1.8 (12/19/2020)
    • Added extra scema to sql migration to avoid issues with matching table names in other databases on the same server using the same user/pass. (Thanks vmn)
  • 0.1.7 (11/30/2020)
    • fixed cookie code to better handle php versioning and SSL/NON-SSL
  • 0.1.6 (10/12/2020)
    • added YouTube How-To Video
    • fixed some caching issues by disabling browser caching using php headers
    • added db schema to avoid anything else being visible from other accessible database tables (Thanks vmn)
  • 0.1.5 (10/11/2020)
    • fixed issue with bypassing setting a password if initial load defined a step
    • fixed logout bug due to 0.1.4 change to cookie
  • 0.1.4 (10/10/2020)
    • fixed issue with mysql password toggle
    • corrected cookie issue with samesite warning
  • 0.1.3 (10/09/2020)
    • added password hiding options on database fields
    • added alerts if php/mysql not sufficient version
    • added warning if output_buffering is turned off as large datasets should use output_buffering to watch migration as it progresses
    • added link to YouTube channel – demo coming soon
  • 0.1.2 (09/30/2020)
    • corrected issue with transfer of images when folder depth > 1
    • corrected issue with transfer of database if enum, blob, mediumtext, and some others were imported
    • corrected issue for creating tables with multiple columns in primary key
  • 0.1.1 (09/29/2020)
    • Corrected error being caused in some setups by file_get_contents
    • Corrected some php alerts that were being logged and may have caused fatal stops depending on server error settings
  • 0.1.0 (09/23/2020)
    • Initial Release
Screen-Shot-2020-09-23-at-1.16.29-P.png Screen-Shot-2020-09-23-at-3.07.00-AM.png Screen-Shot-2020-09-23-at-3.06.44-AM.png Screen-Shot-2020-09-23-at-3.06.26-AM.png Screen-Shot-2020-09-23-at-3.06.15-AM.png Screen-Shot-2020-09-23-at-3.06.03-AM.png Screen-Shot-2020-09-23-at-3.05.55-AM.png Screen-Shot-2020-09-23-at-1.24.21-PM.png Screen-Shot-2020-09-23-at-1.17.05-PM.png Screen-Shot-2020-09-23-at-1.16.40-PM.png
  • Addon Revisions/Downloads
    Phoenix Version(s)