We are new to Shopify and are trying to figure out the best report to run to figure out what items need to be reordered to have our Shop properly stocked. We have appox 300 vendors we work with, and over 12,000 Skus, so we need to be able to pull reports by vendor or and/or category.
Our previous systems had reports the showed unit sales by vendor, by item for specific time periods, along with the quantity we have on hand, and the quantity we have on order. This would help us forecast and order accordingly (ie: for holiday, if we sold 12 of a specific ornament in one week, and we had six weeks left in our selling period, have 24 units on hand, and another 24 units on order, mathematically, we would need to reorder another 24 units to ensure we had enough to sell 12 units each week for the next 6 weeks. However, I cannot figure out any report in Shopify that shows that info all in one place.
Wondering if there is a report that exists that has this information and if not, how are other retailers managing their reorders for their store inventory?
Secondly, I am wondering if there is a way to schedule reports to be emailed, daily, to recipients? Having the gross sales emailed to us at the close of business each day was a great way for us to see where we are with meeting our goals for the week/month.