Importing Data from Older osCommerce Version to New One: Difference between revisions

From osCommerce Wiki
Jump to navigation Jump to search
m (Protected "Importing Data from Older osCommerce Version to New One" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading])
No edit summary
Line 1: Line 1:
'''Upload''' the '''zip''' file provided to you to the '''root''' of your website with the '''older''' osCommerce version and '''unpack''' it there.  
'''Extract''' the archived file into the '''root''' of your website with the '''older''' osCommerce version. This will create a "oscb" directory. We highly recommend to rename this directory for security reasons (e.g. your_directory).  
[[File:Image 601.png|none|frame]]
[[File:Image 635.png|alt=|none|frame]]
After it is unpacked open '''Readme''' file.
[[File:Image 634.png|none|frame]]
[[File:Image 602.png|none|frame]]
[[File:Image 636.png|none|frame]]
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.
[[File:Image 637.png|none|frame]]
[[File:Image 603.png|none|frame]]
Read the information in the Readme file as to how to proceed.  
There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''.  
[[File:Image 642.png|none|frame]]
[[File:Image 604.png|none|frame]]
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.
If it is done via '''command line''' '''copy''' the command line highlighted in the screenshot below.
[[File:Image 638.png|alt=|none|frame]]
[[File:Image 606.png|none|frame]]
There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''.
'''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).  
[[File:Image 639.png|alt=|none|frame]]
[[File:Image 607.png|none|frame]]
If it is done via '''command line''' '''copy''' the command line highlighted in the screenshot below.  
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.
[[File:Image 640.png|alt=|none|frame]]
[[File:Image 608.png|none|frame]]
'''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).
[[File:Image 609.png|none|frame]]
[[File:Image 641.png|alt=|none|frame]]
[[File:Image 610.png|none|frame]]
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.  
 
[[File:Image 643.png|alt=|none|frame]]
 
[[File:Image 644.png|alt=|none|frame]]
[[File:Image 645.png|alt=|none|frame]]
[[File:Image 646.png|alt=|none|frame]]
[[File:Image 647.png|none|frame]]
'''Open''' the page in the web browser as indicated in the '''Readme''' file. You should see the following message.
'''Open''' the page in the web browser as indicated in the '''Readme''' file. You should see the following message.
[[File:Image 611.png|none|frame]]
[[File:Image 648.png|alt=|none|frame]]
'''Check''' oscb directory for '''secfile''' name.
'''Check''' oscb directory for '''secfile''' name.
[[File:Image 612.png|none|frame]]
[[File:Image 649.png|alt=|none|frame]]
'''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.
'''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.
[[File:Image 613.png|none|frame]]
[[File:Image 650.png|alt=|none|frame]]
[[File:Image 651.png|none|frame]]
'''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.
'''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.
[[File:Image 614.png|none|frame]]
[[File:Image 614.png|none|frame]]
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.
After you accessed the admin area of your website with the '''new''' osCommerce version click on '''Products/Catalogue''', '''Import/Export''' and '''Data Source''' tabs. The '''import from Oscommerce 2x''' has already been set up.
[[File:Image 615.png|none|frame]]
[[File:Image 652.png|alt=|none|frame]]
In the pop up window choose '''osCommerce 2.2-2.3''' as '''type''' from the drop down list and fill in the '''Name''' field.
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''').
[[File:Image 616.png|none|frame]]
[[File:Image 653.png|alt=|none|frame]]
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''').
[[File:Image 617.png|none|frame]]
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!
[[File:Image 618.png|none|frame]]
'''Double click''' on your data source.
'''Double click''' on your data source.
[[File:Image 619.png|none|frame]]
[[File:Image 654.png|alt=|none|frame]]
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.  
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.  


Line 48: Line 44:


3. For taxes first apply '''tax zones''', then '''taxes'''.
3. For taxes first apply '''tax zones''', then '''taxes'''.
[[File:Image 620.png|none|frame]]
 
'''Note:''' By applying the data from your '''older''' osCommerce version to the '''new''' one you '''replace''' the '''existing''' data on your '''new''' osCommerce version with the data from your '''older''' osCommerce version!
[[File:Image 655.png|alt=|none|frame]]
[[File:Image 656.png|alt=|none|frame]]
After the import process is complete the corresponding data (categories, products and so on) will show up. 
[[File:Image 657.png|alt=|none|frame]]

Revision as of 15:19, 20 January 2022

Extract the archived file into the root of your website with the older osCommerce version. This will create a "oscb" directory. We highly recommend to rename this directory for security reasons (e.g. your_directory).

Image 634.png
Image 636.png
Image 637.png

Read the information in the Readme file as to how to proceed.

Image 642.png

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.

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

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

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).

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 647.png

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

Check oscb directory for secfile name.

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 651.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, Import/Export and Data Source tabs. The import from Oscommerce 2x has already been set up.

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).

Double click on your data source.

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.

Note: By applying the data from your older osCommerce version to the new one you replace the existing data on your new osCommerce version with the data from your older osCommerce version!

After the import process is complete the corresponding data (categories, products and so on) will show up.