Bar Report: Products Tab — IZI CRM
Bar Report: Products Tab — Assortment Analytics in IZI CRM
Section titled “Bar Report: Products Tab — Assortment Analytics in IZI CRM”The Products tab inside IZI CRM’s Bar Report answers one core question: which menu items sell, in what volume, and for how much over any chosen period. Open the report and you immediately see which items drive most of your bar revenue, which are sitting idle, and — when purchase prices are set — the margin each item actually delivers. Attach rate tells you how often sessions end with a bar order; the Products tab explains what is inside those orders. For each item the report displays units sold and total revenue. That is enough to calculate the average selling price and flag discrepancies against your price list. To open it: Analytics → Bar Report → Products tab → set your date range in the filter.
What the table shows
Section titled “What the table shows”| Column | What it means | When it matters |
|---|---|---|
| Item | Product name from the bar catalog | Always |
| Units sold | Quantity sold in the period | Popularity ranking |
| Revenue | Total revenue from this item | Contribution to the till |
| Average price | Revenue ÷ units sold | Detects unauthorized discounts |
| Margin (amount / %) | Revenue − purchase cost | Only if purchase prices are set |
The table sorts by any column — build a revenue ranking or a margin ranking in one click.
The period filter works the same as in every other analytics section. Recommended slices:
- 7 days — current menu snapshot
- 30 days — stable pattern, smooths out anomalies
- Month-over-month — seasonal demand shifts
Business meaning: what an owner looks for
Section titled “Business meaning: what an owner looks for”Revenue concentration and margin leaders
Section titled “Revenue concentration and margin leaders”In most gaming club bars, 3–5 items generate 60–75% of revenue — that is normal and reflects the Pareto effect in assortments. The critical question is which items they are. If your revenue leader is also your lowest-margin product (bottled water, for example), the bar is working for turnover, not profit.
What to look for first:
Margin leader — an item with high margin percentage and meaningful sales volume. This item lifts bar profit. Typical candidates: coffee, house-recipe energy drinks, well-priced snacks. These items belong in every staff upsell script.
High-volume / low-margin item — sells a lot, earns little. It loads logistics and inventory while adding minimal impact to ARPU. Options: raise the price 5–10% if demand is inelastic, or replace with a higher-margin equivalent.
Parametric profitability index:
Profitability index = (Item margin ÷ Total bar margin) ÷ (Item revenue ÷ Total bar revenue)- Index > 1: the item earns disproportionately more than its revenue share — a bar asset
- Index < 1: the item pulls average bar margin down
Dead-weight items
Section titled “Dead-weight items”A product with zero or near-zero sales for 30+ days is not just a slow mover. It:
- Clutters the menu and makes choosing harder for guests
- Creates excess stock that may expire
- Takes up space in the IZI player app catalog
Checklist before removing from the menu:
- Is the item active in the IZI bar catalog?
- Does it appear in the player app?
- Is it mentioned in staff offer scripts?
- Does it serve a specific audience (children, late-night guests, dietary preferences)?
If all four answers are yes but sales remain zero — the item solves a problem your customers do not have. Remove it.
Average realized price vs. price list
Section titled “Average realized price vs. price list”If an item’s average price in the report is noticeably below its listed price, that is a signal:
- Staff are giving manual discounts without authorization
- A promo code is bleeding revenue — check the promo codes report
- The item is sold inside a combo and the price is split differently
Systematic under-pricing on a high-volume item is a fast way to lose margin without noticing it in day-to-day cash reconciliation.
Assortment decisions: a structured approach
Section titled “Assortment decisions: a structured approach”Decision matrix
Section titled “Decision matrix”| What the report shows | Diagnosis | Next action |
|---|---|---|
| High revenue + high margin | Star item | Keep prominent in menu, push in scripts |
| High revenue + low margin | Volume driver | Raise price or find a higher-margin substitute |
| Low revenue + high margin | Underperformer | Add to upsell script, improve visibility |
| Low revenue + low margin | Dead weight | Remove or replace |
| Zero sales in 30 days | Ghost item | Check catalog status and visibility, then remove |
Calculating margin when purchase prices are not yet in IZI
Section titled “Calculating margin when purchase prices are not yet in IZI”Item margin (%) = (Selling price − Purchase price) ÷ Selling price × 100%A parametric target for a gaming club bar is 50–70% blended margin across the assortment. Your actual figure depends on bar format, supplier prices, and club positioning. If blended margin is below 40%, revisit either the assortment or the price list.
For margin methodology and optimization detail, see Bar Margins.
Reading trends over time
Section titled “Reading trends over time”The most useful scenario is comparing two periods: before and after a menu change, a price adjustment, or a new staff script.
After a price increase. Raised the price on an item? Check back in two weeks: did volume drop, and by how much? If revenue went up — demand is inelastic and the increase passed cleanly. If revenue fell — guests in this segment are price-sensitive.
After adding a new item. Within 7 days the new item should have at least a handful of sales. Zero in the first week means it was not added to the player app or staff do not know about it.
Seasonal patterns. Hot drinks rise in autumn and winter, cold drinks in summer. Snacks are stable year-round. If your data does not show this pattern, the assortment is not adapted to the season.
Admin workflow
Section titled “Admin workflow”Practical routine for the start of a week or end of a month:
- Open Analytics → Bar Report → Products
- Set period: last 30 days
- Sort by Revenue — see your top 5 items
- Check: are the top items also the highest-margin ones?
- Find items with zero sales — determine the cause or propose removal
- Compare average realized price against the price list — any gaps?
If the club ran a recent promotion (combo with a tariff, a special offer), compare the current 30 days to the prior period: can you see a shift in the mix toward promotional items?
Related sections
Section titled “Related sections”The Products tab is one slice of bar data. For the full picture:
| What you need to know | Where to go |
|---|---|
| How a specific item moved through stock | Bar Movements Report |
| Current stock levels and turnover | Warehouse Report |
| Overall bar margin and markup | Bar Margins |
| Bar sales by shift | Shift Report |
| How many sessions included a bar order | Session Metrics |
Parametric methodology
Section titled “Parametric methodology”All formulas are parametric — substitute your actual figures.
Item share of bar revenue = Item revenue ÷ Total bar revenue × 100%
- Normal range for a top item: 15–30%
- Requires attention: > 40% (over-reliance on a single item)
Menu removal threshold (all three conditions simultaneously):
- Sales in 30 days: < 1% of total bar orders
- Item has been active in the menu for ≥ 30 days
- An alternative item with better metrics exists
Price increase upside index — estimates the revenue gain from a small price lift on a volume item:
Revenue gain = Units sold × Price deltaIf an item sells N units per month at price X, a 5% price increase yields N × X × 0.05 in additional monthly revenue. For high-volume items, even a small delta is meaningful.
New item payback period = Initial stock cost ÷ Expected monthly margin from the item. If you plan to sell 30 units per month at margin M per unit, and the opening stock costs S, payback = S ÷ (30 × M) months.
Frequently asked questions
What does the Products tab in the IZI bar report show?
The Products tab shows how many units of each menu item were sold during the selected period and how much revenue each item generated. If a purchase price is set on the item card, IZI also calculates margin and its share of total bar profit. This is the primary tool for assortment review and menu decisions.
How do I open the bar products report in IZI?
Go to Analytics → Bar Report → Products tab. Select the date range using the period filter. The table can be sorted by any column: quantity, revenue, or margin.
How is the Products tab different from the Movements tab?
The Products tab shows aggregate sales by item — how many were sold and for how much. The Movements tab shows every individual write-off and stock receipt, including manual adjustments. Use Products for assortment analysis, Movements for inventory tracking.
How do I find the most profitable items at the bar?
Sort the table by margin (if purchase prices are entered) or by total revenue. A margin leader is an item with a high margin percentage and meaningful sales volume. An item with high revenue but low margin drives turnover, not profit.
What should I do with items that have zero or near-zero sales?
First check: Is the item active in the bar catalog? Is it visible in the player app? Does staff mention it? If all three are yes but sales are still zero after 30+ days, the item is a candidate for removal. Dead-weight items clutter the menu and draw attention away from top sellers.
How can I use the report data to adjust pricing?
Compare revenue against sales volume. If an item sells frequently, a small price increase will meaningfully lift margin without a major volume drop. If an item rarely sells at a high price, either the price exceeds what your audience will pay or staff are not actively offering it.
Does attach rate affect what I see in the Products tab?
Not directly — the Products tab shows item-level sales, not session linkage. But a low attach rate means fewer orders overall, which you will see as low totals across all items. To analyze the session-to-bar-order relationship, use session metrics.
Can I compare product sales across two periods?
Yes — switch the period filter and compare manually, or export the data. IZI does not auto-build a two-period comparison table in this section, but data for any custom date range is available.
What does 'share of bar revenue' mean for a single item?
It is the percentage of total bar revenue for the period that this item contributed. An item with a 25%+ share is a pillar of your bar. If 2–3 items carry 60%+ of revenue, they are the bar's backbone. A very high concentration — one item above 50% — is a risk: remove it and bar revenue drops sharply.
How do I calculate attach rate from report data?
Attach rate = sessions with a bar order ÷ total sessions × 100%. Cross-reference bar order counts from this report with total session counts from the session report.
Do I need to enter purchase prices to use the Products tab?
No. Without purchase prices the report still shows units sold and revenue — enough to analyze popularity. With purchase prices, margin analysis is added. We recommend filling in purchase prices at least for your top items by revenue; that covers 70–80% of bar profit in one pass.