Updating Price Books with an Effective date

It would be extremely useful (and time saving) if it were possible to update a price book from an effective date.

We have annual increases for a number of our price books and setting a future date for these to go into effect would be extremely worthwhile.

2 Likes

I agree. It feels like there should be a database table cross-referencing prices/product/date, (though that might be a bit complicated?) A record in this table would be added each time a product is created or the price of that product changes. For upcoming price changes it would be valuable, but additionally there would be another benefit: Sometimes we have to go back and create invoices for dates in the past if they’ve been missed at time of sale. If these are created using current pricing rather than the pricing that existed at the time of the actual sale, it can cause inaccuracies and billing discrepancies.
Here is another feature request that could be merged in potentially:
https://community.breww.com/t/can-we-have-a-delayed-price-book-implantation-
For us this isn’t a high priority (we don’t change our prices that often) but it does seem to make sense logically, and I could see how other breweries that change prices frequently would really want this. There also might be other benefits I’m not thinking about.

1 Like

This has come up a few times in the past. Usually, the workaround covers what’s needed, so building a new feature doesn’t seem to be required.

I’ll keep the thread open to gather votes so we can gauge interest (the others have been closed), but I’d highly recommend checking out some of the similar threads in the past and using the simple workaround mentioned in them:

Good Afternoon,

is there any progress on this being implemented ?

Our current system has effective pricing so it’s quite a backward step not to have this feature within the Breww system, can we not have an effective date added to a SQL column and a page change to get the known effective price ?

There are occasions where we input prices months in advance of a live date.

Thanks
Brian

1 Like

I agree that this would be a helpful feature, but I must admit that since the ability to bulk import prices from a spreadsheet was implemented late last year, I hadn’t been considering it particularly urgent.

Have you seen this feature (documented here)? It should mean that you can easily prepare the price changes in advance and then apply them in a couple of clicks first thing on the day that they need to go live. If this doesn’t work for you, can you let me know why?

Sadly, it’s far more complicated than this! If only it was this easy :smile:

I was asked the question internally as it’s something we have always had previously.

I really didn’t mean to overly simplify this request as I know that it’s not a simple task. I’ve had a look at the documented feature you advised and whilst this is handy someone has to remember to upload it on the day it takes effect.

We will just have to agree a way to manage this internally to ensure we don’t miss any price changes.

1 Like

Has there been an update to this? We ran into an issue this week where we had a product go on a Limited Time Offer, and invoices that were made in advance had the wrong pricing. Our prices have to match exactly what is shared with our governing body, and this can create discrepencies.

If we cannot bake it into the price book, is it possible to create a feature for timed discounts?

1 Like

There’s not been an update on this yet, but I do understand your use-case and why it would help you. Make sure to vote for this request to properly register your interest!