# Weekly unit sales and current stock report **URL:** \ **Category:** Ideas & feature requests\ **Created:** [29 June 2021 10:38 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302 "2021-06-29T10:38:37Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![matt-elliott](https://community.breww.com/user_avatar/community.breww.com/matt-elliott/32/103_2.png) [@matt-elliott](https://community.breww.com/u/matt-elliott)\ **Post date:** [29 June 2021 10:38 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/1 "2021-06-29T10:38:37Z")
Hi all, I’m trying to put together a custom report which would be super useful for brew schedule planning, but can’t figure out how to pull the right data out in a useful format. What I’m after is a summary of units sold by product, ideally split down by week over a couple of months, and along side that, a column reporting my current available stock level for each product. Essentially a report which allows me to, at a glance, measure up how much we have in stock against the rate at which we move through it, to help setting production priorities. I’m very happy to work through building it myself if someone can give me a bit of a hand with the BrewwQL code needed to get there - it feels like it’s a bit of a mashup of the existing ‘Total Sales by Product’ but split down by several periods, and ‘Products available for Sale’ reports. Thanks! ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [1 July 2021 11:12 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/2 "2021-07-01T11:12:05Z")
Hi there, Welcome to the Breww Community! If you take a look at the Stock allocation report, which can be found at Products \> Tools \> Allocation report, you’ll see a summary of stock levels by product, split by week or day, along with the current stock level. Would this work? If not, let me know and I’ll see if we can add something to show the number sold instead of stock levels. Thanks, Matt ---
**Author:** ![matt-elliott](https://community.breww.com/user_avatar/community.breww.com/matt-elliott/32/103_2.png) [@matt-elliott](https://community.breww.com/u/matt-elliott)\ **Post date:** [1 July 2021 11:37 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/3 "2021-07-01T11:37:21Z")
Hi Matt, Thanks for this - I’ve just had a quick look, but not sure if I’m missing something on how it ought to be working? The screenshot below shows what I’m seeing when I run that report for the last month, which appears to show my current stock but very little variation in any of the other lines despite us having moved through plenty in the weeks specified. It also seems to only include lines which have currently open orders, which limits how useful it’d be for stock and production management. For instance, if I run it for 1st-30th June (last calendar month) it returns no data because there are no open orders with allocations. ![Report](https://breww-community.fra1.digitaloceanspaces.com/original/1X/fc6ca8bd1875b24d6516af55d166b050ad4d97c1.jpeg) I think something which shows the number sold would be much more useful - that way I can see (based on past volumes) what I might expect to be moving through in the next ~x weeks, what I’ve currently got in stock (and potentially also in planned rackings?) and plan the production accordingly. Thanks! ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [2 July 2021 10:45 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/4 "2021-07-02T10:45:31Z")
Hi, Ah yes, that report may not be what you need after all. That report looks at the number of deliveries scheduled and number planned to be packaged that week to predict stock levels. We are planning on adding forecasting based on previous products sold as well, would that help you? Alternatively, you may find the Aggregate report - Products sold (order lines) helpful. If you set the data grouping to ‘Week’, the first metric to ‘Total item quantity’ and the First metric extra grouping to ‘Product’, that may be what you’re looking for? Please let me know if not, and we’ll sort something! Thanks, Matt ---
**Author:** ![matt-elliott](https://community.breww.com/user_avatar/community.breww.com/matt-elliott/32/103_2.png) [@matt-elliott](https://community.breww.com/u/matt-elliott)\ **Post date:** [15 July 2021 15:49 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/5 "2021-07-15T15:49:47Z")
Hi Matt, Thanks again for coming back on this and sorry for the slow reply! The Products sold (order lines) report is really helpful and gets me most of the way there, particularly if I download the raw data so I can pull an average weekly unit sales figure for each product line. Would there be any way of displaying an average on the chart for the time period specified to save downloading and calculating that manually? What I’m ideally looking for is an ability to calculate stock coverage - i.e. juxtapose that average unit sales figure against what I’ve currently got in stock to get a rough idea of how long it will last me at current sales rates. As it stands, I can get all of that data to figure that out - stock levels from ‘All Products List’ under the Products tab, and Average unit sales from the above report, but if there’s any way to get them in the same place so I don’t have to do all the intermediate steps it’d be amazing. Equally if I’m the only person who thinks this would be useful and it’s a big job for you guys, don’t sweat it too hard! Cheers, Matt ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [16 July 2021 10:19 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/6 "2021-07-16T10:19:52Z")
Hi Matt, We think this would be a good addition and shouldn’t take too long, so I’ll add it to the development list and let you know when we’ve made progress. Cheers, Matt ---
**Author:** ![Gemma](https://community.breww.com/user_avatar/community.breww.com/gemma/32/43_2.png) [@Gemma](https://community.breww.com/u/Gemma)\ **Post date:** [4 August 2021 09:49 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/7 "2021-08-04T09:49:35Z")
Hi, I’d like to put a vote for this too please as we’d find it really useful. Thanks, Gemma. ---
**Author:** ![ben-dumbreck](https://community.breww.com/user_avatar/community.breww.com/ben-dumbreck/32/268_2.png) [@ben-dumbreck](https://community.breww.com/u/ben-dumbreck)\ **Post date:** [6 August 2021 13:36 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/8 "2021-08-06T13:36:51Z")
Another vote here too. I’m currently having to do this via a spreadsheet. This would save a lot of time. ---
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [21 October 2021 15:07 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/9 "2021-10-21T15:07:44Z")
I’m delighted to say that the first iteration of our new forecasting tool is now live and ready to help make sure you never run out of stock again! Find out more on our launch announcement: > [@Beer stock availability forecasting bar\_chart tool now available](https://community.breww.com/t/beer-stock-availability-forecasting-tool-now-available/485): > > tada Breww has a brand-new beer stock availability forecasting tool! The tool replaces our original “Product allocation report” and builds on it to do so much more. This can be found at Reporting → Pre-built production & inventory reports → Stock availability forecast. You can choose when you’d like Breww to forecast until and how Breww should forecast future sales. Breww will then fast-forward time and show you when your current stock is expected to run out for all your beer products. We hope this is useful and look forward to your feedback 😀 ---
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [25 November 2025 09:55 UTC](https://community.breww.com/t/weekly-unit-sales-and-current-stock-report/302/10 "2025-11-25T09:55:32Z")
I just wanted to highlight here that the latest iteration of our [new forecasting tooling](https://breww.com/docs/saved-sales-forecasts/) is now live, in case you haven’t seen it. It allows you to automatically generate sales forecasts based on historical sales, and these can be built as either weekly or monthly forecasts. I know this isn’t exactly what has been asked for here, so I’ll keep this thread open, but I thought it would be useful for people looking at this thread to know about this update 😄