Calculate the sum of specific line item value for Customer over a period of time

[Sam-Rise-ai]

Hi, 

I'm looking to, under specific conditions, sum the value of one specific line item/product purchased by a customer. 

e.g. Customer A buys "product 123"

Get all orders a Customer A has made in the past week

Sum the total value of "product 123" that customer has bought in the past week. 

I was thinking something like this: 

If this isn't possible, I would also be happy with a product count option, however, at the moment, the only action I can see is a Sum of the quantities of ALL line item properties over a specific period. 

Any help here please?

[DaveMcV · Accepted solution]

Hi @Sam-Rise-ai,

The count and sum options do not currently work conditionally, but you'd be able to use the Run code action to build JavaScript to sum or count that data and make it available to downstream steps.

More information on how that action works can be found in the Shopify Flow documentation for Run code

Hope that helps!

[Sam-Rise-ai]

Thanks @DaveMcV, I'll give that a go. 

Much appreciated