Price books - set prices per product type / ABV (rules to set a fixed price instead of a discount)

Ideas & feature requests
1

We have a lot of beers we produce and guest beers.

We have a lot of customers where we operate a pevel of fixed pricing, either:

X per cask
Y per keg

Or

X per cask up to 5.1% + £1 per 0.1%
Y per keg up to 5.1% + £1 per 0.1%

Or a straight price per ABV model (eg stonegate, and spoons do something similar):
3.7% cask X
3.8% cask Y
3.9% cask Z

etc

The stonegate model in particular i’d expect to be a pretty widely needed - and if this was done, we could actually use it to handle the other two cases.

1 Like
Managing price books via API or import
Extending the use of rules in price books
2

Could you do something like this with price book rules and product tags (for the abv bands)?
Disclaimer: I haven’t tried.

1 Like
3

Thanks for the request Craig and the suggested solution, Jon. Jon’s suggestion with tags would do the trick :+1:

I’m sure it would also be possible to allow another type of filter in the rules of an ABV range for the rule to apply to, so we’ll keep this request open for the implementation of that.

If anyone else would like to see this, please give this a vote with the button in the top-left :ballot_box:

4

Hi, i’ve just tried to take a look at this.

I can see that you can do a % or flat discount, based on tags, but I’m looking to fix the price.

I.e. everything 4.5% and under, £75.

I can’t do it via a flat or % discount, as the affected beers have different pricing.

5

Ah, I see, so you need to be able to create a rule that sets an exact price, rather than applying a discount to a parent price?

6

Correct. Tagging the products and setting price by tag would be an acceptable way to do it, although ABV would be easier for us!

1 Like
7

I guess to create a rule that sets an explicit price (kind of) we’d have to use a simple discount off some price that’s easy to do sums with.

So, if you need a price of £99.00 (for some products) you could start off with a base price book that’s all zeros - that’s easy, since that’s what a new base price book defaults to, I think.

Then derive from it a new price book with your rule (bound to your abv tag) which adds a simple negative discount (-99.00).

Add more rules for other abv bands / tags.

1 Like
8

I guess if you just allowed us to set price book pricing via an import, or the API, anyone could then do their pricing how they see fit? And you would need to add lots of different pricing mechanisms.

1 Like
9

That probably would be useful. You should vote for the relevant FR:
Data upload price books (import prices from a spreadsheet) - Ideas & feature requests - Breww Community

1 Like