---
# System prepended metadata

title: Hubspot Integration

---

# Hubspot Integration
## Retailer
* Step 1: 
    - [ ] 	 Investigate doba sytem to find _all_ user data
        * The idea here is to make sure it's stuff that Hubspot could be using. We want Hubspot to be our CRM as it's made for that.
        * **wholemark.User**
            * user_id
            * register_date
            * firstAccessAvailDate
            * ip
            * last_login
            * status
            * username
            * password
            * password_last_change_date
            * first_name
            * last_name
            * email
            * phone
            * addr1
            * addr2
            * city
            * state
            * postal
            * country
            * accept_terms
            * requires_bill
            * owner
            * cancel_date
            * integration_id
            * referred_from_partner_id
            * partner_campaign_id
            * package_id
            * survey_coaching
            * survey_merchant
            * survey_search
            * survey_website
            * survey_ebay
            * resource_access
            * ebay_auth_token
            * ebay_auth_token_is_valid
            * referral_code
            * affiliate_id
            * access_sub_id
            * warehouses
            * price_tier1
            * price_tier2
            * price_tier3
            * price_tier4
            * last_shuffle
            * DNC
            * last_call_id
            * user_flags
            * time_zone
            * last_export_date
            * default_address_account_id
            * default_subscription_payment_account_id
            * default_order_payment_account_id
            * company_name
            * company_website
            * coach
            * federal_ein
            * tax_id_state
            * tax_id
            * pro_fax_location
            * vip_access
            * last_update
        * **wholemark.User_Address_Account**
            * user_id (join key)
            * first_name
            * last_name
            * addr1
            * addr2
            * city
            * state
            * postal
            * country
            * phone
            * address_status
            * trust_level
            * created_date
        * **wholemark.User_Attribute**
            * user_id (join key)
            * attribute
            * value
            * last_update
        * **wholemark.User_Attribute_Text**
            * user_id (join key)
            * attribute (_Values include_: marketplaces_used, product_categories, selling_channels, primary_product_category, ordermotion_httpbizid)
            * value
        * **wholemark.User_CatalogRoot**
            * user_id (join key)
            * category_id
            * last_update
        * **wholemark.User_Contact_Log**
            * 
* Step 2: 
	- [ ] Check your list of **Doba fields to be updated** (`dftbu`) against the properties in HS
	- [ ] Make suggestions to Konan/Angie of any custom properties that need to be built
	    * There could be fields we want, but don't currently have included. These properties should be approved by Konan/Angie before anything is done.
* One-way (for now)
	- [ ] Pull all info from `User`, `User_Address_Account`, maybe more
* Step 3:
    - [ ] Update anything in Hubspot based on last update.
        * We might be running this every minute to update whatever has changed in Doba.
> [name=Konan Palmer]
> the `last_update` field is only found on the `User` table, so we may have to find another solution for the other tables

## Supplier
* **Don't start on supplier integration until we have another conversation**
* Start with two-way street
* all info from `Supplier`/`Supplier_Info`
* Downsize Supplier Editor to only essential items; 
## Partners
* Nothing now