we are working on a datawarehouse project and need to pull data from our customer´s shopify database.
We want to analyse inventory stock quantity and stock value, also do market analysis, traffic analysis, top landing pages, conversions, revenues and others.
Shopify offers REST APIs for data pulling but not all our requirements can be fulfilled.
Our question are wether
- there is a plan we can order, like shopify partner plus or AdminAPI that allows data pulling all data fields?
- are there experiences in data pulling from shopify, deeper than the published REST API queries?
I am new to shopify requirements, that´s why my questions.
2
Answers
I am not sure that if it can solve your problem. Currently, our company uses an online tool called Acho Studio to retrieve Shopify data. It’s like ETL tools that allow you to connect to Shopify and export data to somewhere. The difference is that the tool hosts a sever, so you can store data on it. Also, you can write SQL queries or apply some actions to do analysis.
This is the codes snippet i am using
I am able to pull the Order data and other data such as refund, .etc