Creating an osCommerce DataBase Import Profile
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.
- 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.
- 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
- 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.
- Fill in form:
- 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
- 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
- If successful you should see a chart with the total of records found, imported, and failed to import.
- 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
- 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.