HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hello all,
Welcome to the second in a series of videos focusing on the native integration Hubspot provides with Shopify. In the last post I spoke about "How to setup the shopify integration". In this post I'm going to concentrate on how data syncs between the systems once the integration is in place. Check out the video below for more information:
I've also included some useful FAQ that should help you to better understand how the data syncs and what to expect from the integration.
1) Is the integration bi-directional?
No, the integration is unidirectional/one way. In otherwords data is only ever going to sync from Shopify to HubSpot and not the other way around. This is intentional. If you think about it, the data stored within Shopify is transactional data that should never be updated from any other source. You are certainlly free to modify the data in HubSpot once it syncs but it won't be reflected in Shopify.
2) What data syncs from Shopify to HubSpot?
The table below represents the data that syncs from Shopify to HubSpot:
Shopify
HubSpot
HubSpot Properties
Products
Products
Title, Body_HTML, Created at, Handle, Images, Product type, Published at, Published scope, Tags, Vendor, Price
Customers
Contacts
Accepts marketing, Created at, First name, Last name, Email, Phone, Note, Orders count, Tags, Tax exempt (checkbox), Verified email (checkbox), Street address, City, Country, State/Province, Zip code
Orders
Deals
Abandoned checkout URL, Buyer accepts marketing, Customer ID, Cancel reason, Cart token, Cancelled at, Created at, Currency, Financial status, Fulfillment status, Landing site, Name, Note, Order number, Processing method, Referring site, Source name, Subtotal price, Taxes included, Token, Total discounts, Total line items price, Total price, Total tax, Total weight
3) Does the integration support custom properties/metafields?
No, the integration only supports the properties listed in the table above. Custom properties in Shopify are known as metafields. You can use Shopify metafields to add custom fields to objects such as products, customers, and orders. Metafields are useful for storing specialized information, such as part numbers, customer titles, or blog post summaries. Creating and working with metafields requires you to use a third part Shopify app or their API. More information on that can be found here.
4) Can I control what data syncs into HubSpot from Shopify?
No, the integration will sync over data as it is created in Shopify. For example an Order will be created as a Deal. A customer will be created as a Contact.
5) Why do the deals in my abandoned cart stage have no associated contacts?
This can happen if a visitor goes to the checkout page and does not enter any details. Additionally if they enter the details but do not click to "Continue to Shipping" no association will occur. This is how Shopify works - An order and a customer are only created on the back end when the "Continue to Shipping" button is pressed.
5) How do deals move between the stages in the eCommerce pipeline?
The deal stage in HubSpot is influenced by the status of the order in Shopify. There are 6 pre-defined stages. Namely "Checkout Abandoned", "Checkout Pending", "Checkout Complete", "Processed", "Shipped" and "Cancelled".
When someone reaches the checkout page of Shopify a deal is created in hte "Checkout Pending" stage.
If a deal has been in the "Checkout Pending" stage for 24 hours it will move into the "Checkout Abandoned" stage.
If an order is completed and payment is captured a deal will move to the "Processed" stage.
When an order is fulfilled a deal will move to the "Shipped" stage.
If an order is cancelled a deal will move to the "Cancelled" stage.
I hope that this video has helped you to better understand what data syncs from Shopify to HubSpot and what needs to happen in order to trigger that sync. More information on how to use the integration can be found here.
If you've any questions please do not hestiate to comment below. I'm more than happy to help however I can!
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Currently, there is no way to sync the UTM parameters without creating a custom app costing upwards of $2,000 according to a HubSpot representative, when in fact, this should have been built into the native integration.
1) Will the UTM parameters on Shopify be available soon in the Shopify-HubSpot integration field mappings?
2) Why did the HubSpot team leave out readily available API calls (data points) in the CRM integration?
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hi,
Recently some abandonned deals have been disapearing from the automated pipeline, and I get a message saying that the Deal was moved from Checkout Pending to a deleted stage.
The Hubspot pipeline settings were not changed manually on our side. I guess it means that something changed on Shopify's end? How can I reset the integration so that deals stop disapearing?
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hi Jack!
I have a client that would like to sync their SKU's in Shopify to their Hubspot Products. Is there a work around for this sync? Maybe a product spreadsheet upload with SKU's?
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Thanks for the idea. I've tried long and hard but cannot work this one out.
It appears that Shopify does not add the cost price of items to an order so when I retrieve an order the data is not there. In HubSpot, I have fields into deals and product to handle cost and margin, but I need to find the raw data to bring this in.
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
We have created custom fields in HubSpot Deals so we can track buy price and from there we can track margin as opposed to just Amount. We'd love to bring the buy price of products into Deals from Shopify. Is there any way we can do this?
integrated Shopify with Hubspot for a client, the contacts and deals are coming in correctly. As we are migrating from Woocommerce, we already have a lot of customers in Hubspot that I need to get into Shopify. The sync does not pick them up, any way to force it? Does it supposed to sync this way, it is not cleaar in the knowledge base.
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
@jackcoldrick the links in point 3) in the original post aren't directing to a page that exists anymore. We're looking for a solution of how to sync custom product fields from Shopify to HubSpot so any help would be appreciated!
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hello - We're considering integrating Shopify with our Hubspot so that our customer service team who is responding to customer inquiries in our Shared Inbox can see the customer's current order, and order history.
Am I making the right assumption that the Shopify / Hubspot integration would provide this view?
If someone could share a screenshot of what this would look like in the Share Inbox, that would be super helpful! Thank you!
That's correct. All of the previous orders will be visible from the right hand side bar of the conversations inbox. I've included a screenshot of my own portal showing this:
If more information relating to the order is required the agent can then simply click in to view more details.
No problem glad it helped. With regards FB Messenger you would need to ask for their email address as part of the chatflow otherwise we have no way to associate the conversation to the contact record in the CRM and pull in the relevant information.
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hi Jack,
Got it - thanks for the info.
I just integrated Shopify, and I followed the steps to sync data so that data goes "one-way" from Shopify to Hubspot. But when I go to the Shared Inbox, I'm not seeing anything in the Deal section on the right panel for customers who I know made a purchase.
Is there another step that I'm missing to have the Shopify order history appear in the Inbox?
HubSpot Native Shopify Integration 101: How data syncs from Shopify to HubSpot
SOLVE
Hey everyone, I've released the 3rd video discussing how you can segment contacts, deals and products from within HubSpot using this data. More information here.