Export Woo Commerce Orders into Hubspot CRM

There comes a time when your ecosystem doesn’t talk to each other. I am maintaining my e-commerce website in WordPress with WooCommerce plugin. While my CRM is in Hubspot.

How can I export my customer orders in Woo Commerce and import them to my hubspot CRM?

I have written a small script that will allow me to do this. In a nutshell here are the steps required:

Step 1. Allow external database access from your WordPress database where the Woo commerce data is stored

Step 2. Run the script to export the orders

Step 3. Cleanse the data

Step 4. Import the data into Hubspot CRM

Step 5. Profit!!

I wish things were always as simple as this, but if you plan it right, it can be.

You can download the script that I have used here.