Shopify gives current inventory data. Can Data Export report inventory for a past date?
Shopify's api provides only current inventory data and it does not track past inventory quantity.
However, the past inventory quantity can be calculated manually.
For example, to calculate the past inventory for 2017, information on all inventory quantity added, along with product title and SKU must be provided from Jan 1 2018 till date.
After that, we will use the calculation: "Dec 31st, 2017 = Units sold from Jan 1st 2018 to till date + Current Inventory" to calculate the past inventory for the year 2017.
Or To calculate the past inventory quantity for a particular month, say March 2018, then all inventory quantity added, along with product title and SKU must be provided from April 1 2018 till date.
Once the necessary data is provided, we will use the calculation: "March 31st, 2018 = Units sold from April 1st to till date + Current Inventory" to calculate the past inventory for March 2018.