Tutorials for Magento and Joomla! - Yireo

Importing and exporting users

With MageBridge, new users are automatically synchronized: If a new customer has been created in Magento, MageBridge will automatically create a corresponding user in Joomla! - as soon as the user logs in, or as soon as the user-record is edited in the backend. But if you have an existing userbase that you want to migrate at once, you need to follow a procedure which is a bit more complex. This tutorial helps you out.

Migrating users from Joomla! to Magento

When you want to migrate users from Joomla! to Magento, there is not much information available yet: Joomla! only adds an username, a name and an email that could be migrated to Magento. To migrate these records, browse within the Joomla! Administrator to Components > MageBridge > Users. Note that this is not necessary for MageBridge to operate - MageBridge will autocreate users if needed.

Configure MageBridge User parameters

First you need to configure things properly. This tutorial assumes you have already setup the bridge correctly, meaning that the MageBridge API Widgets are showing nice little dropdowns instead of regular input-boxes. Within the MageBridge Users overview, click on Parameters in the toolbar. Within the popup configure the Magento Website and Magento Customer Group. Save these settings.

Export Joomla! users to CSV

Next hit the Export button in the toolbar. The Joomla! userrecords are now exported to a format suitable for importing into Magento.

Import Joomla! users into Magento

Magento already has an excellent way of importing users. This will be used to import your user-records. Browse within the Magento Admin Panel to System > Import/Export > Profiles and select the profile called Import Customers. Make sure the settings are configured as follows:

Profile Information

• Entity Type: Customers
• Direction: Import
• Store: Default (Admin)

Data Format

• Type: CSV
• Value Delimiter: , (comma)
• Enclose Values In: " (double quotes)
• Original Magento attribute names in first row: No

Next browse to the tab Upload File and upload the CSV-file exported from Joomla!. If the file is too large, you can also try uploading it manually to the Magento directory var/import.

Once the file is in place, browse to the tab Run Profile, select the file in the dropdown-list and hit the button Run Profile In Popup. This should import all Joomla! users to Magento. Remember to remove the files in var/import after you're done.

Migrating customers from Magento to Joomla!

The opposite could also be needed: When you have an existing customer-base in Magento, you could choose to migrate all customers from Magento to Joomla. Note that this is not necessary for MageBridge to operate - MageBridge will autocreate users if needed. But if you want add all Magento customers to a newsletter-configuration, this procedure comes in handy.

Browse within the Magento Admin Panel to System > Import/Export > Profiles and select the profile called Export Customers. Make sure the settings are configured as follows:

Profile Information

• Entity Type: Customers
• Direction: Export
• Store: [choose the right store]

Data Format

• Type: CSV
• Value Delimiter: , (comma)
• Enclose Values In: " (double quotes)
• Original Magento attribute names in first row: No