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

From osCommerce Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:


=='''Step 0 - Download''' the Data Importer file from https://www.oscommerce.com/download/oscb_secure_v31.zip ==
=='''Step 0 - Download''' the Data Importer file from https://www.oscommerce.com/download/oscb153.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'''==
=='''Step 1 - Extract''' the archived file into the '''root''' of your website with the '''older''' osCommerce version. The command is '''unzip oscb153.zip'''==
[[File:Image 635.png|none|thumb|800x800px]]
[[File:Image 635.png|none|thumb|800x800px]]
[[File:Image 634.png|none|thumb|800x800px]]
[[File:Image 634.png|none|thumb|800x800px]]
Line 12: Line 12:
[[File:Image 642.png|none|thumb|800x800px]]
[[File:Image 642.png|none|thumb|800x800px]]


== 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. ==
== The '''link''' highlighted in the screenshot below (https://your_domain/your_directory/index.php) will be used for filling in the '''OSCommerce bridge URL''' field in the '''new''' osCommerce version as it is described below. ==
[[File:Image 709.png|none|thumb|799x799px]]
[[File:Image 709.png|none|thumb|799x799px]]


Line 21: Line 21:
[[File:Image 707.png|none|thumb|800x800px]]
[[File:Image 707.png|none|thumb|800x800px]]


== '''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). ==
== '''Paste''' this command line to get the secure key and store this key (this key will be used for filling in the '''OSCommerce secure key''' field in the '''new''' osCommerce version as it is described below). ==
[[File:Image 706.png|none|thumb|800x800px]]
[[File:Image 706.png|none|thumb|800x800px]]


== 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'''. ==
== If it is done via '''web''' (it is supposed to be done via web if there is no access to the command line for any reason) 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 643.png|none|thumb|799x799px]]
[[File:Image 643.png|none|thumb|799x799px]]


Line 43: Line 43:
[[File:Image 649.png|none|thumb|800x800px]]
[[File:Image 649.png|none|thumb|800x800px]]


== '''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). ==
== '''Open''' this file and '''store''' the secure key (this key will be used for filling in the '''OSCommerce secure key''' field in the '''new''' osCommerce version as it is described below). ==
[[File:Image 711.png|none|thumb|800x800px]]
[[File:Image 711.png|none|thumb|800x800px]]


Line 52: Line 52:
[[File:Image 712.png|none|thumb|800x800px]]
[[File:Image 712.png|none|thumb|800x800px]]


== '''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. ==
== '''Step 4''' - After you accessed the admin area of your website with the '''new''' osCommerce version click on '''Modules''' and '''Extensions''' tabs. Switch on '''Show inactive''' and '''Show not installed''' toggles, find the '''Osc Link''', '''install''' it by clicking on the corresponding button and switch its '''status''' on.   ==
[[File:Image 713.png|none|thumb|800x800px]]
[[File:Screenshot 2.png|alt=|frameless|800x800px]]


== 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'''). ==
== Click on '''Modules, Connectors''' and '''OSCommerce Connector Service''' tabs. The import from the older osCommerce version has already been initiated. Under '''Connection settings''' tab fill in the '''OSCommerce bridge URL''' field with the link from your '''older''' osCommerce version where the required '''data''' is located, choose the '''OSCommerce secure method''' from the drop down list (the one per the screenshot below is '''recommended''') and fill in the '''OSCommerce secure key''' field with the required key as it is described '''above''' or see '''readme''' file in your_directory.   ==
[[File:Image 714.png|none|thumb|801x801px]]
[[File:Screenshot 3.png|alt=|frameless|801x801px]]


== '''Double click''' on your data source. ==
== Under '''Mapping settings''' tab you can choose the required '''API default platform''' from the drop down list as well as '''add''' or '''delete''' the required number of the '''order mapping statuses''' by clicking on '''+''' and '''-''' buttons from your '''older''' osCommerce version ('''OSCommerce order status''') to the '''new''' one ('''Will be mapped to'''). ==
[[File:Image 715.png|none|thumb|800x800px]]
[[File:Screenshot 4.png|alt=|frameless|800x800px]]


== 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. ==
== After the changes under the previous tab are saved '''Run import actions''' and '''Clean imported data''' tabs will show up. Under '''Run import actions''' tab the list of all the options available for import will show up. Click on the '''Import''' button next to '''each''' option to import the data from your '''older''' osCommerce version to the '''new''' one. ==


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


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


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


== 3. For taxes first apply '''tax zones''', then '''taxes'''. ==
== 3. For taxes first '''import 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! ==
== '''Note:''' By '''importing''' 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:Screenshot 5.png|alt=|frameless|800x800px]]


== 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. ==
== Under '''Clean imported data''' tab you can either '''Remove all imported entities and mapped data''' or '''Remove only selected imported entities''' by checking the corresponding boxes. ==
[[File:Image 695.png|alt=|none|frame]]
[[File:Screenshot 6.png|alt=|frameless|794x794px]]
[[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. ==
== '''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 718.png|none|thumb|800x800px]]
[[File:Image 698.png|alt=|none|frame]]
[[File:Image 719.png|none|thumb|800x800px]]
[[File:Image 699.png|alt=|none|frame]]
[[File:Image 720.png|none|thumb|800x800px]]
[[File:Image 700.png|alt=|none|frame]]
[[File:Image 721.png|none|thumb|800x800px]]


== Also see the sample of the '''order''' 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. ==
[[File:Image 701.png|alt=|none|frame]]
[[File:Image 722.png|none|thumb|800x800px]]
[[File:Image 702.png|alt=|none|frame]]
[[File:Image 723.png|none|thumb|800x800px]]
[[File:Image 703.png|alt=|none|frame]]
[[File:Image 724.png|none|thumb|800x800px]]
[[File:Image 704.png|alt=|none|frame]]
[[File:Image 725.png|none|thumb|800x800px]]

Revision as of 09:14, 26 July 2022

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

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

Image 635.png
Image 634.png

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

Image 636.png
Image 637.png

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

Image 642.png

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

Image 709.png

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

Image 708.png

If it is done via command line copy the command line (php yii bridge/show-secure-key) highlighted in the screenshot below.

Image 707.png

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

Image 706.png

If it is done via web (it is supposed to be done via web if there is no access to the command line for any reason) 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.

Image 643.png

Then configure.php

Image 644.png

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

Image 645.png
Image 646.png

Save the changes.

Image 647.png

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.

Image 710.png

Check your_directory for secfile name.

Image 649.png

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

Image 711.png

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

Image 712.png

Step 4 - After you accessed the admin area of your website with the new osCommerce version click on Modules and Extensions tabs. Switch on Show inactive and Show not installed toggles, find the Osc Link, install it by clicking on the corresponding button and switch its status on.

Click on Modules, Connectors and OSCommerce Connector Service tabs. The import from the older osCommerce version has already been initiated. Under Connection settings tab fill in the OSCommerce bridge URL field with the link from your older osCommerce version where the required data is located, choose the OSCommerce secure method from the drop down list (the one per the screenshot below is recommended) and fill in the OSCommerce secure key field with the required key as it is described above or see readme file in your_directory.

Under Mapping settings tab you can choose the required API default platform from the drop down list as well as add or delete the required number of the order mapping statuses by clicking on + and - buttons from your older osCommerce version (OSCommerce order status) to the new one (Will be mapped to).

After the changes under the previous tab are saved Run import actions and Clean imported data tabs will show up. Under Run import actions tab the list of all the options available for import will show up. Click on the Import button next to each option to import the data from your older osCommerce version to the new one.

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

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

2. For orders first import customers and order statuses, then orders.

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

Note: By importing 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!

Under Clean imported data tab you can either Remove all imported entities and mapped data or Remove only selected imported entities by checking the corresponding boxes.

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.

Image 718.png
Image 719.png
Image 720.png
Image 721.png

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

Image 722.png
Image 723.png
Image 724.png
Image 725.png