# 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