How to Analyze and Query Shopify Datasets

[jenE]

Hi Community, 

What is your best practise to analyze and query all your Shopify data?
Do you use the API to export the data and if so where do you send it to / which tools do you use for analysis?
I would prefer to work with SQL or Python for quering. 

I tried the ShopifyQL Notebooks app but it doesn't give me access to all available datasets. 

Thanks 🙂

[Milton_james1]

Hey JenE,

I've tested SuperU, and it's excellent for Shopify data analysis—very user-friendly. They even provide a 30-day free trial. I suggest exploring it for an improved solution. I'm open to discussing my experience with you. Visit the SuperU for more details.

https://www.youtube.com/@superU-AI/videos

[mattcrane]

Hi JenE,

Were you ever able to come across a good solution? I thought I'd be able to do everything with ShopifyQL notebooks as well ... but running into some really surprising limitations ....

Any advice or feedback would be helpful

[jenE]

Hi Mattcrane, 

We figured that setting up your own datawarehouse, using the Shopify API, will be the only solution that gives us the full scope and flexibilty to work with the data as needed. 

Best