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

From osCommerce Wiki
Jump to navigation Jump to search
No edit summary
(add download of the Data Importer file)
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''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 635.png|alt=|none|frame]]
[[File:Image 634.png|none|frame]]
[[File:Image 636.png|none|frame]]
[[File:Image 637.png|none|frame]]
Read the information in the Readme file as to how to proceed.
[[File:Image 642.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.
[[File:Image 638.png|alt=|none|frame]]
There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''.
[[File:Image 639.png|alt=|none|frame]]
If it is done via '''command line''' '''copy''' the command line highlighted in the screenshot below.
[[File:Image 640.png|alt=|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 641.png|alt=|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.
[[File:Image 648.png|alt=|none|frame]]
'''Check''' your_directory for '''secfile''' name.
[[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.
[[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.
[[File:Image 614.png|none|frame]]
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 initiated.
[[File:Image 669.png|alt=|none|frame]]
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 your_directory. for details and choose the '''secure method''' from the drop down list (the one per the screenshot below is '''recommended''').
[[File:Image 668.png|alt=|none|frame]]
'''Double click''' on your data source.
[[File:Image 660.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.


'''Note''': We would recommend to apply the data in the following order:
=='''Step 0 - Download''' the Data Importer file from https://www.oscommerce.com/download/oscb_secure_v31.zip  ==
=='''Step 1 - Extract''' the archived file into the '''root''' of your website with the '''older''' osCommerce version. The command is '''unzip oscb_secure_v31.zip'''==
[[File:Image 675.png|alt=|none|frame]]
[[File:Image 674.png|alt=|none|frame]]


1. For products first apply '''brands, categories and product options''', then '''products'''.
== This will create a "oscb" directory. ==
[[File:Image 673.png|alt=|none|frame]]


2. For Orders first apply '''customers''' and '''order statuses''', then '''orders'''.
== We highly recommend to '''rename''' this directory for security reasons (e.g. your_directory). The command is '''mv oscb your_directory''' ==
[[File:Image 676.png|alt=|none|frame]]


3. For taxes first apply '''tax zones''', then '''taxes'''.
== '''Step 2 -''' Read the information in the '''Readme''' file as to how to proceed. ==
[[File:Image 677.png|alt=|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!
== The '''link''' highlighted in the screenshot below (https://your_domain/your_directory/index.php) will be used for filling in the '''Base URL''' field in the '''new''' osCommerce version as it is described below. ==
[[File:Image 678.png|alt=|none|frame]]


In the final release there will be the option whether to replace the data or not. Also there will be the possibility of associating order statuses between older and new osCommerce versions.  
== '''Step 3''' - There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''. ==
[[File:Image 671.png|alt=|none|frame]]
[[File:Image 679.png|alt=|none|frame]]
[[File:Image 672.png|alt=|none|frame]]
 
After the import process is complete the corresponding data (categories, products and so on) will show up. See the samples of the '''categories/subcategories and products''' imported from the older osCommerce versions to the new one.   
== If it is done via '''command line''' '''copy''' the command line (php yii bridge/show-secure-key) highlighted in the screenshot below. ==
[[File:Image 661.png|none|frame]]
[[File:Image 680.png|alt=|none|frame]]
[[File:Image 662.png|none|frame]]
 
[[File:Image 663.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 657.png|alt=|none|frame]]Also see the sample of the '''order''' imported from the older osCommerce versions to the new one.
[[File:Image 681.png|alt=|none|frame]]
[[File:Image 664.png|none|frame]]
 
[[File:Image 665.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. First choose '''compat'''. ==
[[File:Image 666.png|none|frame]]
[[File:Image 682.png|alt=|none|frame]]
[[File:Image 667.png|none|frame]]
 
== Then '''configure.php''' ==
[[File:Image 683.png|alt=|none|frame]]
 
== '''Uncomment''' the line #12 (delete 2 first symbols //) ==
[[File:Image 684.png|alt=|none|frame]]
[[File:Image 685.png|alt=|none|frame]]
 
== '''Save''' the changes. ==
[[File:Image 686.png|alt=|none|frame]]
 
== '''Open''' the page in the web browser (https://your_domain/your_directory/index.php?r=site/create-sec-file) as indicated in the '''Readme''' file. You should see the following message - '''File was created successfully.''' ==
[[File:Image 687.png|alt=|none|frame]]
 
== '''Check''' your_directory for '''secfile''' name. ==
[[File:Image 688.png|alt=|none|frame]]
 
== '''Open''' this file and '''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). ==
[[File:Image 689.png|alt=|none|frame]]
 
== '''Delete''' this file. ==
[[File:Image 690.png|alt=|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 - '''The action is forbidden. Please check readme file for details.''' ==
[[File:Image 705.png|alt=|none|frame]]
 
== '''Step 4''' - 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 initiated. ==
[[File:Image 692.png|alt=|none|frame]]
 
== 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 your_directory. for details and choose the '''secure method''' from the drop down list (the one per the screenshot below is '''recommended'''). ==
[[File:Image 693.png|alt=|none|frame]]
 
== '''Double click''' on your data source. ==
[[File:Image 694.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. ==
 
== '''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! ==
 
== In the final release there will be the option whether to replace the data or not. Also there will be the possibility of associating order statuses between older and new osCommerce versions. ==
[[File:Image 695.png|alt=|none|frame]]
[[File:Image 696.png|alt=|none|frame]]
 
== '''Step 5 -''' After the import process is complete the corresponding data (categories, products and so on) will show up. See the samples of the '''categories/subcategories and products''' imported from the older osCommerce versions to the new one. ==  
[[File:Image 697.png|alt=|none|frame]]
[[File:Image 698.png|alt=|none|frame]]
[[File:Image 699.png|alt=|none|frame]]
[[File:Image 700.png|alt=|none|frame]]
 
== Also see the sample of the '''order''' imported from the older osCommerce versions to the new one. ==
[[File:Image 701.png|alt=|none|frame]]
[[File:Image 702.png|alt=|none|frame]]
[[File:Image 703.png|alt=|none|frame]]
[[File:Image 704.png|alt=|none|frame]]

Revision as of 19:07, 24 January 2022

Step 0 - Download the Data Importer file from https://www.oscommerce.com/download/oscb_secure_v31.zip

Step 1 - Extract the archived file into the root of your website with the older osCommerce version. The command is unzip oscb_secure_v31.zip

This will create a "oscb" directory.

We highly recommend to rename this directory for security reasons (e.g. your_directory). The command is mv oscb your_directory

Step 2 - Read the information in the Readme file as to how to proceed.

The link highlighted in the screenshot below (https://your_domain/your_directory/index.php) will be used for filling in the Base URL field in the new osCommerce version as it is described below.

Step 3 - 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 (php yii bridge/show-secure-key) 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. First choose compat.

Then configure.php

Uncomment the line #12 (delete 2 first symbols //)

Save the changes.

Open the page in the web browser (https://your_domain/your_directory/index.php?r=site/create-sec-file) as indicated in the Readme file. You should see the following message - File was created successfully.

Check your_directory for secfile name.

Open this file and 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).

Delete this file.

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 - The action is forbidden. Please check readme file for details.

Step 4 - 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 initiated.

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 your_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!

In the final release there will be the option whether to replace the data or not. Also there will be the possibility of associating order statuses between older and new osCommerce versions.

Step 5 - After the import process is complete the corresponding data (categories, products and so on) will show up. See the samples of the categories/subcategories and products imported from the older osCommerce versions to the new one.

Also see the sample of the order imported from the older osCommerce versions to the new one.