A list of every field included in the Sync for Magento 1.x and 2.x

All these fields will be automatically created in your HubSpot and stored in the Contact Properties when you start the Sync.


Contact Information


First Name 

Last Name 

Email 

Phone Number

Lifecycle Stage 

    - Subscriber, Customer  

Street Address 

City 

State/Region

Country 

Postal Code


Magento Lifetime Statistics


Average Total Per Order 

Avg Item Price 

    - Avg price across all products ordered

Avg Items per Order 

    - Avg QTY

Magento Customer Since 

    - Date of account creation

Newest Order Date

Number of Items Ordered (qty) 

    - In Newest Order

Number of Orders 

    - Total orders Lifetime

Oldest Order Date 

    - First Order placed

Order Totals (LTV) 

Purchased Product Category URLs  

Purchased Product Names 1/2

   - Names of products purchased separated by pipe char (|), ordered newest to oldest

Purchased Product SKUs


Magento Customer Attributes


Customer Id

Group Id

Customer Group

Store Id

Website Id

Dob

Gender

Is Active

Middlename


Newsletter Subscription Status and all the custom attributes (unlimited)


Magento Customer Recent Activity


Ip Address

Compare

Login At

Logout At

Session First Visit At 

Session Last Visit At

WishList

Store Id


Magento Last Order Summary


Base Currency

Comment

Coupon Code

Created At

Discount

Grand Total

Increment Id

Shipping

Shipping Description

Status

Store Id

Subtotal

Tax

Item Product Img 1-6

Item Product Name 1-6

Item Product Configurable Name 1-6

Item Product Category Name 1-6

Item Product Price 1-6

Item Product Qty 1-6

Item Product Sku 1-6

Item Product Url 1-6

Item Cross-Sell Img 1-6

Item Cross-Sell Name 1-6

Item Cross-Sell Sku 1-6

Item Cross-Sell Url 1-6

Item Related Img 1-6

Item Related Name 1-6

Item Related Sku 1-6

Item Related Url 1-6

Item Upsell Img 1-6

Item Upsell Name 1-6

Item Upsell Sku 1-6

Item Upsell Url  1-6


Magento Last Abandoned Cart Summary


    -Items from an incomplete purchase are known as a “Quote”

    -The Connector syncs information from up to 3 products in the cart as well as 3 Related Products, 3 Cross-Sell Products and 3 Upsell products (if they exist for the 3 initial products)


Store Id

Base Currency

Created At

    -When the Abandoned Cart was created

Coupon Code

    -This is only populated if a coupon code was used in the cart.  It is NOT a field to generate a custom coupon code for the Abandoned Cart email

Grand Total

Subtotal

Item Product Img 1-3

Item Product Name 1-3

Item Product Price 1-3

Item Product Quantity 1-3

Item Product Sku 1-3

Item Product Url 1-3

Item Cross-Sell Img 1-3

Item Cross-Sell Name 1-3

Item Cross-Sell Sku 1-3

Item Cross-Sell Url 1-3

Item Product Category Name 1-3

Item Related Img 1-3

Item Related Name 1-3

Item Related Sku 1-3

Item Related Url 1-3

Item Upsell Img 1-3

Item Upsell Name 1-3

Item Upsell Sku 1-3

Item Upsell Url  1-3


Next fields will be automatically created in your HubSpot and stored in the Deals Properties when you enable the Deals sync process.


Magento Order Summary




First Name

Last Name

Email

Phone

Company

Street address

City

State

Country

Zip

Store Id

Order Id

Order Status

Order Created At

Order Currency Code

Order Discount Amount

Order Grand Total

Order Subtotal

Order Tax

Order Shipping

Order Shipping Description

Coupon Code

Order Comment

Product Name 1-6 (Order)

Product Sku 1-6 (Order)

Category Name 1-6 (Order)


Product Properties



Name

Description

SKU

Price

Product Image

Product Url