Importing Data from Older osCommerce Version to New One
From osCommerce Wiki
Jump to navigation
Jump to search
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 oscb156.zip.
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 OSCommerce bridge 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 OSCommerce secure key field in the new osCommerce version as it is described below).
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.
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 OSCommerce secure key field in the new osCommerce version as it is described below).
Delete this file.
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.
Also see the sample of the order imported from the older osCommerce versions to the new one.