Contact list - purchased line item (orders)

Hello,

I am trying to make a list of our Shopify customers who have bought a specific item and can’t seem to get the number of customers to match when I use an order-based list. I can see why they would differ by a small amount as some people may have bought two of the products (so more orders than contacts)

HubSpot Order-Based ListShopify Customer Report

So, I am trying to make a contact-based list that looks for the line items associated with the contact. When I do that, the list size is 0.

Hubspot Contact-Based List

Any suggestions on how to parse using the data from Shopify in Hubspot to collect the list of 460 people would be great!

Hi @AHibshman

The issue is that line items are only associated to deals, and not to contacts, hence you getting zero there.

I would try the following, create a contact list that checks against orders, and the order list you created. Normally you can build list that check across objects and then select a list membership filter.

I’ve not worked with the order object myself yet but that’s the same approach I would use to find contacts who have deals that contain certain line items.

Frank

Thanks for the help, @franksteiner79!