Create a forecast report that can help users know how much to re-order based on past sales
It would be a great tool. Now I am straggling to collect data from past to do it.
We do something similar to Odhran's process using the API and some Python code to pull and massage the sales and inventory data, and generate a spreadsheet. A built in report would be much cleaner.
Great idea, we currently use a formula on google sheets for this. 30 day sales + reorder level - current stock
is this similar to reorder calculator feature request?