Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osCommerce-Official

How to migrate data from old osCommerce into osCommerce v4

Recommended Posts

osCommerce v4 comes with a migration tool to import data from old osCommerce 2.x and some osCommerce forks that use same or similar DB (the latter MAY work but is not guaranteed to work).

We have created a Wiki manual about how to use the migration tool:

https://wiki.oscommerce.com/index.php?title=Importing_Data_from_Older_osCommerce_Version_to_New_One

However we STRONGLY recommend using a qualified development partner to migrate data from old osCommerce.

Share this post


Link to post
Share on other sites
Posted (edited)

I am searching for this solution about my site that i want to transfer from osCommerce into osCommerce v4t i want to transfer data from old

Edited by osCommerce-Official

Share this post


Link to post
Share on other sites
Posted (edited)
2 hours ago, kamrankhan21ali said:

I am searching for this solution about my site that i want to transfer from osCommerce into osCommerce v4t i want to transfer data from old

Will PM you to discuss

Edited by osCommerce-Official

Share this post


Link to post
Share on other sites
3 hours ago, rmandiga said:

Tried with migration tool.. Not working..

Failing at OSC link

Could you please kindly pm us the errors it is showing so that we could assist you? Thank you! 

Share this post


Link to post
Share on other sites

Does the migration create a separate database or attempt to do it in-place?

Does it need access to the old source or can I load the new code and import the old database (on a different server)?

Tom


Thomas A. Moulton, W2VY

osCommerce core developer osc2.1 to osc 2.3.x

Support the developers!

http://www.oscommerce.com/about/team

Share this post


Link to post
Share on other sites

Also I am running a modified osc 2.3.2

I am not sure if I added any fields to osc tables, there may be some new tables that I would expect would be ignored...

Is there a download site that has all the historical official releases?
I'd like to do a mysqldiff on the structures to see what I might have done in the past 20 years...


Thomas A. Moulton, W2VY

osCommerce core developer osc2.1 to osc 2.3.x

Support the developers!

http://www.oscommerce.com/about/team

Share this post


Link to post
Share on other sites
20 hours ago, w2vy said:

Does the migration create a separate database or attempt to do it in-place?

Does it need access to the old source or can I load the new code and import the old database (on a different server)?

Tom

Hi Tom,

Regarding your first question after you install osc4 the new database is created and the data from the old website is imported to this new database. 

Regarding your second question it is necessary that the old website should be functional. The new functionality that allows to import to the new server is temporarily added to it. Please see the following link with the description of this import process - https://wiki.oscommerce.com/index.php?title=Importing_Data_from_Older_osCommerce_Version_to_New_One

Best regards,

Ivan 

Share this post


Link to post
Share on other sites
18 hours ago, w2vy said:

Also I am running a modified osc 2.3.2

I am not sure if I added any fields to osc tables, there may be some new tables that I would expect would be ignored...

Is there a download site that has all the historical official releases?
I'd like to do a mysqldiff on the structures to see what I might have done in the past 20 years...

Hi Tom,

We import some data from the popular extensions (such as Customer Groups), but in most cases the new tables and the fields will be ignored.

As for a download site that has all the historical official releases we are not aware of such a site but probably you can find one in the Internet.

Best regards,

Ivan

 

Share this post


Link to post
Share on other sites
22 hours ago, Ivan Holbi said:

Hi Tom,

Regarding your first question after you install osc4 the new database is created and the data from the old website is imported to this new database. 

Regarding your second question it is necessary that the old website should be functional. The new functionality that allows to import to the new server is temporarily added to it. Please see the following link with the description of this import process - https://wiki.oscommerce.com/index.php?title=Importing_Data_from_Older_osCommerce_Version_to_New_One

Best regards,

Ivan 

Yes I have been looking at that page but it does not give any background just a set of steps: DO THIS... :)

I would prefer not trying it for the first time in my production environment...

It would be helpful (for me as well as others) to know that the import process leaves the old DB unchanged

Also if moving the db offline (to a test server) what is needed besides the db, maybe the config files (./includes/configurtion.php, includes/local/configuration.php) anything else?

I know some of these questions may be answered in the process, but by then I'd hate to be fully committed on a one way street.

Tom

ps. I will look again to update my signature... I was a core dev about 20 yrs ago...


Thomas A. Moulton, W2VY

osCommerce core developer osc2.1 to osc 2.3.x

Support the developers!

http://www.oscommerce.com/about/team

Share this post


Link to post
Share on other sites
On 9/21/2022 at 8:47 AM, Ivan Holbi said:

Hi Tom,

We import some data from the popular extensions (such as Customer Groups), but in most cases the new tables and the fields will be ignored.

As for a download site that has all the historical official releases we are not aware of such a site but probably you can find one in the Internet.

Best regards,

Ivan

 

The import went ok.

I did see that the category images were copied but not the product info images, that would be a nice improvement


Thomas A. Moulton, W2VY

osCommerce core developer osc2.1 to osc 2.3.x

Support the developers!

http://www.oscommerce.com/about/team

Share this post


Link to post
Share on other sites
16 minutes ago, w2vy said:

The import went ok.

I did see that the category images were copied but not the product info images, that would be a nice improvement

I installed again and de-selected sample data import but still have the splash screen and can't see how to see the top page of the site

I only have the one sales channel, but when I click View Site it still give me the list...


Thomas A. Moulton, W2VY

osCommerce core developer osc2.1 to osc 2.3.x

Support the developers!

http://www.oscommerce.com/about/team

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×