Customer total lifetime line item quantity

[WayneAlan]

Hey folks,

Anyone know if there's an api object or way to retrieve a customer's total lifetime product quantity ordered? I'm trying to get a setup going with Flow that assigns a customer a tag based on the total quantity of items they've ordered in their lifetime. So for example -

Alyssa Romero

Total Shirts Ordered: 342

Any pointers would be fantastic. Thank you.

[Andrii_Mipler]

Hello @WayneAlan,

This is Andrii from Mipler: Advanced Reports and I'm excited to connect with you here!

It looks like you're looking for a way to retrieve a customer's total lifetime product quantity ordered. While Shopify’s API might not directly provide this, Mipler can help you achieve exactly what you need.

Mipler offers a Sales by Customer report, which you can customize to display the total number of items a customer has ordered over their lifetime. To do this, simply enable the filter for the all time and add a column for the number of items sold.

Here's an example of such a Sales by Customer report with fake data:

You can also open the report in your browser and customize the filters through the Quick Access & Sharing feature available in Mipler.

Please check it out - https://app.mipler.com/public/1e0b0a8b-5f75-4740-a927-cf375cb095c0/view/8cp1rw3m

You can customize the report by adding the required filters and columns. For example we have added a filter for customer name if you want to find some specific ones, and an Admin Url column that contains a direct link to the customer in your Shopify admin, which can help you in creating tags.

Feel free to reach out if you need any assistance - our support team is always here to help!

You can explore it through the following link: Mipler: Advanced Reports

We offer a free 7-day trial, and our support team is ready to create any report you need.

Just send us a request, and we’ll provide a complete solution promptly.

Looking forward to hearing from you soon! 🙂