We are pulling all the Shopify data into a SQL database using a platform called Panoply. From there we are putting data into Tableau for analytics.
I have been able to recreate just about all the metrics we need for reporting, but have not been able to produce any sort of inventory report. See image below as an example of what we are pulling from Shopify.
This is summarized, but we are trying to get raw data for Tableau. I have been able to get a table that shows quantity sold by product, but Have not been able to figure out what tables are used to get starting quantity or ending quantity. EG, I can see things going out, but never coming in. Obviously Shopify has the data somewhere, but I haven't been able to identify where.
The tables I am using to get items sold are shopify_orders_order_line_items joined with shopify_orders_order.