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 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.
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:
-
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.