Reviewing Customer Product History During Order Creation

[avisquatch]

Hi all! Apologies in advance if this is the incorrect place to ask this question - if any mods feel the need to move, please feel free to do so.

Would like to utilize the Shopify API at the time of order creation, and curious if there is API documentation around searching the history of a customer’s orders and identifying if any orders that were fulfilled contained a specific product?

High-level, I’d like to make a determination at the time of order creation if a customer has purchased a type of SKU either historically, or within the specific order being reviewed (identified either by product SKU or SKU variant ID), and then if not, making a decision based on that information (e.g., adding a customer tag, or editing + adding something to that order).

Thank you in advance for your input!

[ShopifyDevSup]

Hi avisquatch,

Yes here is some helpful API documentation around gathering that information:

• [The GraphQL ‘orders’ query] has a customer_id query filter which can be used to gather order history
• [Details about the order object] and [details about the lineItem object] to help with building the GraphQL query
• When building the GraphQL query it’s important to be mindful of the [API Rate Limits] around query costs and to request the minimum possible info to avoid having the query rejected as too expensive. Experimenting on a test store with the [GraphiQL Explorer App] is a good way to get a feel for that limit and a basic minimal example is below:

{
orders(first: 5, query: “customer_id:123456”) {
nodes {
lineItems(first: 10) {
nodes {
unfulfilledQuantity
variant {
displayName
}
}
}
}
}
}