# Products available for sale report

The **Products available for sale** report gives you a live snapshot of the products you have available to sell, grouped by beer and product type. It's ideal for sharing an up-to-date availability list with your sales team.

## Where to find it

You can open the report from either:

* **Reporting** -> **Pre-built Sales reports** -> **Product availability** -> **Products available for sale**, or

* **Products** -> **Tools & reports** -> **Available products report**

## What the report shows

Products are grouped by beer (for packaged beers) and by product type (for everything else). For each product, the report shows:

* **Product code** and **Product name**

* **ABV**, where applicable

* **Available in format** - the quantity available in the product's current format

* **Max available** - the maximum quantity available if you assemble or disassemble stock from other formats (for example, assembling single cans into 12-packs). See [Understanding stock levels](https://breww.com/docs/understanding-stock-levels/) for more on how these figures are calculated.

* **Price** - the price from the selected price book, including any banding discounts

Either quantity can be negative, which means the product is **over-sold**: more has been committed to orders than you currently have in stock. Negative quantities are shown in red so that they stand out.

![The Products available for sale report, with over-sold products showing negative quantities in red alongside products that have positive stock](https://storage.googleapis.com/breww-user-uploads/markdown-embedded/10769a437fcbc0fce0f0734160283f221134818bbec527dca0c89f9f287047b1.png)

## Filtering the report

A row of filters at the top of the report lets you tailor what's shown. Each filter applies as soon as you change it:

* **Site** - show stock from all sites, or limit to a single site.

* **Price book** - choose which price book the displayed prices come from. Your default price book is selected automatically.

* **Type** - filter by a product type or a container type.

* **Stock availability** - choose which products to include, based on their stock level (see below).

### Choosing which products to include

The **Stock availability** filter has three options:

![The Stock availability filter showing its three options, with In-stock and over-sold products only selected](https://storage.googleapis.com/breww-user-uploads/markdown-embedded/eaeaa5406faf13644f89fba29b03a3f6230a177e87cf2cc9732fd70794ac06cf.png)

* **In-stock and over-sold products only** - the default. Lists every product with stock available, plus any product that is over-sold. Products sitting at exactly zero are hidden.

* **In-stock products only** - lists only products with a quantity available above zero. Over-sold products are hidden, as are products at zero.

* **Include out-of-stock products** - lists every product, whatever its stock level, including those at exactly zero.

The default keeps over-sold products in view, as these are usually a sign that something needs packaging or assembling before the orders can be fulfilled. Choose **In-stock products only** when you want an availability list containing nothing you can't currently supply, or **Include out-of-stock products** when you want your complete product list, including anything that has sold out.

## Exporting the report

Use the **Export** button to download the report as an Excel or CSV file. Exports always match the filters you have selected on screen, including the **Stock availability** filter, so if you have chosen to include out-of-stock products they will appear in the exported file too. Negative quantities are exported as plain negative numbers, without the red highlighting shown on screen.