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!


Introduction

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 database.

  • 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

  Name: Profile name in Magento
  IP or Hostname: reference your DB location.
  Port: Use 3306 for Default
 
  DB Name: name of osCommerce DB or, new DB name you entered in Step 3
 
  DB Username: username login access to osCommerce DB
 
  DB Password: password for login access to osCommerce DB
  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:
 
      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 http://www.magentocommerce.com/blog/comments/video-creating-multiple-online-storefronts-part1/
 Locale Selection
      Magento will create a store view for each of your osCommerce language packages.
Import Options
      Categories: Check to import all osCommerce categories with tree structure
  
      Products: Check to import all product 
      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.
      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:
  
      All Cache: Select "Refresh"
      Check both options under Catalog section
      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!



 

Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs