analytics query on products sold

[T1Boy]

Hi everyone,
I want to store some data on a Shopify website I am currently developing. hopefully I'd find sone help here 🙂

First of all when I'm selling products I add properties attached to in the [properties] key in cart. It is some infos about the customers. And if I understand the structure well I can find it in the line_item of every order. 

My goal is to query all products sold during the month and have all of them displayed in rows. I also want to select products of only two different types.

I tried different filter on the analitycs tab of the admin Panel but could not manage to get the result I wanted. I also discover the new ShopifyQL feature. I have some base in SQL but I'm still a bit confused about the structure of tables. Should I query the orders ? or Products ?

My main question is whether it is achievable with the analytics tool, or will I need to use a third-party app or a custom app with adminAPI to treat the data more flexibility? 

Thank you !

[InnoXcel]

Hey! 👋 You're definitely on the right track, and it's great you're exploring both the analytics tools and ShopifyQL. Let me try to break it down for you:

[T1Boy]

Hey Jezco and Innoxcel thank you for your answer ! 🙂
You confirmed my feeling about it, this is why I wanted to confirm if it was doable before trying to go to deep into it.
I also feel like this would be a lot of data to retrieve on a single monthly fetch.

I ended up fetching all orders every day, filtering the data I want, and stacking it in a Google spreadsheet every month using integration tools called 'Make'.
Thank you again for your answer

[Mark_Mipler]

Hey there, @T1Boy 
Glad to hear you’ve found a solution that works for you! Using Make to fetch and filter orders daily sounds like a solid approach, though I understand it can be quite time-consuming with larger datasets.

If you ever need a more streamlined solution, Mipler might be a great option. With Mipler, you can create custom reports, filter data easily, and avoid the need for manual data fetching every day. It could save you a lot of time and effort in the long run!

Mipler also offers a 7-day free trial, so you can try it out and see if it fits your needs.

You can download Mipler here. Let me know if you need any help getting started!