We sell specialty meats on our ecommerce store, and operate on a monthly order cycle. Each month on our order deadline we pull the web store data, order our product from our ranching partners, and handle fulfillment. All this back-end work is done initially in Excel, then posted to Google Sheets so that multiple managers can access. Need guidance optimizing this back-end work and automating reporting where possible.
We will show how we use these sheets today, what the data extract from the web site looks like, and what our desired requirements would be.
I'm an Excel-power user, but this is getting beyond my capabilities ;) Looking for somebody to take this to the next level and suggest solutions.