We recently were asked by a client to migrate a website from Joomla to WordPress. The new website would have a new design but all the data or page content would remain the same as per the old website. The challenge we faced was migrating the data from Joomla over to WordPress.

There is a WordPress plug-in available which does exactly we wanted. It’s called FG Joomla to WordPress. This plug-in can migrate sections, categories, posts, images, medias and tags from Joomla to WordPress. This plug-in worked like a charm for us. We were able to migrate all the Joomla pages as WordPress pages.

However, there was one more challenge for us. The Joomla website had Virtuemart installed which was used to sell books online. This was a real challenge for us because we couldn’t find any good plug-in which would do this for us. So we decided to migrate the data ourselves.

Firstly we installed WooCommerce, an eCommerce plug-in for WordPress. We then wrote SQL queries to first migrate the Joomla product categories over to WooCommerce. To migrate the products we had to again write SQL queries. Lastly we migrated all the product images using a very good script as seen here.

Migrating Virtuemart products and categories over to WooCommerce requires thorough understanding of how WooCommerce creates products and categories in the WordPress database. It uses the same WordPress tables like wp_posts, wp_postmeta, wp_terms, wp_term_taxonomy and wp_term_relationships. These set of tables are just sufficient to migrate categories and products from Virtuemart.

If you have a similar requirement then please get in touch with us. We’ll be glad to help you.