A great addition would to resolve the following limitation:
We currently have 100 cases of a beer in stock. We have a planned packaging scheduled next week for 400 cases of the same product. We have an order in for the week after that for 300 cases of the same product. This causes the product to show as being oversold by 200 cases NOW, and won’t let us add any to orders this week (or any time before the planned packaging next week), despite the fact the current availability is in fact 100 cases, as the order for 300 cases isn’t scheduled until after the planned packaging run of 400 cases.
Please let us know if this tweak would be helpful to you by using the vote button above.
We’re in a similar situation with some pending release - conditioning casks. We move some to our off site storage or presell some (ideally) but currently can’t do that with how Breww is set up. Definitely a useful feature if it can be worked in.
Hi Matt,
This would be very useful to us as we find ourselves adding orders and removing them to prioritise sooner deliveries which is not ideal!
Thanks,
Kieran
Yes please to this. We end up putting orders into spreadsheets and calendars to workaround this and we want everything to be in Breww
As it works currently, an order placed that’s intended for a future batch (after the next planned packaging) will cause the current batch to go out of stock. If it’s for cans, our web shop then goes out of stock which obviously impacts revenue.
We have a number of larger bulk orders that are put on well in advance. This is very much the case with lager products which have a long production time. For example between May-August we commonly have a number of larger orders for festivals and special events.
These orders will usually be put on as Pre Orders in Feb-March to help plan our production calander and in total may account for 250+ kegs/casks of our most popular beers. This means that from mid-March right the way through to the end of August all of the “Available Stock” figures in Breww for these products do not accurately reflect what I have available to sell that week. In some cases I might have 28 kegs of a beer in stock in the cold room, but be told I have -98 or more.
I need to manually list and account for all of the pre order stock, subract it from the total ammount of available stock, taking into account open orders going out in the short term.
This also applies to some packaged beer products. It would be great if changes could be made to help manage this. As currently putting on long-term pre orders hinders rather than helps.
We need this resolved quite urgently, as otherwise we are unable to use the “delayed racking releases” and “prevent over-selling” features effectively. Constant workarounds (e.g. releasing stock prematurely) are inelegant, prone to human error, and render the aforementioned features far less useful.
We’re new to Breww and have just come up against this issue. I’m surprised this is a feature request, because it’s essentially a non-functioning element of the system. We effectively have physically available stock that Breww won’t allow us to sell, and that’s not right.
It’s not a quirky situation, it’s part of everyday operation. We have stock, we have future production and orders, Breww should know how much we can sell ahead of the restock, and allow us to do that.
It’s a great system, we’re really happy to be on the platform, and the dev team are really responsive. I hope this can get sorted quickly, please.
As a workaround, we were wondering about creating some “pre-sale” products (out of stock automatically substituted by the real product). Create some inventory by a stock adjustment… then zero those stock levels when real stock is available. If we remember. So we can do pre-sales via Sellar. What could possibly go wrong
I don’t believe this has been mentioned before(apologies if it has) but what is the possibility on showing the “Delayed Racking Releases” batches or “Planned Packaging” stock to the list of options for “Assigning batches to orders” feature. This may help a lot of issues with available stock being taken up by large orders for future delivery.
This is crucial to fix in our view it’s a real pain point for us - almost a deal breaker in the system given there are future planned batches we just want to sell available stock and forward sell future batches without needing to ‘fudge’ the system. We use draft orders to allocate available stocks as multiple sales people need to prospect with available stock confidently and here ‘prevent overselling’ needs to be on.
This issue is we are prevented from adding or fulfilling ‘here and now’ orders due to having future orders on that is getting now stock allocated (even when we assign future batches on those orders).
The totality of stocks available now and in the future seems to merge and get messy.
We don’t want to have ‘prevent overselling’ off and the work around is to have to manually eye ball stock and then turn this off temporarily to add current orders to allocate available stock on ‘now’ orders.
This the current set up in the system seems flawed. We end up with negative stock levels in the future when there are planned packaging runs and we are unable to sell now stock due to future order.
As a new user this is the biggest hurdle in the system we have met so far. Sales teams want to sell until sold out on current and future stocks with ease knowing the numbers available are accurate without having to remember what we have sold to who when and do a lot of maths and thinking to ensure we aren’t over selling!
Would it be possible to have an update from the Breww team on this one please? I’m aware from previous discussions that it’s not an easy fix but I’m curious to know if it’s something that will be tackled at some point or your investigations have concluded that it’s not possible without major development work and therefore not likely to be addressed.
We’re still having to use calendar reminders and spreadsheets to work around this so we don’t book future orders which allocate current stock when the order doesn’t require the current stock. We’ve kind of got used to that but still make mistakes occasionally and sell stock we don’t have or miss out out sales because it wasn’t clear stock would be available in time.
The ideal solution for us would be that, when placing an order for a product which has both current stock and future stock under planned packagings, that Breww prompts you to select from which the order should allocate stock. A secondary very useful feature would be that when running e.g. the available products report, you could select a future date and show future stock from planned packagings. Very handy when booking/prospecting future sales, again without having to use spreadsheets to track things.
Agree with Andy - can we please have an update on this feature from teh Breww team?
We are effectively ‘punished’ by the system every time a large order comes in a week or two down the line, with our webshop and online portals going out of stock, and sales team unable to add further orders.
Turning off preventing over selling of stock is no use as…it leads to over sleling of stock!
I’m sorry for the slow response to this. We know this is important and we understand the impact it has. I’ve dropped the ball here by not replying sooner and I’m sorry for this.
The truth is that I’ve been putting off replying here with this update until I could find the time to discuss this fully with my team so I could reply with a helpful update. We’re now weeks on from Andy’s message, and we’ve not found the time yet to have that conversation (it’s not going to be a quick chat; we’re talking a good few hours to come up with a meaningful plan). We’ve been so busy with so many other things, that we just haven’t got to this yet (this is an extremely busy time of year for us).
I appreciate this isn’t what anyone subscribed to this thread wants to hear, but I wanted to be completely open and honest about the situation. The honest update is that we’ve made no progress at all, but we do intend to soon. We know it’s important, it’s not been forgotten, but it’s just not made it to the top of our priority list yet.
We’ll endeavour to prioritise this and make the time soon to work out how to solve it. Once we’ve done that, we can look to schedule the actual build. When we have a plan, we’ll post an update here (that, hopefully, has a bit more substance than this one).
Thanks Luke. Appreciate the honest update and look forward to hearing more soon. Addressing this one will be a huge time saver for many of us, I’m sure.
If draft sales orders did not allocate the stock or even require it to be in the system, I think this would solve the problem for us.
If Breww prevented orders being confirmed when the stock is not available rather than preventing it being added to the order in the first place, we’d just leave the order as draft until the stock was racked and ready for dispatch. This way the order could be added asap and would not get missed.
That’s a whole different FR. And I’m not saying it’s a bad idea, but this wouldn’t allocate stock from planned packagings either, presumably. Which is the main point here, surely?
This is already an option in Settings → Product settings
But the part about preventing confirmation without stock isn’t there at the moment. I agree this would be simpler to implement, but I also agree with Jon that I don’t think this will actually solve the problem. You could still easily accept too many draft orders and end up oversold when wanting to confirm them.
