# Price book rules to include all products other than those matching the criteria (as opposed to only those matching it)

**URL:** <https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762>\
**Category:** Ideas & feature requests\
**Tags:** idea-not-required\
**Created:** [26 May 2026 13:01 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762 "2026-05-26T13:01:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![joe-pratt](https://community.breww.com/letter_avatar_proxy/v4/letter/j/e47774/32.png) [@joe-pratt](https://community.breww.com/u/joe-pratt)\
**Post date:** [26 May 2026 13:01 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/1 "2026-05-26T13:01:26Z")

</div>

All the settings for rules in price books are designed around including products/container types/tags etc. There is no setting to exclude a specific product. I know you can select all products in the drop down and then de-select, however, this is time inefficient. My brewery make a lot of limited release beers and if I used this setting I would have to manually add every release to every price book every time. I suggest a drop down menu titled “Products (excluding **any** of the following)” as an option for adding rules to price books. This would mean all new products are automatically added while one or more products can remain excluded.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [26 May 2026 15:36 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/2 "2026-05-26T15:36:14Z")

</div>

Thanks for the suggestion, Joe.

Why is it a problem that all products are included in all price books? If you have lots of base price books, a button should be shown that sets the price for all to £0.00 in one click, saving you from having to set a price on each one.

What is your reason for wanting to exclude products from price books - is it just to save time when creating new products (in which case, does this button resolve it for you)?

---

<div class="post-metadata">

**Author:** ![joe-pratt](https://community.breww.com/letter_avatar_proxy/v4/letter/j/e47774/32.png) [@joe-pratt](https://community.breww.com/u/joe-pratt)\
**Post date:** [8 June 2026 14:50 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/3 "2026-06-08T14:50:20Z")

</div>

Hi Luke,

Thanks for getting back to me and massive apologies for taking so long to respond! I didn’t check my “other” inbox until today.

Judging by your question, I think my request is unclearly phrased. I wish to make a rule in a derived price book that includes all but one product but automatically includes new products as they are added to Breww. Does this make more sense?

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [11 June 2026 14:03 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/4 "2026-06-11T14:03:36Z")

</div>

Thanks Joe, that makes sense. I’m sure it would be possible to update how price book rules are implemented to cover this scenario, but if you wanted one product to have a fixed price (assuming it should be a fixed price), you can just set a price on that item explicitly and this will take precedence over any rules (see [Setting explicit prices](https://breww.com/docs/price-books-and-pricing/#setting-explicit-prices)).

Does this cover what you need, or would you still need the rule that excludes a product?

---

<div class="post-metadata">

**Author:** ![joe-pratt](https://community.breww.com/letter_avatar_proxy/v4/letter/j/e47774/32.png) [@joe-pratt](https://community.breww.com/u/joe-pratt)\
**Post date:** [11 June 2026 14:54 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/5 "2026-06-11T14:54:17Z")

</div>

Thank you Luke! That is the fix I’m using just now as a stop gap but it’s not really a fixed price that I need, more a fixed percentage discount. I would still prefer a rule that excludes a product.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [11 June 2026 15:06 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/6 "2026-06-11T15:06:53Z")

</div>

Thanks for the quick reply, Joe. If you need one rule for that product and another rule for all other products, you can add both rules. Just make sure the rule targeting that one product is above the all-products rule in the list (use the “Edit rule order” button).

Each product on a price book can only ever have one rule apply. Breww will check each product to see if it matches a rule by looking through the rules in the order you’ve set. As soon as a rule matches, that rule will apply (and Breww will stop checking other rules).

Does this do what you need?

---

<div class="post-metadata">

**Author:** ![joe-pratt](https://community.breww.com/letter_avatar_proxy/v4/letter/j/e47774/32.png) [@joe-pratt](https://community.breww.com/u/joe-pratt)\
**Post date:** [23 June 2026 12:15 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/7 "2026-06-23T12:15:06Z")

</div>

Sorry for the slow reply - I have actually turned off “sort messages into focussed and other” in outlook because of this.

Luke, that is EXACTLY what I needed to know. I realise now that I could have figured this out for myself by looking more closely. Apologies and thank you for your time!

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [24 June 2026 09:03 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/8 "2026-06-24T09:03:35Z")

</div>

No problem, and I’m delighted to know this has done the trick for you! Thanks for confirming!

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [24 June 2026 09:03 UTC](https://community.breww.com/t/price-book-rules-to-include-all-products-other-than-those-matching-the-criteria-as-opposed-to-only-those-matching-it/6762/9 "2026-06-24T09:03:48Z")

</div>


