Shopify Integration - How do I create a list of contacts who have purchased specific product?
May 7, 2021 4:23 PM
Happy Friday! I have a HubSpot/Shopify integration question I could use a little help with. I'd like to create a list in HubSpot of folks who have purchased a specific product in Shopify.
I keep seeing the suggestion to use line item properties. I can use the line item property "name," to identify anyone who has added the product to their shopping cart. I don't see a line item property that indicates a purchase has been made. So, using "name" alone will include anyone who has abandoned cart or all of the other deal stages that exist before making an actual purchase.
I've also tried using deal properties. I can use the deal property "deal stage" to identify anyone who has completed a purchase. I don't see a deal property that identifies the product being purchased.
I've tried using line item "name" AND deal stage "shipped," but HubSpot isn't smart enough to know that I want to refer to the same deal. So that returns a list of anyone who added the product to their shopping cart AND also bought something at any point.
I'm sure that I'm missing something obvious. Anyone have any ideas?