analytics query on products sold

Shopify Discussion
,

Topic summary

A developer is building a Shopify site and needs to query monthly product sales data, specifically filtering for two product types while accessing custom properties stored in cart line items.

Initial Approach:

  • Attempted using Shopify’s built-in analytics tab and ShopifyQL feature
  • Uncertain whether to query orders or products tables
  • Questioned if native analytics tools could handle this use case

Resolution:
The developer confirmed their suspicion that Shopify’s native analytics couldn’t achieve the desired result. They implemented a workaround using:

  • Daily order fetching instead of monthly bulk retrieval
  • Data filtering and storage in Google Sheets
  • Integration automation via ‘Make’ platform

This approach addresses concerns about handling large data volumes in single monthly fetches while providing the flexibility needed for custom property analysis.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

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

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 !

2

Hey! :waving_hand: 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:

1 Like
3

Hey Jezco and Innoxcel thank you for your answer ! :slightly_smiling_face:
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

1 Like