Importing Data from Older osCommerce Version to New One

From osCommerce Wiki
Revision as of 15:16, 19 January 2022 by Admin (talk | contribs) (Protected "Importing Data from Older osCommerce Version to New One" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading])
Jump to navigation Jump to search

Upload the zip file provided to you to the root of your website with the older osCommerce version and unpack it there.

Image 601.png

After it is unpacked open Readme file.

Image 602.png

Read the information in this file as to how to proceed. The link highlighted in the screenshot below will be used for filling in the Base URL field in the new osCommerce version as it is described below.

Image 603.png

There are 2 ways of getting the secure key – via either command line or web.

Image 604.png

If it is done via command line copy the command line highlighted in the screenshot below.

Image 606.png

Paste this command line to get the secure key and store this key (this key will be used for filling in the Secure key field in the new osCommerce version as it is described below).

Image 607.png

If it is done via web follow the instructions in the web section of the Readme file. Editing the file and uncommenting the line #12 (deleting 2 first symbols //) should be done as follows.

Image 608.png
Image 609.png
Image 610.png


Open the page in the web browser as indicated in the Readme file. You should see the following message.

Image 611.png

Check oscb directory for secfile name.

Image 612.png

Open this file, store the secure key (this key will be used for filling in the Secure key field in the new osCommerce version as it is described below) and delete this file.

Image 613.png

Comment line #12 in the file back (add // symbols back). After that if you open the page in the web browser as indicated in the Readme file you should see the following message.

Image 614.png

After you accessed the admin area of your website with the new osCommerce version click on Products/Catalogue and Import/Export tabs. Click on Data Source tab and then on Create data source button.

Image 615.png

In the pop up window choose osCommerce 2.2-2.3 as type from the drop down list and fill in the Name field.

Image 616.png

Your data source will show up in the list. Click on wrench icon. In the pop up window fill in the Base URL field with the link from your older osCommerce version where the required data is located, fill in the Secure key field with the required key as it is described above or see readme file in oscb directory for details and choose the secure method from the drop down list (the one per the screenshot below is recommended).

Image 617.png

Click on gear icon. In the pop up window click on Add more button to add more options for import and set them up as it is shown on the screenshot below.

Note: If the whole data needs to be imported from your older osCommerce version to the new one add all the options as shown on the screenshot below otherwise add only the required options.

Note: By adding these options you replace the existing data on your new osCommerce version with the data from your older osCommerce version!

Image 618.png

Double click on your data source.

Image 619.png

The list of all the imported options will show up. Click on the Play icon next to each option to apply the data from your older osCommerce version to the new one.

Note: We would recommend to apply the data in the following order:

1. For products first apply brands, categories and product options, then products.

2. For Orders first apply customers and order statuses, then orders.

3. For taxes first apply tax zones, then taxes.

Image 620.png