HubSpot to WordPress migration sans migraine

Businesses rarely stick to the tools and platforms they used when they started their journey. Same is the case with CMS. You started with something but after a point of time that doesn’t look like the perfect option for you. What to do? Thankfully you can migrate from one platform to another without any significant loss in your traffic and data. In this article we are talking about Hubspot and WordPress. These are one of the most popular CMS out there in the market. And so, today we’ll learn about the migration of blog from HubSpot to WordPress.

Depending on the size, page load speed, scope, and goals of your website you can conduct the HubSpot to WordPress migration. The pages of the old website can be easily added manually to the WordPress theme, but due to a large number of blogs, we can not put the content manually. So, we have come up with an out-of-box way to do this, which will make it very easy.

For this migration, we have used a Hubspot wordpress plugin known as LLM HubSpot Blog Import.

What will we Migrate

  • Title of the Blog.
  • Post Content (Body of the blog > Includes:- Image, CTA, Link, embed assets).
  • Featured Image.
  • Meta Description.
  • Publish Date & Time.
  • Tag – Categories.
  • Author.

The hubspot plugin, LLM HubSpot Blog Import is an automated service for the content management system. This online service allows migration of all the blog content from your HubSpot to WordPress quickly, easily and for free. With this plugin, you can forget about those hours of manual data used for HubSpot to WordPress conversion.

How it works

  • You will need an HubSpot API for this, get it from the API key section of HubSpot.
  • After putting the API in the field, just press the ‘Sync HubSpot Data’ button.

Important Note: This Plugin migrates only 300 blogs at once.

Why it didn’t work?

This works very well, but HubSpot allows only 300 blogs to be moved. If you have 300+ blogs, then you have to make changes to the plugin code. To do this, the content will have to be migrated by some time frame.

Solution

For this, we made some changes to the WordPress php (.php) file. You can see the given below:

In your WordPress dashboard, navigate to Plugins > Editor. Select LLM HubSpot Blog Import > save.php The code given below will need to be modified and replaced

In this code, we need to change “Epoch Timestamp”, for which we will use online Epoch Timestamp converter. In this, we will take the time interval in which less than 300 blogs have been published. Instead of the old code, we have to replace this new code according to the timestamp. There will be the change in the highlighted from the colour.

Side Effects

The side effect of doing this is that when we do this, the operation stops due to overloading of the server. To avoid this, the size of our server RAM should be re-configured depending upon the size of content.If you have any doubt, You can always reach out to Znbound (HubSpot Partner).

Steps on how to manually migrate Blogs from HubSpot to WordPress.

Now, we will walk you through the necessary steps to manually migrate your blog from HubSpot to WordPress –

Step 1 : Export Blog from HubSpot.

To export your blog content from HubSpot, navigate to the “Website” option in the “Settings” menu and select “Blog”. Then, click on the “Export” button to export your blog as an XML file.

Hubspot to WordPress Migration step to export blog content

After selecting the “Export” button, a popup window will appear with various file format options. From here, you can choose the specific blog you want to export and begin the export process.

HubSpot to WordPress migration pop window to export blogs

After completing the export process, you should receive an email with the exported file within a few minutes.

Step 2 : Install Import plugin.

First, Install and activate Import any XML or CSV File to WordPress plugin. Next, access the WP ALL IMPORT Plugin and select “Upload a File” to proceed to the next step.

HubSpot to WordPress migration wp all import plugin option

After importing the file, you will be presented with a preview of the blog. Click on “Continue to Step 3” to proceed.

HubSpot to WordPress migration blog preview

Now, To map the fields correctly, drag and drop the corresponding fields from the right-hand side to the left-hand side.

HubSpot to WordPress migration map field

After mapping all the fields, you can proceed to click on the “Confirm & Run Import” button to initiate the import process.

HubSpot to WordPress migration file setup option

Step 3: Check the migrated content

Once the migration process is completed, it is essential to review the migrated content thoroughly to ensure that everything is transferred correctly. It is recommended to check for formatting errors, broken links, and other issues to make sure the migrated content meets the desired standards. By following the steps mentioned above, you can easily migrate your HubSpot blog to WordPress manually.

Want to know what happened when we migrated from Drupal to HubSpot?

Here is a bonus article for you.

The Drupal to HubSpot Migration

If you are migrating a blog from Drupal to HubSpot, so you are in the right place…

Before migration, let’s first know its background…

There is no doubt that over 86,000+ companies in more than 120 countries prefer to use HubSpot tools to grow their business and increase the number of leads. But, some say that it is not for everyone because some people are unaware of the device and some are still surprised to learn- is this the right solution for them?

HubSpot- All in One Business Automation is the best tool to date as it provides free CRM services, but it is also true that with the increase in the number of contacts, organizations will have to spend a few bucks out of their own pocket.

It is easy to migrate blogs from HubSpot to any other CRM and from other CRM to HubSpot but we had a lot of problems to bring blog from Drupal to HubSpot. And there is no specific way to migrate the blogs from Drupal to HubSpot.

I know you might be thinking that using traditional approaches (COPY and PASTE), one can transfer website content ike blogs directly from Drupal to HubSpot. There is no doubt that it is easy, but chances are you may lose data and have to spend time transferring each blog individually as there are 350+ blogs here.

Now, you might be thinking about the right way to move a blog from Drupal to HubSpot. Scrolling down and reading this article will guide you with the proper steps, considering which you can move Drupal Blogs to HubSpot.

Before moving Drupal to HubSpot migration, have you ever thought about what you need? let’s take a look. If not, then see below.

What do we need to migrate?

Below are some fields that we had to migrate from Drupal to HubSpot.

  1. Blog Title
  2. Featured image of respective blog you want to migrate
  3. Blog Content (data, images, links, CTA, embed assets)
  4. Meta Description
  5. Publish time and date
  6. Author
  7. Tags/Categories

Now, without taking a minute, let’s dive into the following steps allowing you to transfer your blog posts directly from Drupal to HubSpot.

Blog Migration Steps From Drupal to HubSpot

Let’s get started….

Step 1: Export data from Drupal

First of all, we have to export the content from Drupal as an xml file. The Views Data Export module can do the heavy lifting for you. You can see here how it is created.

The biggest challenge was to convert the XML file generated by views data export to the WordPress XML format supported by Hubspot.

Here are the fields that we need to migrate from Drupal to Hubspot:

  • Title
  • Featured image
  • Categories
  • Author
  • Body
  • Teaser (excerpt)
  • Published date

Step 2: WordPress XML

The next step would be to create the WordPressXML from the XML generated from Drupal. We have used a simple Python script to do the conversion. The BeautifulSoup library can be used to parse the XML and do the conversion. 

In its simplest form, the wordpress XML looks like


You need to fill the placeholders with actual value from the xml generated from Drupal. You can see an example here, which uses the rss feed xml as input. We are not using rss xml as it has some limitations on featured image, categories etc..

Step 3: Importing the WordPressXML to HubSpot

After you’ve exported your WordPress posts, sign in to your HubSpot account.

  • In your HubSpot account, click the settings icon settings in the main navigation bar.
  • In the sidebar menu, navigate to CMS > Blog.
  • In the upper right, click Import blog.
  • In the blog import dashboard, click Import new blog.
  • Select Import XML file to upload your XML file of WordPress posts.
hubspot to wordpress migration screenshot of hubspot blog migration screen

Conclusion

To summarise everything, to do a Drupal to HubSpot migration, the steps involved:

  • Export data from Drupal
  • Convert it to WordPressXML
  • Import XML to Hubspot

Hope you can do this migration with the help of this article. You can contact us here for more information.

And If you would like to know more about my work on HubSpot COS, please look up the links below.

  1. The HubSpot Migration Checklist
  2. 5 Libraries A HubSpot COS Developer Should Use
  3. How to increase HubSpot COS Page Speed
Team Znbound
Table of Contents