Creating an osCommerce DataBase Import Profile

Last modified by Udi on Fri, June 25, 2010 09:40
Source|Old Revisions  

This is an old revision of the document!


Magento 1.0 supports the import of your categories tree and structure, products, customers and order history records as well as your osCommerce multi-language data. Please note that this import was configured specifically for importing the DB of a default installation of osCommerce 2.2 RC2 and we do not guarantee compliance with other versions, customizations or added contributions.

1. Catalog Images

  • Copy all of your category and product images using FTP client into the Media > Import directory in the root of your Magento installation.
  • Enable write permissions for all copied folders and files.

2. Create Backup osCommerce DB file

- recommended *Skip to step 4 if you want to import DB directly from your osCommerce store.

  • Navigate in your osCommerce administration panel to Database Backup in the Tools section
  • Click on the Backup button to the right of the path for the backup directory
  • Check “Download only (do not store server side)” and click the Backup button
  • Save the .sql file to your desktop

3. Import backup file into new DB

  • Using a client such as phpmyadmin create a new DB (you will use this DB name when creating the import profile in Magento) and upload the osCommerce DB backup (.sql) file into it.

4. Set up osCommerce import profile in Magento

  • Fill in form:
  1. Name: Profile name in Magento
  2. IP or Hostname: reference your DB location.
  3. Port: Use 3306 for Default
  4. DB Name: name of osCommerce DB or, new DB name you entered in Step 3
  5. DB Username: username login access to osCommerce DB
  6. DB Password: password for login access to osCommerce DB
  7. Prefix: prefix tables in osCommerce
  • Save profile

5. Run profile

  • Click on Check Requirements to access osCommerce DB (or backup DB)
  • If successful you should now see a General Information section, your osCommerce languages and osCommerce import options.
  • General Information:
  1. Select an existing website from the pulldown menu for importing your osCommerce DB. Or, create a new website for your osCommerce DB. If you choose to create a new website for your osCommerce DB import you’ll need to set up the website in the configuration section of the admin. If you’re not sure on how to do this, consult
  • Locale Selection
  1. Magento will create a store view for each of your osCommerce language packages.
  • Import Options
  1. Categories: Check to import all osCommerce categories with tree structure

Products: Check to import all product

  1. Customers: Check to import all customer info (Note: this version will import only default addresses of customers). You can set in the configuration section of the admin if customer info should be shared across multiple websites or restricted to a specific website. osCommerce customers will be able to use same login and password in Magento.
  2. Orders: Order records will be stored separate of Magento orders and will be viewable only through the customer’s my account section > order history or through the admin.
  • Click on the “Start Running” button to begin the import

6. Status of Import

  • If successful you should see a chart with the total of records found, imported, and failed to import.

7. Refresh Cache

  • Using Magento’s cache management in the system menu:
  1. All Cache: Select “Refresh”
  2. Check both options under Catalog section
  3. Click the Save Cache Settings button

8. View your osCommerce catalog in Magento

  • Navigate to the front end site you imported osCommerce to. In the footer, Select the osCommerce website store.
  • In the header you can see your imported osCommerce languages.
  • Your categories should reflect those imported from osCommerce and your products should now be visible in the store.

Welcome to Open Source eCommerce evolved!