search-icon

DEAR supports synchronisation of Sales, Customers and Products with HubSpot via a dedicated integration. 


HubSpot provides data analytics tracking for related external websites with some of its subscriptions. Users using the B2B portal can track customer traffic to the B2B pages, please see Set up DEAR B2B Portal for more information. 


NOTE: DEAR uses the Beta Associations API for our integration with HubSpot - this will enable DEAR users to take full advantage of HubSpot’s new features as they are released. You will need to enrol in HubSpot Beta from your HubSpot account - This is free for paid accounts.


NOTE: HubSpot’s API currently does not support negative quantities and prices. Due to this, if a DEAR sale contains a negative sale line, it will not be exported to HubSpot. 


Prerequisites

  • HubSpot Sales Hub Professional subscription
    • Enrol in HubSpot Beta API 
  • Familiarity with Processing a Sale
  • Familiarity with Products and Product Management
  • Familiarity with Customers
  • Users will need the Integration: HubSpot permission in order to use this feature. 
  • One available External integration license on your subscription, or purchase an additional license from the My subscription page. 


Table of Contents


HubSpot Integration Setup

[back to top]


First, you must connect DEAR to your HubSpot account. Only one HubSpot account can be connected at a time. You will need to add an External integration to your subscription if you do not have one available already. 


NOTE: DEAR uses the Beta Associations API for our integration with HubSpot - this will enable DEAR users to take full advantage of HubSpot’s new features as they are released. You will need to enrol in HubSpot Beta from your HubSpot account - This is free for paid accounts.


  1. Navigate to Integration → HubSpot.
  2. Click Connect to be taken to HubSpot where you will be prompted to enter your HubSpot account login details.
  3. In HubSpot, click the Grant Access button. You will then be taken back to the DEAR HubSpot Integration setup tab.
  4. In DEAR, click Continue Setup to move on to the next step. 
  5. Slide the Synchronisation status button to activate synchronisation with HubSpot and make the integration settings visible. 


Integration settings

[back to top]


In the Setup tab, several integration settings can be customised.


Synchronisation status

This slider is switched to Off by default. If this is toggled to On then data between HubSpot and DEAR will be synchronised. Turning synchronisation off does not remove any data from HubSpot. 


Sales synchronisation

Controls the sales data synchronisation between the two applications. Bidirectional synchronisation is not currently supported. There are three options:

  • Off: Sales data will not be synchronised between the two systems. The Sales tab will not be displayed on the DEAR integration page. If Sales synchronisation is set to Off, it is still possible to Import Customers/Products from HubSpot or Export Customers/Products to HubSpot. 
  • Export to HubSpot: This is the default option. All sales data will be synchronised from DEAR to HubSpot. This will automatically set Customer and Product synchronisation to Export to HubSpot. 
  • Import from HubSpot: All sales data will be synchronised from HubSpot to DEAR. This will automatically set Customer and Product synchronisation to Import from HubSpot. 


Customer synchronisation

Controls the customer data synchronisation between the two applications. Bi-directional synchronisation is not currently supported. If sale synchronisation is set to Import from HubSpot/Export from HubSpot, the same option will automatically be selected for customer synchronisation and this cannot be edited. There are three options:

  • Off: Customer data will not be synchronised between the two systems. The Customers tab will not be displayed on the DEAR integration page.
  • Export to HubSpot: All customer data will be synchronised from DEAR to HubSpot. 
  • Import from HubSpot: All customer data will be synchronised from HubSpot to DEAR. 


Product synchronisation

Controls the product data synchronisation between the two applications. Bi-directional synchronisation is not currently supported. If sale synchronisation is set to Import from HubsSpot/Export from HubSpot, the same option will automatically be selected for product synchronisation and this cannot be edited. There are three options:

  • Off: Product data will not be synchronised between the two systems. The Products tab will not be displayed on the DEAR integration page.
  • Export to HubSpot: All product data will be synchronised from DEAR to HubSpot. 
  • Import from HubSpot: All product data will be synchronised from HubSpot to DEAR. 


Different settings will be visible, or have different effects, depending on if Import from Hubspot or Export to Hubspot is selected for Update Sale, Update Product, and Update Customer. Please see below for details.


Export to Hubspot settings

[back to top]


Price tier*/Price tier currency

Choose which default price tier to assign to products exported to HubSpot and a price tier currency. HubSpot does not perform any currency conversion, the value of the price tier in DEAR will simply be exported and the price tier currency applied. Non-default price tiers and currency can be applied to products exported manually. 

  • Retail Price Tier in DEAR is 340, Wholesale Price Tier is 300. DEAR organisation base currency is USD. 
  • In HubSpot integration settings, user selects Price Tier: Retail and Price Tier Currency: EUR
  • When product is exported, product in HubSpot will have price 340 EUR. 


Product description type*

Choose whether to export Short description or Full description when exporting products from DEAR. 


Payment Term*

How long the customer is locked into the product after it has been purchased. This is a mandatory field for HubSpot products. Payment term can be specified in months or years or left blank. By default, this value is set to None


Force update HubSpot entities

If this setting is disabled, the system will not update any HubSpot entities if there have been no changes to the entity since the last sync operation. When the setting is enabled, all existing entities will be exported regardless of modified/unmodified status. 


Default address type*

The default address type (Billing or Shipping) for a new customer's address created upon import. 


Import from Hubspot settings

[back to top]


Price tier*/Price tier currency

The Price tier to assign when a new product is created in DEAR after import from HubSpot, and the currency in Hubspot that will be used to assign the value. No currency conversion takes place. 

  • Price in HubSpot is 300 USD or 340 EUR
  • In HubSpot integration settings, user selects Price Tier: Retail and Price Tier Currency: EUR
  • When product is imported, Retail Price Tier in DEAR will have value 340.


Location*

The default location to assign when a new product is created in DEAR after import from HubSpot.


Product description type*

Choose whether to have HubSpot description as Short description or Full description in DEAR a new product is created in DEAR after import from HubSpot.


Save in DEAR as*

Choose whether to save product in DEAR as Stock or Service when a new product is created in DEAR after import from HubSpot.


Save in DEAR with category

The category to assign when a new product is created in DEAR after import from HubSpot.


Import contacts without companies

Companies in HubSpot are equivalent to Customers in DEAR, both can have Contacts associated with them. Unlike DEAR, HubSpot allows you to have contacts without an attached company. Contacts and companies are imported according to the following rules:

  • A Company from HubSpot will be imported as a Customer.
  • A Contact with a Company will be imported to a Customer as a Customer Contact (HubSpot company will be the Customer).
  • A Contact without a Company will be imported as a Customer with one contact (unless Ignore contacts without organisations setting in setup tab is enabled). 


Contacts can be associated with multiple companies, see Associate Contact to multiple Companies or Deals for more information. 


Force update DEAR entities

If this setting is disabled, the system will not update any DEAR entities if there have been no changes to the entity since the last sync operation. When the setting is enabled, all existing entities will be imported regardless of modified/unmodified status.


Customer base currency*

This will be assigned as the base currency of the customers created with import from HubSpot. 


Revenue account*

The default Sale/Revenue account for a new customer created with import from HubSpot. 


Payment term*

The default payment term for a new customer created with import from Hubspot. 


Default customer taxation rule*

The default taxation rule for a new customer created with import from HubSpot. 


Default address type*

The default address type (Billing or Shipping) for a new customer contact's address created with Import from HubSpot.


Sync contact marketing consent

Imports marketing consent status from HubSpot to Cin7 Core.


Auto-sync settings

[back to top]


Auto-sync is enabled from the HubSpot Integration setup page. Enabling this setting will activate further auto-sync settings. When auto-sync is enabled, sales, customers and products will be automatically exported from DEAR to HubSpot or from HubSpot to DEAR depending on your settings. Both newly added items, as well as updated items will be auto-synced.


Start date*

Auto-sync start date. 


Start time*

Auto-sync start time. 


Sync frequency

Select Auto-sync frequency from 2h, 4h, 8h, 12h, Daily. 


Alert type for errors

If auto-sync encounters, select to send error notifications internally or via email. 

  • Internal: The alert will be displayed as a notification on the 'bell' icon on the top menu. 
  • Email: Selecting email will allow the user to select a mailing list. Email alerts for auto-sync errors will be sent to the recipients of the selected mailing list. The mailing list users will also receive a daily HubSpot synchronisations status update.


Link HubSpot deal stages and DEAR sale statuses

[back to top]


Deals in HubSpot correspond to Sales in DEAR. Therefore, HubSpot deal stages correspond to DEAR sale statuses. While you can have multiple deals pipelines in HubSpot, only one can be imported into DEAR to map to DEAR sale orders. Pipelines can be created and edited from your HubSpot account. 


This setup stage is necessary for Sales synchronisation to function correctly.


Click Load pipelines from HubSpot to make sure DEAR has the latest pipeline data from your Hubspot account. Next, select a pipeline to map from the HubSpot pipeline dropdown menu. 


Selecting a pipeline will load the deal stages into DEAR where they can be mapped.


Export to HubSpot mapping

[back to top]


Sale orders where DEAR status is mapped to a HubSpot Deal stage will be exported when they reach this stage. 


Several HubSpot Deal stages can be associated with the same DEAR Sale status. When a sale is exported from DEAR to HubSpot with a sale status associated to more than one HubSpot Deal stage, the earliest HubSpot stage will be picked for the exported sale. 


When a sale order in DEAR changes its status to another status mapped to a HubSpot Deal stage, the Deal will be updated in HubSpot.


Import from HubSpot mapping

[back to top]


The Create a Sale when HubSpot Deal reaches this Stage dropdown will only be visible when Update Sales is set to Import from HubSpot. When a HubSpot deal reaches the stage specified in this dropdown, a DEAR sale will be created with the status mapped in this section. 


Sale orders can only be created with status Estimating (Sale Quote Draft), Estimated (Sale Quote Authorised), Ordering (Sale Order Draft), or Ordered (Sale Order Authorised). This is because statuses further ahead in the sale process such as picking, packing, or shipping require information that is not provided in HubSpot. All sales are imported as simple sales, there is not enough information provided in HubSpot to create an Advanced sale. 

  • If HubSpot Deal Stage is mapped to a DEAR status further ahead in the sales process, it will be imported as a sale order with Ordered status. 
  • If Ordered status is not mapped to any HubSpot Deal stage, the imported sale order will get the status Estimated
  • If the stage has not been mapped (Unmapped & Ignored is selected for that stage), the sale will be created in DEAR with status Estimated (Sale Quote Authorised).


NOTE: DEAR loads deals from HubSpot only once when deal reaches the selected stage. Further changes to the Deal in HubSpot will not be exported to DEAR. Once a sale has been imported to DEAR it must be completed in DEAR. 


With the settings shown in these screenshots, when a HubSpot deal reaches the Qualified to Buy stage, a sale will be created in DEAR with status Estimated (Sale Quote authorised).


NOTE: If there is insufficient stock availability to create a sale quote or sale order in DEAR, the user will receive an error. When stock availability increases enough to fulfill the sale, and IF the auto-sync option is set to 'ON' then the sale will be created for the product at the next sync interval automatically. If this option is set to 'Off' then the user will have to sync the sale manually.


NOTE: If Hubspot deal stages for the selected pipeline are updated from HubSpot, the updated/renamed values will display in the Create a Sale when HubSpot Deal reaches this Stage dropdown after the next sync operation.



Link Hubspot and DEAR customer fields

[back to top]


HubSpot allows the creation of custom properties to store data on certain objects in HubSpot, such as contacts, companies, deals, tickets, and products. See Manage your properties for further information on how properties work in HubSpot. You can find your properties in HubSpot by going to Settings → Properties from your HubSpot account. 


Mapping DEAR fields to properties are typically used for export, but will be valid for import if the DEAR field can contain the HubSpot property value. Incorrect and empty values are ignored on Import operations without any log messages


User-defined properties for Companies in HubSpot can be linked to Customer fields in DEAR (Default HubSpot properties must not be changed from DEAR and thus cannot be linked).


The user can select which additional optional customer fields should be exported to HubSpot. 

  1. Click + to add a new customer field to export.
  2. Select a field to export to HubSpot. The following fields are available to select in the DEAR Customer field dropdown:
    • Currency
    • Payment Term
    • Tax Rule
    • Sale Account
    • Sale Price Tier
    • Comments
    • Sales Representative
    • Default Carrier
    • Default Location
    • Tax Number
    • Discount
    • Credit Limit
    • Attribute Set
  3. Map the customer field in DEAR to one of the available HubSpot fields. 
    • Properties are initially filtered in to a shortlist based on the DEAR field name (DEAR field name: Sale Account, shortlist will show HubSpot user-defined Company properties containing the words Sale or Account.
    • Click Show all properties to see full list of user-defined Company properties.
  4. Clicking Add property link will open a modal window where you can set a name for a new property, select the Entity (Company or Deal) the property applies to. 
    • HubSpot allows properties to have different types (e.g. number, date, boolean), but properties created from DEAR will only be type string (single-line text). 
    • Properties created from DEAR will be stored in HubSpot properties Dear Information group.
    • HubSpot property name will be created automatically removing all separators and changing the text to lower case. (e.g. My (GREAT) property 1!  will be converted to my_great_property_1)
  5. Save your changes when you have finished adding fields to export. 


You may need to make the field visible for a HubSpot customer if it is not a default field. Follow these steps in HubSpot:

  • On the Settings page for Customers click on Go to properties.
  • Search for the field in the list of deal properties to view in About this customer section:
  • In the Section editor, mark the selected field as visible.


Link HubSpot and DEAR sales order fields

[back to top]


Sales fields can be exported from DEAR as properties in HubSpot or vice versa. Properties are used to store data on certain objects in HubSpot, such as contacts, companies, deals, tickets, and products. See Manage your properties for further information on how properties work in HubSpot. You can find your properties in HubSpot by going to Settings → Properties from your HubSpot account. 


Mapping DEAR fields to properties are typically used for export, but will be valid for import if the DEAR field can contain the HubSpot property value. Incorrect and empty values are ignored on Import operations without any log messages


User-defined properties for Deals in HubSpot can be linked to Sale Order fields in DEAR (Default HubSpot properties must not be changed from DEAR and thus cannot be linked).


The user can select which additional optional sales fields should be exported to HubSpot. 

  1. Click + to add a new sales field to export.
  2. Select a field to export to HubSpot. The following fields are available to select in the DEAR Sale field dropdown:
    • Order Total
    • Order Status
    • Invoice Total
    • Invoice Paid
    • Invoice Status
    • Invoice Authorisation Date
    • Shipment Status
  3. Map the customer field in DEAR to one of the available HubSpot fields.
    • Properties are initially filtered in to a shortlist based on the DEAR field name (DEAR field name: Invoice Authorisation Date, shortlist will show HubSpot user-defined Company properties containing the words Invoice, Authorisation, or Date.
    • Click Show all properties to see full list of user-defined Deal properties.
  4. Clicking Add property link will open a modal window where you can set a name for a new property, select the Entity (Company or Deal) the property applies to. 
    • HubSpot allows properties to have different types (e.g. number, date, boolean), but properties created from DEAR will only be type string (single-line text). 
    • Properties created from DEAR will be stored in HubSpot properties Dear Information group.
    • HubSpot property name will be created automatically removing all separators and changing the text to lower case. (e.g. My (GREAT) property 1!  will be converted to my_great_property_1)
  5. Save your changes when you have finished adding fields to export. 


You may need to make the field visible for a HubSpot deal if it is not a default field. Follow these steps in HubSpot:

  • Go to Sales → Deals and choose Edit pipelines from the pipeline drop-down list.
  • Then, on the Settings page for Deals click on Go to properties.
  • Search for the field in the list of deal properties to view in About this deal section:
  • In the Section editor, mark the selected field as visible.


Enable multicurrency

[back to top]


If stores in DEAR with multiple currencies are connected to HubSpot, the multi-currency feature must first be enabled from a HubSpot account with admin privileges. This will ensure the correct currency code is exported with the DEAR sale. 

  1. Go to the HubSpot Account Settings (gear icon in the main navigation bar).
  2. Select Account defaults in the left navigation menu, select the Currencies tab and then click Add currency
  3. Add all currencies that are being used in DEAR stores. 
  4. Historical sales will be updated with the appropriate currency upon synchronisation. 


Products

[back to top]


See Product and Service Management for more information about Products in DEAR. 


See Use Products for more information about how Products are managed and used in HubSpot. Products in HubSpot can be viewed by going to Settings → Sales → Products & quotes from your HubSpot account. 


NOTE: If the connected HubSpot account does not have a HubSpot Professional Subscription, products cannot be added to Deals and Deals/Sales cannot be synchronised in either direction. HubSpot accounts without a Professional Subscription are still able to create and sync products and customers. 


On the Setup page, you can choose whether product information is exported to HubSpot or imported from HubSpot. This will alter the display of this tab. Bidirectional synchronisation is not available at this time.


Export Products to HubSpot

[back to top]


The From DEAR sub-tab will be visible on the Products tab if Products synchronisation is set to Export to HubSpot. Your DEAR inventory list will be visible on this sub-tab. You can filter the list using the dropdown fields at the top of the screen and also the search field. 


Products can be listed individually and in bulk. If auto-sync is enabled, any new products or updates to listed products will be exported automatically to HubSpot according to the frequency specified by your auto-sync settings. If auto-sync is disabled, new products and updates to listed products must be exported manually from this page. 


Default price tier and price tier currency is controlled from the Setup tab, and will be applied to automatic exports. Manual exports can select the price tier and currency. HubSpot does not perform any currency conversion, the value of the price tier in DEAR will simply be exported and the price tier currency applied. 

  • Tier 1 in DEAR is 340, Tier 2 is 300. DEAR organisation base currency is USD
  • When manually exporting products from DEAR, user selects Price Tier 1 and Price Tier Currency: EUR
  • When product is exported, product in HubSpot will have price 340 EUR.


NOTE: Price values of each tier must be edited from the product screen (Inventory → Products → [select product] → Prices). See Pricing and Price Tiers for more information


Product description type (Short description or Long description) and the default product Term (mandatory field in HubSpot) of uploaded products are configured from the Setup tab of DEAR HubSpot Integration.


List a product on HubSpot

[back to top]


Select a product from the inventory to open the Hubspot product management product window. 


Check that the selected Price Tier is correct and the Currency with which to upload the value to HubSpot. In the example below, this product will be exported to HubSpot with a price of 72.6 GBP - this will not be affected by your organisation base currency in DEAR. 


Click List on HubSpot to export the product. 


Bulk list products on HubSpot

[back to top]


Multiple products from your DEAR inventory can be listed at once on HubSpot. Use the filters and/or search field at the top of the page to show the products that you want to list in bulk. Click Refresh to make sure the inventory list has the most recent information from DEAR.


Products in your inventory can be filtered by Category, Product type, and Listing status as well as using the search field to search Product Name or SKU for text. 


Default price tier and price tier currency is controlled from the Setup tab, and will be applied to automatic exports. Manual exports can select the price tier and currency. HubSpot does not perform any currency conversion, the value of the price tier in DEAR will simply be exported and the price tier currency applied. 

  • Tier 1 in DEAR is 340, Tier 2 is 300. DEAR organisation base currency is USD
  • When manually exporting products from DEAR, user selects Price Tier 1 and Price Tier Currency: EUR
  • When product is exported, product in HubSpot will have price 340 EUR.


Click Start to begin the export to HubSpot. 


Update products on HubSpot

[back to top]


If the product has already been listed, the HubSpot product management window will instead show the option to Update the product rather than list on HubSpot.


If SKU, Product Name, Product Description, Price Tier or Price has been changed in DEAR, this option will export the changes to the product in HubSpot. If auto-sync is enabled, any updates to listed products will be exported automatically to HubSpot according to the frequency specified by your auto-sync settings.


Unlink or remove a product from HubSpot

[back to top]


Clicking a listed product will give you the option to Unlink the product or Remove from Hubspot

  • Unlink breaks the mapping between the DEAR product and the HubSpot product, however the product will remain in HubSpot. 
  • Remove from HubSpot completely removes the product from HubSpot. 


Import Products from HubSpot

[back to top]


The To DEAR sub-tab will be visible on the Products tab if Products synchronisation is set to Import from HubSpot. If you have products already imported and linked to DEAR products, they will be listed here. If not, the screen will be blank.  


Click Load Products to import all products from HubSpot into DEAR. If a matching product is found in DEAR and HubSpot is master of data this product will be updated with the information from HubSpot. If auto-sync is enabled, any new products or updates to listed products will be imported automatically from HubSpot according to the frequency specified by your auto-sync settings.


DEAR will attempt to map products according to the following rules:

  • First the system tries to match products according to SKU –  if a matching SKU is found then the two products will be linked. 
  • If no SKU match is found, the system then tries to match products according to product name. If a matching product name is found, then the two products will be linked. 
  • If no SKU or product name is found DEAR will create products automatically if no match is found for a HubSpot product. 
  • Default Price Tier, Price Tier Currency, Location, Product Type (Stock or Service) and Category of auto-created products are configured from the Setup tab of the DEAR HubSpot integration.


Removing a product from DEAR does not remove it from HubSpot and vice versa. 


Customers

[back to top]


Customers in DEAR are typically equivalent to Companies in HubSpot. Contacts associated with a Customer in DEAR are equivalent to contacts associated with a Company in HubSpot.


See Customer Management for more information about Customers in DEAR. In DEAR, Customers can have one or more associated contacts. 


See Create Contacts and Create Companies for more information about how Contacts and Companies are managed in HubSpot. In HubSpot, Contacts can be associated with a Company, or independent (not associated with any company). 


On the Setup page, you can choose whether customer information is exported to HubSpot or imported from HubSpot. Bidirectional synchronisation is not available at this time. 


Export Customers to Hubspot

[back to top]


The From DEAR sub-tab will be visible on the Customers tab if Customer synchronisation is set to Export to HubSpot. Your DEAR customer list will be visible on this sub-tab. You can filter the list using the dropdown fields at the top of the screen and also the search field. Click Refresh to make sure the most recent customer information from DEAR is displayed.


List customers on HubSpot

[back to top]


Multiple customers from DEAR can be listed at once on HubSpot. Use the filters and/or search field at the top of the page to show the customers that you want to list. Customers that have not yet been listed will have Listing Status: No


Click Refresh to make sure the customer list has the most recent information from DEAR. Click Start to begin the export to HubSpot. 


You can export optional customer fields (e.g. Sales Representative, Credit from DEAR as properties on HubSpot – see Link HubSpot and DEAR customer fields for more information. 


You will receive a notification showing if the listing has been successful/unsuccessful. 


NOTE:
Customers without Contacts in DEAR will be exported to HubSpot as a Contact with no associated Company.

Customers with at least one Contact in DEAR will be exported to HubSpot as a Company. Only the default Customer Contact from DEAR will be exported as a Contact in HubSpot. If no default is specified, the first contact with an email will be exported instead.

If DEAR Customer status is set to Deprecated, then all HubSpot Company's contacts will be exported with Inactive status.



Update customer information

[back to top]


If the customer has already been listed, pressing Start will update the contacts in HubSpot with the most recent information from DEAR. 


If Name, Phone number, Email or any Custom Fields has been changed in DEAR, this option will export the changes to the product in HubSpot. If auto-sync is enabled, any updates to listed products will be exported automatically to HubSpot according to the frequency specified by your auto-sync settings.


Import Customers from HubSpot

[back to top]


The To DEAR sub-tab will be visible on the Customers tab if Customer synchronisation is set to Import from HubSpot. If you have HubSpot contacts already imported, they will be listed here. If not, the screen will be blank.  


Press Refresh to ensure the most recent customer information has been loaded from HubSpot. Click Download Contacts to import all companies and contacts from HubSpot into DEAR. If auto-sync is enabled, any new Hubspot contacts or updates to listed contacts will be imported automatically from HubSpot according to the frequency specified by your auto-sync settings.

  • If a Customer is found in DEAR with a matching name to a HubSpot company, and HubSpot is master of data this customer will be updated with the information from HubSpot.
  • If a Customer contact is found in DEAR with a matching email address to a HubSpot contact, and HubSpot is master of data, this contact will be updated with the information from HubSpot. 
  • If no matching contact is found in DEAR, new customers and customer contacts will be created automatically. 
    • A Company from HubSpot will be imported as a Customer.
    • A Contact with a Company will be imported to a Customer as a Customer Contact (HubSpot company will be the Customer).
    • A Contact without a Company will be imported as a Customer with one contact (unless Ignore contacts without organisations setting in setup tab is enabled). 


Customer fields Customer Name, Contact Name, Contact Phone number and Contact email will be imported from HubSpot. If a new Customer is created, default Customer base currency, Revenue account, Payment Term, Default customer taxation rule and Default address type of imported customers are configured from the Setup tab of the DEAR HubSpot integration.


Associate one Contact to many Companies or Deals

[back to top]


HubSpot has recently released its API v4 in Beta stage, however, some features are already available for developers. One such feature is the ability to associate one contact to multiple companies or deals. DEAR can now also use this feature. 


Previously, HubSpot only allowed Contacts and Customers/Companies to be associated one-to-one. Now, each contact can be associated with multiple companies. Contacts with duplicate emails in DEAR will be exported as a single contact to HubSpot, associated with each Customer/Company. 

  • Example: if we have 3 DEAR Contacts:
  • Peter Blood (corsair_1@mail.uk) in the Arabella company,
  • Henry Morgan (corsair_1@mail.uk) in the Admiralty company and
  • Richard Worley (corsair_1@mail.uk) in the Revenge of New York company
  • Only Peter Blood will be exported to HubSpot. Arabella, Admiralty and Revenge of New York companies will be associated with him (and vice versa).


You will need to enrol in HubSpot Beta from your HubSpot account for this feature and the integration in general to work correctly - This is free for paid accounts.


If you have an Association in HubSpot associating Contacts with Companies, DEAR will use this to link contacts and companies

  • (Click the gear in the top right of the screen to open Settings, then go to Objects > Customers in the menu, then select the Associations tab, Click Create association label, Associate Contacts with Companies. Next, name the association label anything you would like. Create the label to finish)

If you do not already have an  Association with these settings in HubSpot, DEAR will create one automatically during export, named Multiple relationship


Sales

[back to top]


See Processing a Sale for more information about how sales are managed in DEAR.


See Deals for more information about deals in Hubspot.


On the Setup page, you can choose whether sales information is exported to HubSpot or imported from HubSpot. Bidirectional synchronisation is not available at this time. Sales are mapped according to sale order number.


Export Sales to HubSpot

[back to top]


If Sales synchronisation is set to Export to HubSpot, then Customer synchronisation and Product synchronisation is automatically set to Export to HubSpot as well.


Sales appear for export as soon as sale quote is created. Sales for export can be filtered by starting date and/or using the search field. New sale orders where DEAR status is mapped to a HubSpot Deal stage will be exported automatically when they reach this stage. If Sale changes status (advances) in DEAR, the stage in HubSpot will be updated. If auto-sync is enabled, any new sales or changes in sale status will be automatically exported to HubSpot according to the frequency specified by your auto-sync settings. New and modified sales can also be exported manually from this page by pressing Start


Click Refresh to make sure the sales list has the most recent information from DEAR. You can export optional sales fields (e.g. Order Total, Invoice Status, Shipment Status) from DEAR as properties on HubSpot – see Link HubSpot and DEAR sales fields for more information. 


New customers and products associated with a sale will be exported to HubSpot automatically in the same operation. If one of these entities fails to export, the sale export will be skipped and an error message will be displayed.


IMPORTANT NOTE: When sale synchronisation is set to Export to HubSpot, updating the deal stage in Hubspot DOES NOT change the sale status in DEAR. 


Import Sales from HubSpot

[back to top]


The To DEAR sub-tab will be visible on the Sales tab if Sale synchronisation is set to Import from HubSpot. If you have HubSpot sales already imported, they will be listed here. If not, the screen will be blank.  


Press Refresh to ensure the most sale customer information has been loaded from DEAR. 


Click Download Sales to import deals from HubSpot into DEAR as sales. A pop-up window will appear to confirm the date from which you wish to import orders. Orders created on or after the selected date and which have reached the trigger stage specified in Link HubSpot deal stages and DEAR sale statuses will be imported. HubSpot deals which have not reached the trigger stage defined in Setup will not be loaded from HubSpot.


If auto-sync is enabled, any new HubSpot deals will be imported automatically from HubSpot according to the frequency specified by your auto-sync settings.


IMPORTANT NOTE: DEAR loads deals from HubSpot only once when deal reaches the selected trigger stage. According to the stage mapping in Link Hubspot deal stages and DEAR sale statuses, DEAR will create the imported sale with one of 4 statuses: Estimating, Estimated, Ordering, Ordered. Other DEAR sale statuses are not supported – this is because they require shipping and payment information to authorise in DEAR which are not mandatory fields in HubSpot.

If there is no status mapping specified for the Hubspot deal stage, the sale will be created in DEAR with Estimated (Quote Authorised) status.

If the Hubspot deal stage is mapped to an unsupported DEAR sale status, the sale will be created in DEAR with Estimated status.

If you change a deal stage in HubSpot for any deal that has already been loaded in DEAR, the relevant sale status in DEAR will not be changed


If Sales information is imported from Hubspot, then Customer information and Product information is automatically imported from Hubspot as well. 

  • If a Hubspot deal is assigned to a contact that exists as a customer in DEAR, the sale in DEAR will be linked to that customer in DEAR. If a Hubspot deal is assigned to a contact that does not exist in DEAR, the contact will be imported as a Customer in DEAR according to the steps laid out in Import Customers from Hubspot
  • DEAR will attempt to map products in a Hubspot deal to products in DEAR according to the steps laid out in Import Products from Hubspot, and create products in DEAR if an existing matching product cannot be found. 


Log

[back to top]


Clicking the Log tab opens the Hubspot Synchronisation History page. This displays all previous synchronisation details.


Press Refresh will refresh the log history with the most recent information. 


Each time the user or DEAR downloads sales, products, or customers the appropriate record is added to the operations log, which also contains information about results of downloading, including the date, time, count of downloaded and updated items, and whether the action was performed manually or automatically by the system. 


Errors which occur during sync will be logged here with an explanation of the likely cause. Some errors will contain a link to a downloadable xls file where you can find further details. 


Disconnect from Hubspot

[back to top]


At the bottom of the Setup tab, click Disconnect from HubSpot to completely disconnect HubSpot from DEAR. This will remove all links and mapping between HubSpot and DEAR, however, it will not remove any products, customers or sales from HubSpot. 




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.