The HubSpot integration facilitates the handoff between Sales and Finance by allowing Hubspot deals to create sales orders in SaaSOptics. These sales orders contain financial information that the system uses to create customers, contracts, transactions, revenues, and invoices. This integration is designed to eliminate manual data entry, provide more accurate financial records, and decrease silent failures.
What's in this Article
- Setup and Configuration
- Syncing and Processing Sales Orders
The HubSpot integration must be enabled in your account before it can be configured. Please contact support if you do not see the option in the Integrations section of the Admin menu.
Log in to your SaaSOptics account. In a separate tab or window in the same browser, log in to HubSpot. You must be logged into both systems within the same browser to connect them.
- Open the HubSpot page in SaaSOptics and then click the wrench icon in the top-right corner. This opens the HubSpot Integration Settings.
- Click the plug icon to access the HubSpot OAuth Setup page.
- You may need to log into Hubspot at this point if you have not already done so. Also, if you have multiple Hubspot accounts, select the one to which you'd like to connect.
- A page displays asking if you wish to grant SaaSOptics access to your HubSpot data. Click Grant Access.
You are then returned to SaaSOptics, where you will see a banner message confirming that you are now connected to HubSpot.
In order to pull Deals in from HubSpot, you must enable and configure the Get Sales Orders syncing functionality in SaaSOptics by completing the steps below:
- Click the pencil icon in the top-right corner of the Settings tab. This opens the Update HubSpot Integration Settings page.
- Check the Enable Sales Order Sync checkbox.
- Configure the other settings according to the descriptions in the next section.
- Click Save at the bottom of the screen.
|Sales Order Sync Schedule||
|Sales Order Sync Type||SaaSOptics pulls order information from Hubspot based on this selection:
|Sales Order Last Sync Date||Enter a date (and time, if you wish) into this field to limit the records that sync to the order queue from HubSpot. Sales orders that were last modified or closed before this date will not sync into SaaSOptics.
It is extremely important to not to leave this field blank without understanding the potential ramifications of doing so. If this field is left blank, ALL of your deals will be pulled from HubSpot-including your historical data or records you do not wish to sync to SaaSOptics. Exercise great caution if you choose to clear or adjust this field.
Additionally, this date must be within the last 29 days due to the limitations of Hubspot's API. Failure to do this will cause SaaSOptics to import in all deals that have not previously been processed.
|Deal Stages to Sync||Select the stages that deals must be in to have their information synced into SaaSOptics. You can select as many stages as necessary, including those in different pipelines.|
|Close Date Filter||Enter a date that limits the closed deals that sync into SaaSOptics. Only the deals that are closed on or after this date are brought into the order queue.|
The Sales Order Field Mappings tab appears once you have both connected to HubSpot and enabled the Get Sales Orders sync in the HubSpot integration settings. From this tab, click the pencil icon to configure or update your mappings. You can click the eraser icon to reset the mappings to the defaults listed in the table below.
If there are no mappings listed in this tab, use the eraser icon to repopulate the list with the default set of mappings.
Default Field Mappings
|SaaSOptics Object||SaaSOptics Field||HubSpot Object.field||Notes|
|Sales Order||Order total||Deal.amount|
|Sales Order||Customer name||Company.name|
|Sales Order||Customer billing street||Company.address|
|Sales Order||Customer billing city||Company.city|
|Sales Order||Customer billing state||Company.state|
|Sales Order||Customer billing zip code||Company.zip|
|Sales Order||Customer billing country||Company.country|
|Sales Order||Close date||Deal.closedate|
|Sales Order Line Item||Transaction start date||Deal.closedate|
|Sales Order Line Item||Transaction order date||Deal.closedate|
|Sales Order Line Item||Transaction item name||LineItem.name||This mapping is only included in the default mappings if you have Deals with Products selected as your Sync Type in your Integration Settings.|
|Sales Order Line Item||Transaction item code||LineItem.hs_product_id||This mapping is only included in the default mappings if you have Deals with Products selected as your Sync Type in your Integration Settings.|
|Sales Order Line Item||Transaction amount||LineItem.amount (Deals without Products)
Deal.amount (Deals with Products)
|The default mapping to the Transaction Amount field differs depending upon whether you choose to sync Deals with Products or Deals without Products in your Integration Settings.|
|Sales Order Line Item||Transaction quantity||LineItem.quantity||This mapping is only included in the default mappings if you have Deals with Products selected as your Sync Type in your Integration Settings.|
|Sales Order Line Item||Transaction notes||LineItem.description|
If you are having difficulty finding a recently-created field in the mappings drop-downs, make sure you've synced with SaaSOptics since the field was created.
Disconnect from Hubspot
If you need to disconnect from HubSpot, you can do so by clicking the Disconnect icon in the top-right corner of the Synchronization tab in the HubSpot Integration Settings.
This section explains how to complete a sync with HubSpot and then process the resulting sales orders into financial records.
Perform a manual sync by clicking the Sync button in the main Hubspot page. You can also do this from the Synchronization tab in the integration settings. Doing so syncs in any deals in the proper stages and converts them into sales orders.
Complete the steps in this article to process a synced sales order. Once a sales order has been successfully processed, the records created or updated are assigned HubSpot IDs. You can click the ID number to view the corresponding record in HubSpot.
Occasionally, an old deal may import into SaaSOptics that you do not wish to process (due to Hubspot's API). You should Exclude the resulting Sales Orders to remove them from your queue.