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

From osCommerce Wiki
Jump to navigation Jump to search
Line 58: Line 58:
 
[[File:Screenshot 3.png|alt=|frameless|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. ==
 
== 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. ==

Revision as of 14:05, 7 June 2022

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

Step 1 - Extract the archived file into the root of your website with the older osCommerce version. The command is unzip oscb_secure_v32.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 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 swith 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).

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.

Image 716.png
Image 717.png

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