Ideas/Needs for stock analysis about grocy HOT 11 OPEN

How about analysis of spoiled products vs Product Group?

• Percentage of spoiled products vs Product Group, like a pie chart
• Historical data of the value (based on tracked prices) of spoiled products, filterable by Product Group
  • "What is the total cost of spoiled food over the last week"
  • "Is the cost of Vegetable spoilage going down or up" by Product Group
• List of most often spoiled products, or most spoiled per Product Group ("buy less of these"). Maybe flag these visually somehow on product page/shopping list as 'Often Spoils'

from grocy.

One I thought of was "what recipe has consumed the most"

from grocy.

@oakbrad: Great ideas, thanks!

One I thought of was "what recipe has consumed the most"

This would involve to track on consume for which recipe this was, can be of course done automatically when using the "consume this recipe"-button. We don't have this data as of now - will be tracked in #138.

from grocy.

Was accidentaly closed by a wrong commit message in 8020f92...

from grocy.

How about a list of the most recently used up/consumed products?

You can set a minimum stock per product, but that's for well-known staples. It can be useful to go back and look at what has just been used up to see if it should be purchased again.

from grocy.

Originally posted by @teitrand in #504 (comment)

I'd love to se some statistics on how much food goes to waste, and some functions to help reducing waste. Maybe get grocy to propose meals from the list of soon expiring food.

from grocy.

What about leftover tracking? I'm not exactly sure what this might look like, but such an analytic could certainly help confirm/adjust a recipe's servings. In other words, if only half the recipe was consumed, perhaps it makes double the servings you thought.

from grocy.

I think this is the feature I need the most and the only one I really care about. I don't think I can get my family on board to contribute to adding and removing inventory from stock. I care most about how much we spend a month/year on certain products. The data analytics side of things for budgeting purposes. Spotting trends or ways to save on buying things in bulk when there is a sale or coupons.

The product overview kinda does this with the chart that shows averages. I'm hoping to build something more granular with grand totals by year or month based on a timeframe you choose.

As in, I spent x amount on milk this year or x amount on toilet paper.

My local grocery store doesn't have an API but I spotted a sub request in my accounts "recent orders" page that contains the online orders summary in JSON. So now I'm immediately excited about the idea of using this json to scrape it and import it grocy-python https://github.com/SebRut/pygrocy into my grocy inventory.

I think the stock journal page is the most logical place to start with including the purchase price column. Not sure if the columns can by dynamic to make visible|invisible based on what you want to see. Then charting with pie|bar charts would probably need to be on it's own separate page. So perhaps in general a analytics page can handle all of this without needing to touch the stock journals page. Just brain storming and I can take this to r/grocy for further discussion.

from grocy.

Got my local dev setup and taking a look at the database. Seems everything is in stock_log. History of stock items, date purchased and quantity + price.

So no database schema changes to even start building out this level of reporting.

I'm thinking pie/bar charts of the product groups for accumulative purchases. Then breaking it down into product item level. Then adding a date range to filter.

from grocy.

I think there is no doubt and it's pretty clear that any "analysis page" will be about some charts somewhere and a date range filter.

Would be great to keep it at clear and concise (and at best small) topic related additions here (and also for other feature requests). If I or someone else starts working on this at some point and needs to read a book at the end, which is mostly a personal brainstorming story, is IMHO time wasting and brings nothing (please don't get me wrong on this).

When there are technical questions, please use the subreddit - I'm of course happy to answer anything which comes up, as always.

from grocy.

I'm starting a branch. Not sure if anyone else is actively working on it. Will start a subreddit if needed. Thanks.

from grocy.