Limit available product count to a single production site (available stock per site)

Would it be possible to have certain site locations not be included as ‘available’ product stock when preparing a sales order?

What we’d like to have is our remote warehouses, where moving stock on a daily or per order basis is impractical, be included in our total stock count, but not as part of our available count for our sales team. Essentially so they can’t confirm orders where the stock is not yet available at our main sales/shipping location.

Currently you can specify the default site location for POs, but would it be possible to add additional specifications, such as locations that stock can be sold from, and locations where stock can only be held / transferred?

Hi Ben,

Thanks for the suggestion. This would be a great feature for many applications.
We’re planning to implement a feature to handle this, and hoping we’ll be able to do this within the next couple of months. I’ll add another vote to the task on your behalf, and let you know when it’s done.

Cheers,
Matt

We have 2 locations for stock of products - brewery main which is the bonded store and shop & tap which is an un-bonded store. We transfer stock as required for use in the shop & taproom. Looking at the product page it shows towards the top of the page the stock available, but this is the total stock in the 2 locations. From a sales point of view this could lead to overselling with the sales person thinking all this stock is available for him to sell. It would be better to show the stock breakdown for the 2 locations so they know that a certain amount of the stock is reserved for the shop & tap for example. I know you can see that by scrolling down to the bottom and choosing locations but that is an extra operation they may not do.

Thanks for the suggestion, Rob.

Yes, you’re right, this would be a great addition and is certainly something we will be looking to implement. For this to be complete, we’ll also need to link orders to specific sites so that we can calculate an “available” quantity per site.

If this would be useful for others, please can you give this a vote too, to push it up the list :+1: This will also open the door to syncing the “available” stock for a single site to external platforms (such as only syncing available “Brewery” stock to Shopify).

P.S. I’m merging this with a related request, so the votes are combined.

not directly related but still in the Locations issue.
Make product/ stock transfers as function on Breww. Making these operation through the stock take with csv files is not very practical and very easy to make mistakes.

Just in case you’ve not seen it before, products can be moved within the web interface already (without needing a stock take), see How do I move products to a different location? for more information.

We also have high on the feature request list Stock transfer between sites/contract brewers/offsite packagers on delivery schedule (Stock Movement Documents) to improve this process. Thanks.

Hello,
thats great news but I tried to use now and it did not prompt me to choose the Lot I want to transfer.
I have different lots in stock. Can this be added, otherwise I still have to use the CSV file.
Thank you!

Ah yes, this can be done already, but to be prompted for which smallpack batch should be used, you need to have “Auto assign smallpack” disabled in your delivery settings. I realise this seems a bit silly, so I’ve already raised a feature request for Allow choosing of specific batches of smallpack stock to move between locations when auto-assign is enabled. Can you give this a vote?

In the meantime, assuming you do want to keep “Auto assign smallpack” enabled, you can briefly disable this each time that you need to move stock, but of course, we’ll look to split this setting up to save this hassle.

Cheers!

:tada: This has just dropped! You can now view your available stock on a per-site basis.

Find out more in our launch announcement:

Our Understanding stock levels (quantity in stock & available numbers) for products guide has also been updated to explain how the new numbers work. We hope this is useful for everyone and welcome any feedback :+1: Thanks to everyone involved in this thread for helping us to make Breww even better.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.