databasegoogle-playshopifyextractinventory

Shopify data pulling into own database


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

I am new to shopify requirements, that´s why my questions.


Solution

  • 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.