Price books and pricing

Price books can be used to hold different product prices for various customers. Price books can be found in the Products section of Breww and can be very useful when updating pricing in bulk for customers or applying complicated discounts to products. Price books can be assigned to invoices, customers, customer types or customer groups. Breww will pre-populate the invoice’s pricing with the customer’s price book and if they do not have one then the Default price book in Settings → Order/Invoice settings will be used.

There are two types of price book in Breww. We highly recommend reading about both of them below before deciding which one is right for you.

Every pricing structure starts with a base price book. A base price book must have a specific price set for every active product. You can have multiple base price books for different pricing lines, such as your trade and retail pricing.

You may need to set up more than a single base price book that you can base rules on or simply create a new pricing structure that is not in any way derived from another. You can do this by doing the following:

Base price books are simple to set up, requiring an explicit price per product.

Any pricing variations from your bases are done by creating a derived price book, and selecting your base as a parent price book. Your new price book will start by inheriting all its prices from the parent price book. You can then apply rules or set explicit prices to override the parent's prices. When creating/editing a derived price book, you can toggle whether the parent's rules (if applicable) should be applied first or to simply bring forward the unmodified base price.

When setting up your pricing structure in Breww, you will always start with a single base price book (though you may create more). This initial price book is known as your "Standard" price book. While the standard price book may represent different things for different businesses, it essentially serves as the core price upon which other price books are built.

For example, you might create a derived price book for Trade customers that applies a flat 5% discount to the "Standard" prices of your products. To create a derived price book, follow these steps:

Next, you'll need to name your new derived price book (e.g., Trade) and set the parent price book. The parent price book is the price book your new derived price book will be based upon. This allows you to apply specific rules to the derived price book or inherit prices from the parent price book when no specific rule is set.

This means that any changes made to the prices in the parent price book will automatically update the derived price book. Discount rules set in the derived price book will be applied based on the updated prices in the parent price book, making price updates quick. Products without specific rules in the derived price book will inherit the updated prices exactly as they are in the parent price book.

You may add discount rules to derived price books. There are two types of rules you can add: simple discounts and quantity-based discounts. Both rule types allow you to specify which products the rule should affect, depending on product type, container type, or product tag.

The price to which these discount rules apply is the product's price inherited from the parent price book. If the parent price book is also a derived price book, please see the FAQ Can I set a non-base (derived) price book as a parent? below for an explanation of how the base price will be determined for the rule application.

Once you have successfully created a derived price book, you will arrive on your new pricebook's management page. From here you can begin creating your rules using the Add rule button at the top of the page, and you will have two types of rules to choose from:

Using a simple discount rule, you can apply a fixed discount (or addition) to your prices.

You can apply a variable discount (or addition) to your prices using a Quantity-based discount rule. Quantity-based rules consist of bandings that define the discount applied when purchasing within a certain quantity range of products.

You can start a quantity-based rule by defining the starting discount rate; in the example below, entering 2 for the number of products and a discount rate of 0% will set that no discount is applied when purchasing between 0 and 2 of my chosen products/containers (what the rules apply to is defined after the product quantity settings). You will want to ensure you click the + button after entering your number of products, discount and selecting a fixed value or percentage to create this banding.

You can then keep creating bandings, think of the "number of products" as an apply this discount up to figure, so If I added a number of products of 5 to with a discount of 2.5% to my above 0% up to 2 we will get: up to 2 at 0% and 3-5 at 2.5% discount, as below.

You can choose when defining a quantity-based discount rule, if the quantity used should be:

When using a quantity-based rule where you're counting the containers or units, special logic is applied to mixed packs. If the price book rule only applies to 330 ml cans, for example, and your mixed pack is for a 500 ml bottle and a 330 ml can, Breww will only count the can towards the rule. However, if the mixed pack is directly assigned to the price book rule (or "All products" is ticked), we will count all of the components regardless of the other aspects of the rule.

You can set multiple rules on a single price book. The first rule in the list that affects the product in question will be applied to the product's price. You can alter the order of your rule list using the button highlighted below. This allows you to set up complicated structures, like the one below, where if the product isn't matched by the first two rules, the final rule will apply.

To set an explicit price, click the button indicated in the screenshot below. This will override the current price and any rules in the price book that affect the product. The price entered will be the final price. To remove the explicitly set price, click the 'Remove' button. The price will then be redetermined, accounting for any rules that may now affect it.

You can assign price books to customer types, customer groups and directly to customer accounts.



You can assign a price book to a customer type by heading to Customers->Settings & tools->Customer types and selecting the edit pencil on a customer type.

To assign a price book to a customer group, then head to Customers->View->Customer groups and select the edit pencil on a customer group.

You can assign a price book directly to a customer by heading to Customers and selecting to view a customer account. If you then select Edit you will be able to select the price book from the drop-down menu under Customer details.

Yes, any price book can be set as a parent. A price book tree always starts with a base price book, to ensure that a price can always be inherited if not set directly, but you can have any number of derived price books.

If you go to the main price books page in Breww, you'll see a list of your price books, followed by a "flowchart" showing which price books are the parent to which other price books. This shows a bit like this:

Breww will use the "most specific" option that it can for the price book. For example:

Yes, firstly, when setting up a derived price book, you can choose to hide discounts on invoices, meaning the customer won't see this price increase represented on their invoice. You can also edit this later by selecting Actions & Tools->Edit basic details when on the price book. You can then add a simple rule with a minus discount to increase the price; for example, -10 would increase the price by 10%.

When you have duty-free pricing as well as a percentage discount, the final price is different depending on which you apply to the base price first. If you head to Settings -> Order/invoice settings you can chose your preferred method.