Importing Data from Older osCommerce Version to New One: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(33 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
=='''Step 0 - Сreate a "oscb"''' directory and '''download''' the Data Importer file from [https://www.oscommerce.com/download/oscb158.zip https://www.oscommerce.com/download/oscb158.zip] into it. == | |||
=='''Step 0 - | =='''Step 1 - Extract''' the archived file from the '''"oscb"''' directory into the '''root''' of your website with the '''older''' osCommerce version. The command is '''unzip oscb158.zip.''' == | ||
=='''Step 1 - Extract''' the archived file into the '''root''' of your website with the '''older''' osCommerce version. The command is '''unzip | |||
[[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]] | ||
== | == We highly recommend to '''rename''' this directory for security reasons (e.g. your_directory). The command is '''mv oscb your_directory'''== | ||
[[File:Image 636.png|none|thumb|800x800px]] | [[File:Image 636.png|none|thumb|800x800px]] | ||
[[File:Image 637.png|none|thumb|802x802px]] | [[File:Image 637.png|none|thumb|802x802px]] | ||
Line 12: | Line 11: | ||
[[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 ''' | == 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 | [[File:Image 709.png|none|thumb|799x799px]] | ||
== '''Step 3''' - There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''. == | == '''Step 3''' - There are '''2''' ways of getting the secure key – via either '''command line''' or '''web'''. == | ||
[[File:Image | [[File:Image 708.png|none|thumb|800x800px]] | ||
== If it is done via '''command line''' '''copy''' the command line (php yii bridge/show-secure-key) highlighted in the screenshot below. == | == If it is done via '''command line''' '''copy''' the command line (php yii bridge/show-secure-key) highlighted in the screenshot below. == | ||
[[File:Image | [[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 ''' | == '''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 | [[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 | [[File:Image 643.png|none|thumb|799x799px]] | ||
== Then '''configure.php''' == | == Then '''configure.php''' == | ||
[[File:Image | [[File:Image 644.png|none|thumb|800x800px]] | ||
== '''Uncomment''' the line #12 (delete 2 first symbols //) == | == '''Uncomment''' the line #12 (delete 2 first symbols //) == | ||
[[File:Image | [[File:Image 645.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 646.png|none|thumb|800x800px]] | ||
== '''Save''' the changes. == | == '''Save''' the changes. == | ||
[[File:Image | [[File:Image 647.png|none|thumb|800x800px]] | ||
== '''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.''' == | == '''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 | [[File:Image 710.png|none|thumb|800x800px]] | ||
== '''Check''' your_directory for '''secfile''' name. == | == '''Check''' your_directory for '''secfile''' name. == | ||
[[File:Image | [[File:Image 649.png|none|thumb|800x800px]] | ||
== '''Open''' this file and '''store''' the secure key (this key will be used for filling in the ''' | == '''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 | [[File:Image 711.png|none|thumb|800x800px]] | ||
== '''Delete''' this file. == | == '''Delete''' this file. == | ||
[[File:Image | [[File:Image 651.png|none|thumb|800x800px]] | ||
== '''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.''' == | == '''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 | [[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 ''' | == '''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: | [[File:Screenshot 2.png|alt=|frameless|800x800px]] | ||
== Click 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. == | ||
[[File: | [[File:Screenshot 3.png|alt=|frameless|801x801px]] | ||
== ''' | == 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: | [[File:Screenshot 4.png|alt=|frameless|800x800px]] | ||
== | == 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 | == '''Note''': We would recommend to import the data in the following order: == | ||
== 1. For products first | == 1. For products first import '''brands, categories and product options''', then '''products'''. == | ||
== 2. For | == 2. For orders first '''import customers''' and '''order statuses''', then '''orders'''. == | ||
== 3. For taxes first | == 3. For taxes first '''import tax zones''', then '''taxes'''. == | ||
== '''Note:''' By | == '''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]] | |||
== | == 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: | [[File:Screenshot 6.png|alt=|frameless|794x794px]] | ||
== '''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 | [[File:Image 718.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 719.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 720.png|none|thumb|800x800px]] | ||
[[File:Image | [[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 | [[File:Image 722.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 723.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 724.png|none|thumb|800x800px]] | ||
[[File:Image | [[File:Image 725.png|none|thumb|800x800px]] |