Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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.

Link to comment
Share on other sites

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
Link to comment
Share on other sites

  • 4 months later...
  • 1 month later...

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

Link to comment
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

Link to comment
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 

Link to comment
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

 

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

  • 4 weeks later...
  • 6 months later...

Does anyone here know whether osc4 incorporates the Extra Products Fields contribution to old osCommerce 2.x ?

Our site www.abbeybook.com uses EPF as an essential feature which we would need to maintain if we migrated to new osc4.

Thanks in advance for advice anyone here can offer ...

John

Link to comment
Share on other sites

On 5/2/2023 at 1:46 PM, acropolis said:

Does anyone here know whether osc4 incorporates the Extra Products Fields contribution to old osCommerce 2.x ?

Our site www.abbeybook.com uses EPF as an essential feature which we would need to maintain if we migrated to new osc4.

Thanks in advance for advice anyone here can offer ...

John

It is possible to add multiple Properties to products. Hopefully you will find it useful and will be able to move to the new version of osCommerce 

Link to comment
Share on other sites

  • 7 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...