Need Inventory Tracking Help - All Day Counts

Site URL: https://www.85thdayllc.com

Desperately need a more intuitive inventory tracking system. The export by product or export all products option is a huge mess of a spreadsheet. Need a way to export an "all day count" of how many units of a specific product has sold in a given date range. For example, we have a bakery and need a way to tell our baker how many loaves of sourdough he sold that day so that he can plan for his next bake. But, ideally that would apply to all 128 items in our online grocery market so we get an "all day" count of what has been sold each day, rather than an exhausting list organized by order, where we have to go in and tally up sales manually. THERE HAS TO BE A SMARTER WAY. Please let us know if you have any suggestions for ways to track this!

This would be extremely useful. We have the same issue. Hopefully someone with more experience can chime in. 

I think we may need to do the filtering based on the downloaded spreadsheet with macro/script, or else we have to parse the order confimation email into google spreadsheet and extract data there

On 12/15/2020 at 8:30 PM, Bct said:

This would be extremely useful. We have the same issue. Hopefully someone with more experience can chime in. 

I think you should take advantage of Commerse API to tweak how the data is returned